documentation.HELP! Microsoft Query Documentation

Use keyboard shortcuts in Microsoft Query

Microsoft Query

previous page next page

Use keyboard shortcuts in Microsoft Query

What do you want to do?

Move in the Microsoft Query panes by using shortcut keys

Select data and criteria by using shortcut keys

Edit data and criteria by using shortcut keys

Use function keys in Microsoft Query

Use shortcut keys in the OLAP Cube Wizard

previous page start next page

Menu

  • Homepage

Table of contents

  • Getting Started
    • About using Microsoft Query to retrieve external data
  • Getting Help
    • Get program information about Microsoft Query
  • Keyboard Shortcuts
    • Use keyboard shortcuts in Microsoft Query
    • Move in the Microsoft Query panes by using shortcut keys
    • Select data and criteria by using shortcut keys
    • Edit data and criteria by using shortcut keys
    • Function keys in Microsoft Query
    • Use shortcut keys in the OLAP Cube Wizard
  • Installation and Data Sources
    • Install an ODBC driver so that you can access an external data source
    • Install OLAP providers
    • Setting Up Data Sources
      • Databases you can access
      • Specify a source to retrieve data from
      • Set up a data source that uses the Microsoft Access driver
      • Set up a data source that uses the Microsoft dBASE or FoxPro driver
      • Set up a data source that uses the Microsoft Excel driver
      • Set up a data source that uses the Microsoft ODBC for Oracle driver
      • Set up a data source that uses the Microsoft Paradox driver
      • Set up a data source that uses the Microsoft SQL Server driver
      • Set up a data source that uses the Microsoft SQL Server OLAP Services driver
      • Set up a data source that uses the Microsoft text driver
  • Creating, Opening, and Saving Queries
    • About creating a new query
    • Create a new query
    • Create a parameter query
    • Open a query
    • Save a query
    • Run, view, or edit an SQL command, procedure, or statement
  • Running Queries
    • Run a query automatically, or wait to run the query at a later time
    • Return a result set to Microsoft Excel
    • Execute an SQL statement or procedure
  • Creating and Connecting to OLAP Cubes
    • About OLAP queries
    • About creating an OLAP cube from relational data
    • Create an OLAP cube from relational data
    • Change content and settings of an OLAP cube
    • Delete an offline cube file
  • Changing Queries
    • Adding and Removing Tables and Fields
      • Add a table to a query
      • Delete a table from a query
      • Add or remove a field
      • Run, view, or edit an SQL command, procedure, or statement
    • Creating, Changing, and Removing Joins
      • Retrieve related records from multiple tables with joins
      • Retrieve records from multiple tables
      • Combine all the data from two tables
      • Retrieve records that two tables don't have in common
      • Create an outer join
      • Create an inner join
      • Create a self-join
      • Operators in joins
      • Remove a join
  • Limiting the Data You Retrieve
    • About using criteria
    • Limit the records you retrieve by using criteria
    • Specify what records to retrieve by using criteria
    • Retrieve records that match a specific value
    • Restore the full result set by removing criteria
    • Using Expressions
      • About expressions
      • Examples of expressions
      • Examples of expressions that use arithmetic operators
      • Examples of expressions that use comparison operators
      • Examples of expressions that use logical operators
      • Examples of expressions that use other types of operators
  • Creating Calculated Fields
    • Create a calculated field
    • Create a calculated field by using an expression
    • Create a calculated field by using a function
    • Functions you can use in a calculated field
  • Changing the Result Set
    • Change the layout of a result set
    • Format data in Microsoft Query
  • Finding, Sorting, and Reviewing Data
    • Go to a specific record in the result set
    • Sort records in a query
    • View different fields in a query
  • Changing Data in a Queried Database
    • About making changes to data in a queried database
    • Make changes to data in a queried database
  • Using Dynamic Data Exchange (DDE)
    • Use Dynamic Data Exchange (DDE) with Microsoft Query
    • DDE commands
  • Troubleshooting
    • Troubleshoot Microsoft Query
    • Troubleshoot OLAP queries and cubes
    • How Microsoft Query handles year 2000 dates

Get in touch

Submit feedback about this site to:

  • [email protected]

© documentation.help. Design: rehmann.co.