|
Course aim
This course is for users of databases created in
Microsoft Access 2003 who need to manage the data.
Who should attend?
Delegates should be familiar with the Windows 95/98/ME/NT 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
On Line Help
Using Database Tables and Forms
Opening a Table
Opening a Form
Entering Data
Copying, Moving and Deleting Data
Undoing Changes
Finding and Sorting Data
Filtering Data by Selection
Filtering Data by Form
Saving a Filter as a Query
Using Select Queries
What is a Query?
The Simple Query Wizard
Creating a Query in Design View
Query Selection Criteria
Saving and Printing Queries
Queries with Multiple Tables
Table Joins within Queries
Calculations and Summaries in Queries
|
Using Action Queries
What are Action Queries?
Make Table Queries
Delete Queries
Append Queries
Update Queries
The Query Wizards (Find Duplicates, Find Unmatched)
Reporting
Why Design a Report?
Using Report Wizards
Modifying Reports in Design View
Sorting and Grouping Data
Calculated Fields on Reports
Total Fields on Reports
Some Report and Section Properties
Mailing Labels
Charts
Merge It with Microsoft Word
Analyse It with Microsoft Excel
|
|
