Microsoft Access Intermediate

Course Schedule
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
Public Schedule
Virtual Private Training
Contact us for pricing
Onsite Training
Contact us for pricing
Note
All prices exclude VAT at 20%.
VAT registration number: 450 4347 14
You may also like...
Master the basics of Microsoft Planner in this half-day virtual course. Learn to create plans, assign tasks, and collaborate with your team.
Half Day
Learn to transform, clean, and analyse data with Power Query. Import, merge, and create insightful reports in Excel. Half-day course.
Half Day
This course is aimed at attendees who want to expand their knowledge into some of the more complex functions, build reports using form controls, work with Power Pivots and use built-in automation offered by Microsoft Excel.
1 Day