MOS Study Guide for Microsoft Access Expert Exam MO-500

Objective group 2

Create and modify tables

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 managing tables. Specifically, the following objectives are associated with this set of skills:

2.1 Create tables

2.2 Manage tables

2.3 Manage table records

2.4 Create and modify fields

When you create a database, Access automatically creates a new table that you can use to enter data by hand. You can also create your own tables as needed. However, for many database applications the data already resides in some other format, such as an Excel spreadsheet, an HTML document, a text or XML file, or another database. In that case, it’s easier and faster ...