|
|
| Course Description | ||
| Students will learn how to enhance database designs by using the principles of data normalization, table relationships, and referential integrity; by querying multiple tables for data used in customized forms, reports, and sub reports; and by creating data access pages. | ||
| Course Content | Prerequisites |
|
| 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 Integrating with Other Applications Lesson 7: Customizing Reports Customizing a Report Created by the Report Wizard Working with Sub reports Creating a Report in Design View |
Access Level 1 | |
| or equivalent knowledge. | ||
| Course Duration | ||
| 7.5 hours | ||
| Study Methods Available | ||
| aIndividual Tuition | ||
| aGroup Training | ||
| x Distance Learning | ||
| Follow-on Courses | ||
| Access Level 3 | ||
| All Courses | ||
| Click here to see all our courses | ||
