 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Access 2000 Advanced
Course Aims
This one-day intensive course is designed to give existing users an insight into some of the more advanced features in Access. This entirely 'hands on' course will give participants a further understanding of database design principles, advanced forms, reports and query design, including using calculations. |
Assumed Knowledge
A basic knowledge of Microsoft Access gained through use of the product or by studying an "MS Access 2000 Intermediate" course. |
Course Audience
Existing users of Microsoft Access for windows who want to customise forms, queries and reports. |
|
Table of Contents
|
|
Access 2000 Advanced
|
|
|
|
Database design
|
|
|
Access 2000 performance issues
|
Relationships and referential integrity
|
|
Referential integrity options
|
|
Using Lookups for referential integrity
|
|
Multi-table datasheet view
|
|
|
|
Building and modifying forms
|
Using advanced forms features
|
|
Creating a calculated control
|
|
Adding a graphic to a form
|
|
Using the Subform control
|
|
|
|
Access and the Internet
|
Using hyperlinks in forms
|
|
Exporting datasheet views to HTML
|
|
|
|
Advanced queries
|
|
|
|
Action queries
|
|
|
Producing reports
|
Applying sorting and grouping to reports
|
|
Performing calculations on reports
|
|
Adding a graphic to a report
|
|
Using the subreport control
|
|
Modifying section properties
|
|
|
|
|
|
