What is a query and how do I create one?
A query is the method used to extract data from the database. When you create a query, you decide which fields you want returned based on selections and criteria. To create a query, first click on the “Queries” tab in the main interface and then click the button that is labeled “new.” You will be presented with a dialog box like the one below. Click on “design view” and click the “OK” button. The first thing you will see is the “Show Table” dialog box. Here, Access is asking you to tell it which tables will be included in this query. For example, if you had a customer’s address information in the Customer table and the purpose of your query is simply to compile a mailing list, then you would only need to include the Customer table. Another example would be if the order table contained only a customer’s ID number and the product ID numbers of the products they ordered. Both ID numbers reference the other tables. If you wanted to have the output of the query include information such as t
