Access databases are made up of database objects: tables, queries, forms, reports, and supporting objects such as macros. In Objective 1.1 from MOS 2016 Study Guide for Microsoft Access, learn how to create a database from a template, as well as how to import objects and data.
The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Access 2016 relate to creating and managing databases. Specifically, the following objectives are associated with this set of skills:
- 1.1 Create and modify databases
- 1.2 Manage relationships and keys
- 1.3 Navigate through a database
- 1.4 Protect and maintain databases
- 1.5 Print and export data
Many of the operations and tasks involved in creating and managing Access databases originate in the Backstage view. For example, the New page includes templates that you can use to create a database, and a search box that you can use to locate other templates. The Info page provides commands that help you maintain and protect a database. Beyond the specific commands you use, Access also offers a way to back up a database, which is a critical step in ensuring that data is available in the event of an accident or a security incident. By taking steps to make database navigation clear and logical, you help ensure that the database’s users have an easy time keeping the data current.
This chapter guides you in studying ways to create and modify databases, manage relationships and keys, navigate through a database, protect and maintain a database, and print and export data.