Microsoft Access Level 1

Learning Objectives

On completion of this course, you will be able to:

• Understand the concepts of database design and how a relational database works in Access.
• Build tables, working with fields and field types with an understanding of indexing and how to assign Primary Keys.
• Manipulate and navigate tables and records using filtering and sorting tools.
• Use forms to make it easier to view, access and input data.

Pre-Requisites

To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Course Contents

• Access 2016 database concepts.
• Opening a database and security issues.
• Tables
• Fields and field types.
• Table navigation and modification.
• Field properties.
• Manipulating tables and records.
• Primary keys and indexing.
• Filtering within Access 2016.
• Sorting within Access 2016.
• Searching within Access 2016.
• Access 2016 forms.