This 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.
After completing this course, students will know how to:
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
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.
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.
For comprehensive training, you should complete all of the following courses: Access 2016: Basic, Access 2016: Intermediate, and Access 2016: Advanced.