Microsoft Access Intermediate

COURSE AIMS

This 1-day intermediate course aims to expand on the foundational knowledge gained in the introductory course. Participants will delve deeper into Access features and develop more advanced database management skills.

‍

LEARNING OBJECTIVES

‍

By the end of this course, participants should be able to:

• Create complex queries using criteria and expressions.
• Build forms with advanced controls and functionality.
• Design more sophisticated reports for data analysis.
• Work with data macros and automation.
• Understand security and access control for databases.
• Manage data relationships and referential integrity.

‍

TARGET AUDIENCE

This course is suitable for individuals with some basic knowledge of Microsoft Access or those who have completed the Introduction course and want to enhance their skills.

‍

COURSE OUTLINE

‍

1. Advanced Query Design

2. Form Design and Advanced Controls

3. Creating Advanced Reports

4. Data Macros and Automation

5. Database Security and Access Control

6. Advanced Data Relationships

‍

‍