MOS 2016 Study Guide for Microsoft Access

Objective group 2. Build tables

The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Access 2016 relate to building tables. Specifically, the following objectives are associated with this set of skills:

2.1 Create tables

2.2 Manage tables

2.3 Manage records in tables

2.4 Create and modify fields

When you create a database, before you use Access to create tables, forms, and other database objects, it is helpful to define the tables you need, the fields that will be in each table, and how the tables are related. Considering details such as these makes the process of creating tables in Access more efficient.

You build tables by defining the table’s fields and specifying data types for each field, such as Number, ...