This course includes an introduction to the Microsoft Access 2016 interface. It covers the various aspects of database creation and management in Access 2016

This Introductory course contains five basic modules on

how to create and manage databases T

how to create tables

how to create different queries

how to create and design forms

and how to create reports

The various modules presented in this document will help you to build a solid knowledge foundation of the software.

The booklet in the form of pdf is the companion document to the Intro to Access 2016 workshop.

Each module begins with a video and textual overview of the material, followed by a Assignment, which takes you step-by-step through a hands-on database example of the chapter contents. Each module has around ten assignments to practice and be expert to proceed to next module. All assignment resources are available with each module. Each module has quiz related to its topic.At the conclusion of most chapters, you have the opportunity to complete an Applied assignment and quiz to check your knowledge and application of the material learned.

After completing all the modules and following instructions in the companion , you will be able to

• Identify the components of the Access 2016 interface

• Create a new database

• Understand how to create a table

• Understand the purpose of the primary key

• Enter descriptions for fields

• Understand how to add validation rule in the fields

• Understand how to enter various types of data into the table

• Understand how to create a Query

• Understand how to create a Form

• Understand how to create a Report