Objective group 3. Create queries
The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Access 2016 relate to creating and using queries. Specifically, the following objectives are associated with this set of skills:
3.3 Create calculated fields and grouping within queries
Queries help you analyze data, locate records that match specific criteria, and manage database records. For example, you can run a query to delete records or to append data to a table. With a select query, you can view a specific set of records (for example, only orders placed within the past 90 days that exceed a certain dollar amount). Queries also provide ways with which you can calculate totals and ...
Get MOS 2016 Study Guide for Microsoft Access now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
