Microsoft Access 2016 Essentials

Learners will gain a fundamental understanding of this database application's environment and basic database principles. They will be able to demonstrate the correct use of key features and the ability to create and maintain tables, relationships, forms, reports, and queries. ACCESS 2016 ESSENTIALS COURSE OUTLINE: Module One: Create and Manage a Database Create and Modify Databases Create a blank desktop database Create a database from a template Create a database by using Import objects or data from other sources Delete database objects Manage Relationships and Keys Create and modify relationships Set the primary key Enforce referential integrity Set foreign keys, view relationships Navigate through a Database Navigate specific records Create and modify a navigation form Set a form as the startup option Display objects in the Navigation Pane Change views of objects Protect and Maintain Databases Compact a database Repair a database, back up a database Split a database Encrypt a