|
Course aim
This course is an overview of the relational database, Microsoft Access
2007.
Who should attend?
Delegates should be familiar with the Windows environment. No prior knowledge
of database terminology or Microsoft Access is assumed. The course includes
no programming.
Training style
Informal and participative using a combination of trainer input, discussion
and practical exercises. This approach ensures the training meets the
needs of both the group and individual participants.
|
Course contents
The Access Environment
Introduction to database terminology
Starting Access and opening a database
Database objects
Navigation Pane
The Quick Access toolbar and adding additional database commands
Security warnings and Online Help
The Office Button - saving database in compatible formats
Creating New Databases and
Tables
Planning a new database
Creating a new database
Creating a database table using the Microsoft Templates
Creating a database table in Design View
Setting field properties
Setting up primary keys
Moving around a table and entering data
Copying, moving and deleting data
Locating, sorting and filtering data
Using the LookUp Wizard to link tables
Designing Forms
Why create a form?
Types of form in the Create ribbon
Using AutoFormat
Using the Form Wizard
Changing forms in Design View
The Form Design Tools ribbon
Adding fields to forms
Form and Control properties
|
Using Select Queries
What is a query?
The Create Ribbon
Creating a query using the Wizard
Creating a query in Design View
Saving and printing queries
Queries with multiple tables
Calculations and summaries in queries
Reporting
Printing from Datasheet view
Report Layout Tools ribbons
Using AutoReport
Using Report Wizards
Label reports
Modifying reports in Design View
|
