(Duration: 55m )

1. Workbook
2. Topic A: Relational Database Design
3. Database Relationship
4. Relational Database Design Process
5. Statement of Purpose
6. Existing Data
7. Business Rules
8. Primary Keys
9. Primary and Foreign Keys
10. Composite Keys
11. One-to-One Relationships
12. One-to-Many Relationships
13. Relationships Window
14. Guidelines for Designing Databases
15. Demo – Exploring Table Relationships
16. Topic B: Create a Table
17. Table Views
18. List of Data Types
19. Calendar for Picking Dates
20. Lookup Wizard
21. The Table Properties Dialog Box
22. Demo – Creating a Table
23. Topic C: Create Table Relationships
24. Edit Relationships Dialog Box
25. Enforce Referential Integrity Options
26. Join Lines
27. Relationship Reports
28. Guidelines for Enforcing Referential Integrity
29. Demo – Creating a Table Relationship
30. Chapter 01 Review
31. Review Quiz (Number of attempts allowed: Unlimited)

(Duration: 24 m)

1. Workbook
2. Topic A: Create Query Joins
3. Query Joins
4. Inner Joins
5. Left and Right Outer Joins
6. Join Properties Dialog Box
7. What the Join Options Return
8. An Unrelated Table Join
9. Demo- Creating Inner and Outer Joins
10. Demo- Joining Unrelated Tables
11. Topic B: Relate Data Within a Table
12. Self Joins
13. Demo- Creating a Self Join
14. Topic C: Work with Subdatasheets
15. Subdatasheets
16. Demo- Modifying Data in a Subdatasheet
17. Chapter 02 Review
18. Review Quiz (Number of attempts allowed: Unlimited)

(Duration: 31 m )

1. Workbook
2. Topic A: Use Field Validation
3. Field Validation
4. Field Properties
5. Input Masks
6. Input Mask Wizard
7. Demo- Validating Data by Using a Field Property
8. Demo- Validating Data by Using an Input Mask
9. Topic B: Use Form and Record Validation
10. The Combo Box Wizard
11. List Box Control
12. Option Group Control
13. Demo- Using a Combo Box Control to Limit Option Values
14. Demo- Using a Record Validation Rule
15. Chapter 03 Review
16. Review Quiz (Number of attempts allowed: Unlimited)

(Duration: 37 m)

1. Workbook
2. Topic A: Create Parameter Queries
3. A Parameter Query Displays a Prompt
4. Demo- Creating a Parameter Query
5. Demo- Using Wildcards in a Parameter Query
6. Demo- Creating a Query with Multiple Parameters
7. Topic B: Summarize Data
8. Crosstab Query Wizard
9. Analyzing Customer Payments
10. Demo- Creating a Crosstab Query
11. Topic C: Create Subqueries
12. Subquery Example
13. Subquery Expression Example
14. Demo- Creating Subqueries
15. Topic D: Create Action Queries
16. Action Query Update Expression
17. Demo – Creating Action Queries
18. Topic E: Create Unmatched and Duplicate Queries
19. Find Unmatched Query Wizard
20. Find Duplicates Query Wizard
21. Demo – Creating Queries to Search for Unmatched and Duplicate Records
22. Chapter 04 Review
23. Review Quiz (Number of attempts allowed: Unlimited)

(Duration: 20 m )

1. Workbook
2. Topic A: Data Normalization
3. First Normal Form
4. Second Normal Form
5. Third Normal Form
6. Denormalization
7. Table Analyzer Wizard
8. Demo – Running the Table Analyzer Wizard
9. Topic B: Create a Junction Table
10. Junction Table
11. Demo – Using a Junction Table to Resolve a Many-to-Many Relationship
12. Topic C: Improve Table Structure
13. Demo – Improving Table Structure
14. Chapter 05 Review
15. Review Quiz (Number of attempts allowed: Unlimited)

(Duration: 18 m)

1. Workbook
2. Topic A: Include Control Formatting in a Report
3. Data Bars
4. Demo – Adding Data Bars to a Report
5. Topic B: Add a Calculated Field to a Report
6. Demo – Adding a Calculated Field to a Report
7. Topic C: Add a Subreport to an Existing Report
8. Demo – Adding a Subreport to an Existing Report
9. Chapter 06 Review
10. Course Closure
11. Review Quiz (Number of attempts allowed: Unlimited)

Training Final Exam ?

Are you ready to earn your certificate of completion?

Launch The Exam