This Microsoft Access Intermediate course equips delegates with the essential skills to design robust, multi-table databases and implement advanced data management techniques, enabling efficient organisation and retrieval of complex information. Delegates will gain expertise in structuring relational databases, ensuring data consistency through referential integrity, and creating dynamic forms and queries that enhance productivity and accuracy in data handling. By mastering these core concepts, participants will be able to build scalable solutions that support informed decision-making and streamline workflows in professional environments, making this course a vital step for those looking to elevate their database management capabilities.
Struggling to manage complex databases? Unlock efficiency with our Microsoft Access Intermediate course... designed to transform how you handle data. In just one day, delegates gain the confidence to design robust, multi-table systems that save time and reduce errors. Whether you're streamlining workflows or boosting team productivity, this training equips you with essential skills to link tables, enforce data integrity, and optimise performance. Choose flexible delivery—join our open course, book a closed group session, or opt for one-to-one coaching. With six CPD hours under your belt, this is your shortcut to mastering database design... without the lengthy commitment. Ready to elevate your skills? To find out more, contact us at let's dash talk at eqv dot co dot uk.
Counts towards 6 CPD Hours1 DayOpen Public & Closed Group
Please reflect on one or more of the questions below and come prepared to discuss your responses during the session.
Self-Assessment: On a scale of 1–10, how would you rate your current skill level in this subject? What factors influenced your rating?
Development Focus: Identify one specific behaviour, skill, or capability you would like to improve or develop further.
Relevant Examples: If possible, bring one or two relevant examples or scenarios from your experience that you would be willing to share with the group.
What You Will Learn
Designing multi table databases
Assigning Primary Keys
Assigning an Index
Linking tables through relationships view
Setting Referential integrity
Creating Main / Sub Forms
Creating linked forms
Creating multi-table queries
Creating inner and outer joins in queries
Calculations in queries
Group & Total queries
Parameter Queries
Creating Append queries
Creating update queries
Creating delete queries
Your Post-Course Challenge
Complete the further practice workbook
Apply the techniques to your own data
Counts Towards 6 CPD Hours
This course contributes 6 hours of Continuing Professional Development. Delegates can log these hours as evidence of structured learning for professional bodies and employers.
This course is designed for individuals who already have a foundational understanding of Microsoft Access and are looking to expand their skills in database design, querying, and data management. It is particularly suited for those aiming to create more complex databases, improve data accuracy, and streamline workflows using advanced features.
This course is ideal for:
Data analysts seeking to enhance their ability to manage and query complex datasets
Office administrators responsible for maintaining organisational databases and reports
Project managers needing to track and analyse project-related data efficiently
IT support staff looking to automate data processes and reduce manual errors
Business analysts aiming to build robust systems for data-driven decision-making
Professionals transitioning into data management who want to strengthen their technical skills
Some prior experience recommended
While no formal prerequisites are required, delegates should have basic familiarity with Microsoft Access, such as creating tables, forms, and simple queries. This course builds on foundational knowledge to develop advanced skills in database design and data manipulation.
What you will take away
Delegates will leave with the confidence and practical skills to design efficient multi-table databases, create advanced queries, and implement data integrity measures. These competencies will enable them to manage complex data workflows, improve organisational efficiency, and support data-driven decision-making in their roles.
For Groups & Teams
We can deliver this training session in several ways to suit your organisation’s needs:
Open Public Course
Join delegates from other organisations on a scheduled date
Closed Group
Exclusively for your team, using your real scenarios
In Person
Face-to-face at your premises or a venue of your choice
Virtual
Live, interactive online delivery via Teams or Zoom
One-to-One Coaching
Personalised sessions tailored entirely to you
Have two or more people to train?
You may want to consider a closed group course. Benefits include:
Cost effective for teams
Choose a date to suit you
Customise content and timings
No minimum delegate numbers
Uses your real-world scenarios
Builds shared language in your team
Contact us on [email protected] to discuss specific dates and delivery requirements.
How Our Tutor-Led Courses Are Delivered
Before the day
Delegates are given pre-work to complete before attending. This ensures everyone arrives with relevant context and real scenarios from their own experience, so learning is immediately relevant and actionable from the first minute.
On the day
Our sessions are participative and highly interactive. We don’t do “death by PowerPoint” — instead, the day includes a variety of engaging activities throughout:
Real-world casework using your scenarios
Practical hands-on exercises
Real Play (not role play) simulations
Peer learning and group discussion
Case studies and scenario work
Facilitated discussion and structured reflection
What you leave with
Participants leave with:
Practical tools — frameworks and models you can use straight away
Clear action plans — specific next steps tailored to your role
Greater confidence — built through intensive, realistic practice
Skills you can apply immediately — not theory, but techniques tested during the day
After the day
Post-session measurements and a 30-day challenge ensure that learning is embedded and behaviour change is sustained.
Key Features
Course Duration is 1 Day
Engaging tutor led event
Comprehensive course materials
Certificates of attendance
Access to Customer Portal (course bookers)
Course Guarantee
Priced per delegate per day for open public course
£295.00 Plus VAT
Can’t see a suitable date? Please request a date here
Payment available via all major credit cards or Invoice. All options available during the online booking process.
