 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Access 97 Intermediate
Course Aims
This intensive course is designed to give existing Access 97 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 97 is required, gained from previous experience or by attendance on an "MS Access 97 Introduction" training course. |
Course Audience
Existing users of MS Access 97 who want to get grips with some of the more advanced features of this package as quickly as possible. |
|
Table of Contents
|
Review of Access 97 Database Principles
|
Viewing, Entering and Editing Data
|
|
Searching For and Asking Questions Of the Data
|
|
|
|
Year 2000 Performance and Database Design
|
Objectives When Designing a Database
|
|
Which Fields Should be Indexed?
|
|
Relational Database Design
|
|
Relational Database - Definition
|
|
Creating a Relational Model
|
|
Relationships and Referential Integrity
|
|
Table Definition Components
|
|
|
|
Designing Multi-Table Forms
|
Advantages of Forms in Access
|
|
Creating a Form Using Multiple Tables
|
|
|
The Form Design Work Surface
|
The Object Property Sheet
|
|
|
|
|
Advanced Forms Design
|
|
|
Importing Data
|
Importing Tables from External Sources
|
|
|
|
Querying a Database
|
What is a Database Query?
|
|
|
|
|
Reporting
|
|
|
|
|
