Students will learn how to enhance their database designs by using the principles of normalization and table relationships in Access 2007. They will also learn how to query multiple tables for data that is used in customized forms and reports. Upon successful completion of this course, participants 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 and creating indexes.
-Design select queries by using multiple tables to calculate, group, average, and link 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.

Prerequisites: Familiarity with Access basics (e.g., creating and editing tables, entering data, Table Wizard, queries, and generating simple reports).

$100