Microsoft
Course Outline
Microsoft Access 2007 - 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 2007 is assumed.
A working knowledge of the Windows environment is required.
Prerequisites:
Two days
Duration:
To introduce the concepts and features of Microsoft Access 2007. Upon successful completion of the
course, delegates will be able to create and use an effective database.
Objectives
First time and/or inexperienced users of Microsoft Access 2007.
Designed for:
Module 1: Introduction to Databases
Database concepts
Flat ?le database v. relational database
Database layout
Access objects
Launching Access
Creating a new database
Using help
Module 2: Tables
Database design
Creating tables using a table template
Creating tables in the design view
Data entry
Field properties
Data display format v. input mask
The input mask
Entering and editing data
Editing data
Selecting records
Deleting records
Moving and copying records
Pasting records
Content
Module3: Working with Tables
Sorting tables
Deleting a table
Table layout changes
Freezing and unfreezing columns
Modifying table structure (?elds)
Finding data
Replace
Wildcards
Navigating within a table
Datasheet keyboard shortcuts
Module 4: Queries
Data queries
The simple query wizard
The design view
Modifying the query
Using the basic criteria
Additional criteria
Parameters
Multiple object queries
Custom calculations in a query
Grouping ?elds
* Public Courses
* Private Courses
* Customised Courses
* On site training available
Tel: 01625 549287 anne@firsttraining.net