Access 2016 - Level 1

Students enrolled in this course will learn to identify the components of a database, open a table and find information stored in it, create & customize table designs, enter data & validate using input validation formulas, create relationships between...

Course Outline

Students enrolled in this course will learn to identify the components of a database, open a table and find information stored in it, create and customize table designs, enter data and validate using input validation formulas, create relationships between tables to ensure data accuracy and deploy referential integrity. Other topics include creating forms for entering data into tables, creating, editing, running queries, creating, enhancing, and previewing reports, and importing/exporting data to and from various sources.

Prerequisites
Good understanding of Windows and Microsoft software

Course Content
The Basics

Database Concepts
Getting Started
Creating a Database
Converting Access 2010 Files
Working with Objects
Using Access Help

Table Data
Table Concepts
Viewing Data in a Table
Changing the Datasheet Appearance
Entering and Editing Data
Applying Filters

Table Design
Creating a Table
Changing the Table Design

Data Entry
Data Entry Concepts
Data Formats
Input Masks
Input Validation
Adding Records

Relationships
Relationships Between Tables
Creating a Relationship
Referential Integrity
Removing a Relationship
Printing Relationships

Creating and Using Forms
Creating a Form Using AutoForm
Creating a Form Using the Form Wizard
Creating a Form in Design View
Opening a Form
Changing a Form Design
Adding Controls
Placing Controls
Multiple-Choice Controls
Error Checking

Queries
Using the Query Wizard
Creating a Query in Design View
Selecting and Sorting in a Query
Calculations
Action Queries
Parameter Queries

Reports
Creating Reports
Using the Report Wizard
Previewing Reports
Creating Reports in Design View
Changing Report Design
Control Operations
Control Attributes

Importing and Exporting Data
Importing and Exporting
Importing a Text File
Importing Data from an Access Database
Exporting Data
Troubleshooting Importing and Exporting Problems

Printing
Printing Objects
Print Preview

Training Location

Online Classroom
.

., .
.