 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Access 97 Expert User Part 2
Course Aims
This intensive course is designed to give existing users of Access 97 an insight into some of the more advanced features in Access. This entirely 'hands on' course will give readers a further understanding of database design principles, advanced forms, reports and query design, including using calculations. It will also show customisation of the database through command buttons, macros and customised menus, and Internet publishing. |
Assumed Knowledge
A basic knowledge of Microsoft Access gained through use of the product or by studying an "MS Access 97 Expert User Part 1" course. |
Course Audience
Existing users of Microsoft Access for windows who want to design and customise databases. |
|
Table of Contents
|
Building a Relational Database
|
Designing a Relational Database
|
|
Primary and Secondary Keys
|
|
Maintaining Data Integrity
|
|
Types of Relationship Links
|
|
Relationships and Referential Integrity
|
|
An Example Relational Model
|
|
|
|
Creating Relational Queries
|
Working with Related Tables in Queries
|
|
Setting Joins Types in Queries
|
|
Calculated Fields in Queries
|
|
|
|
|
Summary and Crosstab Queries
|
|
|
Advanced Forms Features
|
Creating Customised Forms
|
|
The Object Property Sheet
|
|
Working in Forms Designer
|
|
Bound and Unbound Controls
|
|
Creating a Calculated Control
|
|
|
Producing Reports
|
Changing the Design of Existing Reports
|
|
Applying Sorting and Grouping to Reports
|
|
Performing Calculations on Reports
|
|
Creating Custom Report Pages
|
|
|
|
Importing, Exporting, and Linking Data
|
Storing OLE Objects in Records
|
|
|
|
|
Action Queries
|
|
|
Customizing Menus and Toolbars
|
Creating Custom Menus and Toolbars
|
|
Customising Menus and Toolbars
|
|
|
|
Macros and Command Buttons
|
Designing Application Menus
|
|
Setting Start-up Defaults
|
|
|
|
Hyperlinks and Internet Publishing
|
Using Hyperlinks and Publishing on the Internet
|
|
Using Hyperlinks in Tables and Forms
|
|
Publishing Data on the Internet
|
|
|
|
|
|
