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:
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 ...