Overview: Students will learn how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple tables for data that is used in customized forms and reports.

Prerequisites:. Students enrolling in this course should understand the basics of creating and using database objects, including tables, queries, forms, and reports.

Benefits: Students will learn how to take the guesswork out of creating databases by using data-normalization techniques. They will learn how to take advantage of relational database efficiency to maintain data. In addition, students will be able to save time by controlling data entry and automating tasks. Students will also benefit by becoming familiar with Access features that will enable them to customize forms and reports. Students will learn how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple tables for data that is used in customized forms and reports.

Prerequisites:. Students enrolling in this course should understand the basics of creating and using database objects, including tables, queries, forms, and reports.

Benefits: Students will learn how to take the guesswork out of creating databases by using data-normalization techniques. They will learn how to take advantage of relational database efficiency to maintain data. In addition, students will be able to save time by controlling data entry and automating tasks. Students will also benefit by becoming familiar with Access features that will enable them to customize forms and reports.

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

• Normalizing data
• Analyzing table relationships
• Establishing and testing referential integrity
• Data validation techniques
• Indexing techniques
• Working with calculations
• Creating advanced select queries
• Modifying the form design
• Adding calculations to a form
• Adding combo boxes to a form
• Adding unbound controls
• Creating a form that contains a subform
• Using the Form Wizard to create a form that contains a subform
• Customizing a report created by the Report Wizard
• Subreports