Share via

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

  • Article

query

A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form, report, or data access page.

In a Microsoft Access database (.mdb), you can create a query, which is stored as a separate object and listed in the Database window. Or you can create a query as an SQL statement in the RecordSource property of a form, report, or a section of a data access page. An SQL statement is not listed in the Database window; it's stored in a form or report in an Access database, or in a data access page outside the Access database.

In a Microsoft Access project (.adp), you can create a query as a view or stored procedure, which is listed as a separate object in the Database window. Or you can create a query as an SQL statement in the RecordSource property of a form, report, or a section of a data access page. Views and stored procedures are stored in the Microsoft SQL Server database, not in the Access project. SQL statements are stored in a form or report in the Access project, or in a data access page outside the Access project.