Course Outline
Microsoft Access - Introduction
Hands-on training in an instructor-led environment. One workstation per delegate
and exercises to consolidate learning.
Training Method:
No prior knowledge of Microsoft Access is assumed.
A working knowledge of the Windows environment is required.
Two days
To introduce the concepts and features of Microsoft Access. Upon successful completion of the course,
delegates will be able to create and use an effective database.
First time and/or inexperienced users of Microsoft Access.
Designed for:
Module 1: The Fundamentals
Introduction to Databases
Starting Access and Opening a Database
Understanding the Access Program Screen
Opening and Modifying Database Objects
Working with Multiple Windows
Tour of a Table
Adding, Editing, and Deleting Records
Tour of a Form, Tour of a Query, Tour of a Report
Previewing and Printing a Database Object
Selecting, Cutting, Copying, and Pasting Data
Using the Zoom Box
Closing a Database and Exiting Access
Module 2: Creating & Working
with a Database
Planning a Database
Creating a Database Using the Database Wizard
Creating a Blank Database
Creating a Table Using the Table Wizard
Modifying a Table and Understanding Data Types
Creating a New Table from Scratch
Creating a Query in Design View
Modifying a Query
Sorting a Query Using Multiple Fields
Developing AND and OR Operators
Creating a Form with the Form Wizard
Creating a Report with the Report Wizard
Database Object Management
File Management
Compacting and Repairing a Database
Converting an Access Database
Module3:Finding,Filtering,Formatting Data
Finding and Replacing Information
Sorting Records
Filtering by Selection, Filtering by Form
Creating an Advanced Filter
Adjusting Row Height and Column Width
Rearranging Columns
Changing Gridline and Cell Effects
Freezing a Field, Hiding a Column
Changing the Datasheet Font
Module 4: Working with Tables & Fields
Understanding Field Properties & Indexing a Field
Adding a Primary Key to a Table
Inserting, Deleting, and Reordering Fields
Changing a Field’s Data Type
Using Field Descriptions
Adding a Caption, Changing the Field Size
Formatting Number, Currency,& Date/Time Fields
Formatting Number, Currency, and
Date/Time Fields by Hand
Formatting Text Fields
Setting a Default Value Requiring Data Entry
Validating Data
Creating an Input Mask, Creating a Lookup Field
Creating a Value List, Modifying a Lookup List
Module 5: Creating Relational Databases
Understanding Table Relationships
Creating Relationships Between Tables
Enforcing Referential Integrity
Testing Referential Integrity and Printing
and Deleting Table Relationships
Understanding Relationship Types
* Public Courses
* Private Courses
* Customised Courses
* On site training available
Tel: 01625 549287