 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Access 2000 Intermediate
Course Aims
This intensive course is designed to give existing Access 2000 users additional skills and knowledge on using the many features and functions of this software to make them more efficient and effective when processing data with Access. This entirely 'hands on' course will give readers experience in producing database applications and the ability to create a variety of data views, queries and reports. |
Assumed Knowledge
A basic understanding of PCs, Windows 95/98/NT and MS Access 2000 is required, gained from previous experience or by attendance on an "MS Access 2000 Introduction" training course. |
Course Audience
Existing users of MS Access 2000 who want to get grips with some of the more advanced features of this package as quickly as possible. |
|
Table of Contents
|
|
Access 2000 Intermediate
|
|
|
Database design
|
What is a relational database?
|
|
|
|
Using field properties for protection
|
Validation rule and validation text
|
|
|
|
Table relationships
|
Creating and editing relationships
|
|
Using lookups for referential integrity
|
|
Multi-table datasheet view
|
|
|
|
Queries
|
Adding a calculated field to a query
|
|
Calculating summary information
|
|
Checking referential integrity
|
|
|
|
Forms
|
|
|
Reports
|
Using Report Wizards as the basis for reports
|
|
Publishing datasheet views on the Internet
|
|
Adding hyperlinks to datasheet views
|
|
Adding hyperlinks to HTML pages
|
|
|
|
Access tools
|
Importing from other data sources
|
|
Importing data using Drag-and-Drop
|
|
Backing up and restoring a database
|
|
Compacting and repairing a database
|
|
|
|
|
|
