Microsoft Access Training
Microsoft Access is a powerful relational database management tool, ideal for storing, analysing and organising data efficiently. Our Access courses help learners create databases, manage tables, build queries, design user-friendly forms and produce professional reports.
Choose Your Access Course
Click a course below to view the full details
Using & Creating Databases
Introduction Microsoft Access Course
Duration: 1 Day
Delivery: Face To Face & Live Online
The Introduction course provides a solid foundation in database management, guiding users through the basics of creating and understanding Access databases. Learn the key differences between flat and relational databases, the role of primary and foreign keys, and how to build linked tables, queries, forms and reports.
Who Should Attend?
- Data Entry Professionals
- IT Professionals
- Office Managers
- Small Business Owners
Course Requirements
No previous experience of Microsoft Access is required. Delegates should have knowledge of basic computer skills.
Course Content
- Relational Databases: Understand relationships between tables, including 1-to-1 and 1-to-many relationships.
- Creating Controls: Build and manage lists and combo boxes, including combo box queries.
- Forms: Design and customise tabular, columnar and sub forms.
- Importing and Exporting: Import and export data from Excel and other databases.
- Queries: Create forms using queries for enhanced functionality.
- Reports: Generate professional reports using queries and grouping features.
- Switchboard: Develop custom switchboards using the wizard or PCS Switchboard.
- Professional Database: Create user-friendly databases with popup forms and toolbars.
Queries & Reports
Intermediate Microsoft Access Course
Duration: 1 Day
Delivery: Face To Face & Live Online
This course is aimed at users who have attended the previous stage or more experienced users who wish to further their knowledge of Microsoft Access. Delegates will learn how to use queries and reports more effectively to analyse data, identify duplicates and produce useful summaries.
Who Should Attend?
- Data Entry Professionals
- IT Professionals
- Office Managers
- Small Business Owners
Course Requirements
Delegates should have attended the previous stage of the Access course at Pringle PCS or have equivalent working knowledge.
Course Content
- Query Types: Perform select, delete, append, make table and crosstab queries.
- Total Command: Use functions such as group, average, sum, count, max and min.
- Find Duplicates and Amending: Identify duplicates and fix broken queries effectively.
- Multiple Table Queries: Convert data into a flat file for mail merge purposes.
- Reports: Generate reports using multiple tables and queries.
- Summarise Reports: Group data and calculate totals for summarised reports.
Access Master
Advanced Microsoft Access Course
Duration: 1 Day
Delivery: Face To Face & Live Online
The advanced course builds on your existing knowledge, covering advanced relationships, sub forms, advanced queries, SQL, Expression Builder, problem solving and an introduction to macros.
Who Should Attend?
- Data Entry Professionals
- IT Professionals
- Office Managers
- Small Business Owners
Course Requirements
Delegates should have attended the previous stage of the Access course at Pringle PCS or have equivalent working knowledge.
Course Content
- Relational Databases: Work with 1-to-1, 1-to-many and advanced working relationships.
- Sub Forms: Create and manage standard and query-based sub forms.
- Advanced Queries: Handle multiple tables and embed complex SQL queries.
- Expression Builder: Use the Expression Builder for queries and custom commands.
- Problem Solving: Tackle Access limitations and find creative ways to overcome restrictions.
- Introducing Macros: Execute commands, set values, open forms and run macros effectively.
- PCS Development Tricks: Focus on documentation and understanding databases.
Bespoke Access Training
Custom Microsoft Access Course
Duration: Tailored To Requirements
Delivery: Face To Face & Live Online
Bespoke Microsoft Access training is ideal when your team needs help with a live database, reports, queries, forms, data entry systems or specific business problems. The session can be tailored around your own database requirements and the exact skills your staff need.
Who Should Attend?
- Teams who use existing Access databases
- Staff who need help building queries, forms and reports
- Managers responsible for business data and reporting
- Users who need focused help with real Access problems
Course Requirements
Requirements can be agreed before the course. Delegates can bring examples of databases, reports or problems they work with, so the training is practical and directly relevant.
Course Content
- Company Databases: Work with your own Access databases, tables, queries, forms and reports.
- Query Problems: Fix filters, joins, calculations and report queries.
- Form and Report Design: Improve usability, data entry and professional reporting.
- Practical Workshops: Solve real database problems during the training session.
- Team Confidence: Build skills so staff can work faster and more accurately.
