 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Access 2002 (XP) Advanced
Course Aims
To develop a relational database using Microsoft Access. Readers will learn to design databases incorporating different types of table relationships, use data validation and referential integrity, create queries to update and summarise data, build custom forms and reports for multiple data sources and create output for the internet. |
Assumed Knowledge
Previous experience with Access is required. Readers must be able to create tables and queries in design view, use wizards to create forms and reports and make basic modifications in design view. |
Course Audience
This course will benefit existing users of Microsoft Access 2002. |
|
Table of Contents
|
Database Design
|
Designing a Relational Database
|
|
Queries, Forms and Reports
|
|
|
|
Importing and Linking Data
|
Importing from Other Data Sources
|
|
Importing Data Using Drag-and-Drop
|
|
|
|
Referential Integrity
|
Create and Edit a Relationship
|
|
Enforce Referential Integrity
|
|
Use Queries to Enforce Referential Integrity
|
|
Set Cascade Update and Delete Options
|
|
Set the Default Join Type
|
|
Use a Lookup Field for Referential Integrity
|
|
Create a Lookup List from a Fixed Set of Values
|
|
|
|
Business Rules
|
The Default Value Property
|
|
The Allow Zero Length Property
|
|
Validate Data at Field Level
|
|
Validate Data at Table Level
|
|
Optimise Data Type and Field Size Usage
|
|
|
|
Advanced Query Design
|
Apply and Remove a Filter
|
|
Specify Multiple Criteria in a Query
|
|
Optimise Queries Using Indexes
|
|
Create a Query to Summarise Data
|
|
Change the Join Type in a Query
|
|
|
Advanced Form Design
|
Create a Form in Design View
|
|
The Form Design Worksurface
|
|
Modify the Properties of Form Objects
|
|
Modify the Properties of Form Controls
|
|
Format Controls on a Form
|
|
Insert a Graphic on a Form
|
|
Create a Form Based on Multiple Tables
|
|
Use a Template to Create a Form
|
|
|
|
Advanced Report Design
|
Create a Report in Design View
|
|
The Report Design Worksurface
|
|
Modify the Properties of Report Objects
|
|
Add a Control to a Report
|
|
Modify the Layout of Report Controls
|
|
Modify the Properties of Report Controls
|
|
Format Controls on a Report
|
|
Use Sorting and Grouping Functions in a Report
|
|
Modify Report Section Properties
|
|
Use the Subreport Control
|
|
Use a Template to Create a Report
|
|
|
|
Data Access Pages
|
What is a Data Access Page?
|
|
Create a Data Access Page
|
|
Connecting to the Data Source
|
|
Create a Grouped Data Access Page
|
|
The Data Access Page Design Worksurface
|
|
Modify the Design of a Data Access Page
|
|
Add and Modify Fields and Controls
|
|
|
|
|
Glossary
|
|
|
|
|
