Overview
Students will learn how to enhance their database designs by using the principles of data normalization and table relationships and how to query multiple tables for data that are used in customized forms and reports.
Prerequisites
To ensure students’ success with this course, we recommend that they first take the Content course Access 97: Level 1 (Windows 95) or have equivalent knowledge.
Performance-Based Objectives
- Normalize sample tables by identifying design problems.
- Establish relationships between tables by analyzing table relationships and
enforcing referential integrity.
- Customize table designs by setting field properties to maintain data integrity
and by creating indexes.
- Design select queries by using multiple tables to calculate, group, average,
and concatenate values and to show top values.
- Customize form designs by creating calculated fields, combo boxes, and unbound
controls.
- Display table information that has a one-to-many relationship by creating forms
that contain subforms.
- Customize report designs by grouping, sorting, and summarizing data, and by
adding subreports.
Delivery Method:
This course is designed for instructor-led, group paced classroom-delivery, providing students with structured hands-on activities.
Course duration
1 Day(s)
Course outline
Lesson 1: Principles of table design
- Topic 1A: Normalizing data
- Topic 1B: Normalizing data for fourth and fifth normal forms
Lesson 2: Principles of table relationships
- Topic 2A: Analyzing table relationships
- Topic 2B: Establishing and testing referential integrity
Lesson 3: Table design techniques
- Topic 3A: Data validation techniques
- Topic 3B: Indexing techniques
Lesson 4: Designing select queries
- Topic 4A: Working with calculations
- Topic 4B: Creating multiple-table queries
Lesson 5: Enhanced form design
- Topic 5A: Customizing the form design
- Topic 5B: Adding calculations to a form
- Topic 5C: Adding combo boxes to a form
- Topic 5D: Adding unbound controls
Lesson 6: Subform design
- Topic 6A: Creating a form that contains a subform
- Topic 6B: Using the Form Wizard to create a form that contains a
subform
Lesson 7: Customizing reports
- Topic 7A: Customizing a report created by the Report Wizard
- Topic 7B: Subreports
Appendix A: Using the Chart Wizard
- Using the Chart WizardTopic
Appendix B: Mailing labels
- Creating mailing labelsTopic
Hardware/Software Requirements
You will need:
- 12 megabytes (MB) of Random Access Memory (RAM).
- 69 MB of available hard-disk space to install Access and to copy data files.
- An IBM-compatible PC with an 80486SX or higher processor.
- Microsoft Windows 95.
- Microsoft Office 97.
- A VGA or higher display adapter. (The EGA display adapter is not supported.)
- A two-button mouse or IntelliMouse.
- A floppy-disk drive.
- Printers are not required although you will need an installed printer driver.
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com
Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © 2008 Wintrac Inc.
|
