Information Technology

Access 2016 Level 1

Course Code: 01-04-D731

Come and learn the advantages of using a relational database program, like Access, and what it can do for your business processes. This class will cover the basic operations of Microsoft Access including creating new databases and modifying existing ones. You will also practice creating tables and establishing relationships among them; creating and maintaining records; locating records; and producing reports based on the information in the database.

Performance Objectives: Upon completion of this course, you should be able to:

  • Identify the components of the Microsoft Access 2016 environment.
  • Explain the components of a database.
  • Organize data in tables.
  • View data in tables.
  • Query a database.
  • Work with queries.
  • Design elementary forms.
  • Generate simple reports.

Competencies Covered: Creating and using Access 2016 databases

Intended Audience: Public service employees

Recommended Prerequisite: To be successful in this course, you should be familiar with using a mouse and keyboard. You should also be comfortable launching and closing programs, navigating to information stored on the computer, and managing files and folders.