Access 97 Intermediate
Course Overview
Students will learn how to enhance their database designs by using the principles of normalisation and table relationships. Students also learn how to query multiple tables for data that is used in customised forms and reports.
Prerequisites
Access 97 Introduction or equivalent knowledge.
Benefits
Students will learn how to take the guesswork out of creating databases by using data-normalisation techniques. They will learn how to take advantage of relational database efficiency to maintain data. In addition, students will be able to save time by controlling data entry and automating tasks. Students will also benefit by becoming familiar with Access features that will enable them to customise forms and reports.
Target student
Students should already understand the basics of creating and using database objects, including tables, queries, forms, and reports.
What's next
Access 97 Intermediate is the second course in this series. Access 97 Advanced, the next course in this series, teaches students how to use a variety of query techniques, and how to create more efficient forms and reports, and macros. After taking the Advanced course, students who want to learn how to develop an application and tie the objects together into a cohesive system by using macros and Visual Basic for Applications code can take Access 97 VBA Programming.
We offer a range of Access training courses
| Principles of table design |
|---|
|
| Principles of table relationships |
|
| Table design techniques |
|
| Designing select queries |
|
| Enhanced form design |
|
| Subform design |
|
| Customising reports |
|
| Using the Chart Wizard |
|
|
| Mailing labels |
|
|
| Publisher: | Microsoft | 
|
|---|---|---|
| Version: | 97 | |
| Length: | 1 day | |
| Course-ID: | 052441 |
 |
Printer Friendly Version |
 |
Download Outline As PDF |
Related Courses
Systematix seemed genuinely interested in providing us with a course tailored to meet our specific needs
- Yell
