documentation.HELP! Microsoft Query Documentation

Create a new query

Microsoft Query

previous page next page

Create a new query

What do you want to do?

Create a query by using the Query Wizard

Create a more complex query in Microsoft Query

Create a parameter query

Not sure which choice you want?

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.