Access 2003: Intermediate

Course length: 1 day

Course description

Overview: Students will get the most out of this course if they want to learn to enhance their database designs by using the principles of data normalization and table relationships; to query multiple tables for data that is used in customized forms and reports; and to begin using data access pages.

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

• 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.

Course content