Microsoft Access Course Outline

Course Name: Microsoft® Access
Duration: 2.00 Day(s)
Overview: In this course, you will use Microsoft® Access to design, create, and distribute Access databases
Attendees: The Access course is designed for those preparing for certification as a Microsoft Access user, who already have knowledge of the Microsoft® Windows operating system, and/or who desire to gain the skills necessary to design, create, and distribute Microsoft Access databases.
Objectives: You will have the ability to design, create, and distribute Microsoft Access databases.
Course Outline:

Introduction

1. Structuring Databases

	Creating Access Databases
	Create and Modify Tables
	Define and Create Field Types
	Modify Field Properties
	Create and Modify One-to-Many Relationships
	Enforce Referential Integrity
	Create and Modify Queries
	Create Forms
	Add and Modify Form Controls and Properties
	Create Reports
	Add and Modify Report Control Properties
	Create a Data Access Page
	Review

2. Entering Data

	Enter, Edit, and Delete Records
	Find and Move Among Records
	Import Data to Access
	Review

3. Organizing Data

	Create and Modify Calculated Fields and Aggregate Functions
	Modify Form Layout
	Modify Report Layout and Page Setup
	Format Datasheets
	Sort Records
	Filter Records
	Review

4. Managing Databases

	Identify and Modify Object Dependencies
	View Objects and Object Data in Other Views
	Print Database Objects and Data
	Export Data from Access
	Back Up a Database
	Compact and Repair Databases
	Review