Expand your knowledge of relational database design; promote quality input from users; improve database efficiency and data integrity; and implement advanced features in tables, queries, forms and reports. Extending your knowledge of Microsoft Office Access will result in a robust, functional database for you and your users.

Note: The Microsoft Office Specialist (MOS) certification test voucher is also available as an option for specific applications.

• Access 2019: Level 1 or equivalent knowledge

Lesson 1: Promoting Quality Data Input

• Restrict data input through field validation
• Restrict data input through forms and record validation

Lesson 2: Improving Efficiency and Data Integrity

• Data normalization
• Associate unrelated tables
• Enforce referential integrity

Lesson 3: Improving Table Usability

• Create lookups within a table
• Work with subdatasheets

Lesson 4: Creating Advanced Queries

• Create query joins
• Create subqueries
• Summarize data

Lesson 5: Improving Form Presentation

• Apply conditional formatting
• Create tab pages with subforms and other controls

Lesson 6: Creating Advanced Reports

• Apply advanced formatting to a report
• Add a calculated field to a report
• Control pagination and print quality
• Add a chart to a report