1 Day Course

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, by creating a lookup list, 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.
• Publish data to the Web by creating data access pages.
• Customize report designs by grouping, sorting, and summarizing data, and by adding subreports.

Prerequisites

Course content

Lesson 1: Principles of table design

• Normalizing data
• Normalizing data for fourth and fifth normal forms

Lesson 2: Principles of table relationships

• Analyzing table relationships
• Establishing and testing referential integrity

Lesson 3: Table design techniques

• Data validation techniques
• Indexing techniques

Lesson 4: Designing select queries

• Using calculated fields in queries
• Creating multiple-table queries

Lesson 5: Customizing form designs

• Customizing the form design
• Performing calculations on a form
• Adding combo boxes to a form
• Adding unbound controls

Lesson 6: Working with data access pages

• Creating data access pages

Lesson 7: Customizing reports

• Customizing a report created by the Report Wizard
• Working with subreports

Appendix A: Using the Chart Wizard <

• Creating a chart in a form or report

Appendix B: New features of Access

• View information on object dependencies