Microsoft Access 2016 (Level 1)

Audience Profile

This course is designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. This Level 1 course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database.

At Course Completion

Upon successful completion of this course, students will be able to:

• Identify the components of the Microsoft Access 2016 environment.
• Identify the components of a database.
• Organize data in tables.
• Change the design of a table
• Organizing records
• Set field properties
• Set validation rules
• Create and modify queries
• Create forms
• Sort and filter data

Prerequisites

To be successful in this course, students should have a basic understanding of the Windows operating system, including how to launch an application and create and save files. Some knowledge of basic database concepts is also helpful.