Chapter 3. Create Queries
The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Access 2013 relate to creating and using queries. Specifically, the following objectives are associated with this set of skills:
|3.1 Create a query|
|3.2 Modify queries|
|3.3 Utilize calculated fields and grouping within queries|
Queries help you manage database records, locate records that match specific criteria, and analyze data. For example, a make-table query or an append query (two types of action queries) are often used to archive records. With a select query, you can retrieve records for all orders or add criteria to select a specific set of records (for example, only orders placed within the past 90 days that exceed a certain dollar ...