Microsoft Access 2016 Foundation Training Course Outline

Microsoft Access Training CoursesThis one-day course covers the basic functions and features of Access 2016. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. For comprehensive certification training, students should complete Access 2016: Basic, Intermediate, and Advanced.

 

 

Course objectives

After completing this course, students will know how to:

  1. Organise data efficiently by using a database management system; start Access and open Access databases; and use the Help feature.
  2. Plan and create a database; use Datasheet view and Design view; and create tables and work in tables.
  3. Modify a table's design; use the attachment data type; find and replace data; sort, filter, and delete records.
  4. Set field properties, create input masks, and set validation rules.
  5. Create queries, and sort and filter the results; modify queries; and perform operations in queries.
  6. Create, modify, and work with forms; and use them to sort and filter records.
  7. Create reports by using the Report button, the Report Wizard, Design view, Layout view, and queries; modify and print reports.

Course contents

Getting started 
Topic A: Database concepts 
Topic B: Exploring the Access environment

Databases and tables
Topic A: Planning and designing databases 
Topic B: Exploring tables 
Topic C: Creating tables 

Fields and records 
Topic A: Changing the design of a table 
Topic B: Finding and editing records 
Topic C: Organizing records

Data entry rules
Topic A: Setting field properties 
Topic B: Working with input masks 
Topic C: Setting validation rules 

Basic queries
Topic A: Creating and using queries 
Topic B: Modifying query results and queries 
Topic C: Performing operations in queries 

Using forms
Topic A: Creating forms 
Topic B: Using Design view 
Topic C: Sorting and filtering records 

Working with reports
Topic A: Creating reports 
Topic B: Modifying and printing reports 

Prerequisites

Before taking this course, you should be familiar with personal computers and the use of a keyboard and a mouse. This course assumes that you've completed a Windows: Basic course or have equivalent experience.

Target Audience

Youshould be comfortable using a personal computer and Windows XP or later. You will get the most out of this course if your goal is to become proficient using the features of Microsoft Access, including the tables, forms, reports, and filters.

Certification Track

For comprehensive training, you should complete all of the following courses: Access 2016: Basic, Access 2016: Intermediate, and Access 2016: Advanced.