MS Access 2003, 2002, 2000 Level 2

1 Day Training Class

Performance Objectives of this MS Access 2003 to 2000 training class:

• 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.
• Interact with data through a browser by creating and using data access pages.
• Customize report designs by grouping, sorting, and summarizing data, and by adding subreports.

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

Lesson 7: Customizing reports

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

What's Next?  DSOC0253 Microsoft Access 2003, 2002, 2000 Level 3

MS Access 2003 classes. Training the Nashville and Murfreesboro Tennessee area.