Queries allow you to find data that meets a certain criteria. For example, all red cars made before 1990 or all laptops less than $1000. You can use queries in both the table and form data views. To begin querying, go to either one of those views then press the "query" button in the toolbar.
The query view will then slide out:
The query view has two components:
- At the top are buttons to open, save or rename queries. Save a query to access it later. When a query is saved, its name will appear next to the rename and open buttons.
- Parameters are certain conditions the data must satisfy. Each parameter has a field name, the type of test and value. For example: "Product Name", "is equal to" and "iMac".