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.