On the Create tab, in the Query group, click Query Design. You can create a query that returns orders for customers in a particular city, for example, Las Vegas, by using the following procedure: If each table has a Customer ID field, which forms the basis of a one-to-many relationship between the two tables.
Say that the data about orders and data about customers are stored in two tables named Customers and Orders respectively. Top of Page Review data from multiple related tables simultaneouslyįor example, if you have a database for a store that sells food items and you want to review orders for customers who live in a particular city. The query runs, and displays a list of products and their prices. Double-click the Product Name and List Price to add these fields to the query design grid. In the Products table, let’s say that you have Product Name and List Price fields. On the Tables tab, double-click the Products table. Open the database and on the Create tab, click Query Design. Review data from select fieldsįor example, if your database has a table with a lot of information about products and you want to review a list of products and their prices, here’s how you’d create a select query to return just the product names and the respective price: For more information, see create a simple select query. If you want to review data from only certain fields in a table, or review data from multiple tables simultaneously or maybe just see the data based on certain criteria, a select query type would be your choice. Action queries are not available in Access web apps. Each task has a specific type of action query.
To retrieve data from a table or make calculations.Īdd, change, or delete data. Since queries are so versatile, there are many types of queries and you would create a type of query based on the task. A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database. A query can either be a request for data results from your database or for action on the data, or for both.
A query can pull the information from various tables and assemble it for display in the form or report. In a well-designed database, the data that you want to present through a form or report is usually located in multiple tables. Queries help you find and work with your data Note: If you want to try out the queries in the examples, use an Access desktop database.