MOS Study Guide for Microsoft Access Expert Exam MO-500

Objective group 3

Create and modify queries

The skills tested in this section of the Microsoft Office Specialist Expert exam for Microsoft Access 365 and Microsoft Access 2019 relate to creating and using queries. Specifically, the following objectives are associated with this set of skills:

3.1 Create and run queries

3.2 Modify queries

If you have a large amount of data in a table, you will not usually want or need to work directly with the raw data. Instead, it is better to work with data that has been sorted and filtered in some way, two operations that you can quickly combine by creating a query. Although the name implies that queries are a sort of question, it is more useful to think of them as requests. In the simplest case, a query