This two day course focuses on the design and construction of an Access database — viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.

2 days - $595.00

Course taught by an expert Microsoft Access Instructor.

Prerequisites:

Basic knowledge of a personal computer is required.

Course Outline

Getting Started with Access
Launch Access and Open a Database
Use Tables to Store Data
Use Queries to Combine, Find, Filter, and Sort Data
Use Forms to View, Add, and Update Data
Use Reports to Present Data
Get Help and Configure Options in Microsoft Access

Creataing Tables
Plan an Access Database
Start a New Access Database
Create a New Table
Establish Table Relationships

Creating Queries
Create Basic Queries
Perform Calculations in a Query
Sort and Filter Data in a Query

Creating Forms
Start a New Form
Enhance a Form

Creating Reports
Start a New Report
Enhance Report Layout

Promoting Quality Data Input
Restrict Data Input Through Field Validation
Restrict Data Input Through Forms and Record Validation

Improving Efficiency and Data Integrity
Data Normalization
Associate Unrelated Tables
Enforce Referential Integrity