Course Outline

MS Access 2010

This is a typical 1 day course split up into 5-10 minute lessons so you can follow the outline in sequence or jump to the topic you want to learn about. Typically, a course outline will contain on average 35 Bite Size lessons. Remember to practice your new found skills. This will help to reinforce the learning and retain your skills.

Getting Started
Lesson not Started  The Access Environment
Lesson not Started  Getting Help
Lesson not Started  The File Tab & Backstage View

Databases
Lesson not Started  Explaining Databases
Lesson not Started  Planning & Designing a Database
Lesson not Started  Creating a new Database
Lesson not Started  Opening and Closing Databases
Lesson not Started  Navigating around Database Objects
Lesson not Started  Saving Databases
Lesson not Started  Opening Templates

Working with Tables
Lesson not Started  Datasheet & Design Views
Lesson not Started  Creating Tables using Design View
Lesson not Started  Field Properties
Lesson not Started  Setting a Primary Key
Lesson not Started  Creating Tables by entering Data
Lesson not Started  Re-sizing Columns
Lesson not Started  Adding new Records/Fields to an existing Table
Lesson not Started  Saving Tables

Fields and Records
Lesson not Started  Explaining Fields & Records
Lesson not Started  Editing Records
Lesson not Started  Finding Records
Lesson not Started  Sorting Records
Lesson not Started  Filtering Records

Working with Queries
Lesson not Started  An Introduction to Queries
Lesson not Started  Creating Queries using the Wizard
Lesson not Started  Creating Queries using Design View
Lesson not Started  Using Query Criteria
Lesson not Started  Using Multiple Query Criteria
Lesson not Started  Creating Update Queries
Lesson not Started  Saving Queries

Explaining Forms
Lesson not Started  Form and Design Views
Lesson not Started  Creating Forms using the Wizard
Lesson not Started  Creating Forms using the Design View
Lesson not Started  Creating Forms Automatically
Lesson not Started  Record Maintenance Using a Form
Lesson not Started  Saving Forms

Explaining Reports
Lesson not Started  Creating Reports using the Wizard
Lesson not Started  Creating Reports using the Design View
Lesson not Started  Creating Reports Automatically
Lesson not Started  Print Preview
Lesson not Started  Printing Reports
Lesson not Started  Saving Reports