MOS ACCESS 2016 ESSENTIALS COURSE

The MOS Access 2016 Essentials Online Course consists of the following modules:

Lesson 1 - Creating and Managing Databases

• Introduction;
• The Access 2016 Application;
• Creating & Modifying Databases;
• Managing Relationships & Keys;
• Navigating Through A Database;
• Protecting & Maintaining Databases;
• Printing & Exporting Data;
• Lesson Review & Quiz;
• Assignment 1 - Creating & Modifying Databases Exercises.

Lesson 2 - Building Tables

• Introduction;
• Creating Tables;
• Managing Tables;
• Managing Records In Tables;
• Creating & Modifying Fields;
• Lesson Review & Quiz;
• Assignment 2 - Database Table Exercises.

Lesson 3 - Creating Queries

• Introduction;
• Creating Tables;
• Managing Tables;
• Managing Records In Tables;
• Creating & Modifying Fields;
• Lesson Review & Quiz;
• Assignment 2 - Database Table Exercises.

• Introduction;
• Creating Forms;
• Configuring Form Controls (1);
• Configuring Form Controls (2);
• Formatting Forms;
• Lesson Review & Quiz;
• Assignment 4 - Forms Exercises.

• Introduction;
• Creating Reports;
• Configuring Report Controls;
• Formatting Reports;
• Lesson Review & Quiz;
• Assignment 5 - Report Exercises;
• The MOS Examination.

Assessment:

You will be assessed on assignments which are detailed in the course materials. These assignments will require you to create work on, create and edit database files. Your work can be sent back to your course tutor by email.