- Courses
- Microsoft 365
- Access Introduction
Microsoft Access Introduction Training Courses
Access Introduction
Learn to build and use Microsoft Access databases. This practical one-day course covers tables, relationships, queries, forms and reports, so you can store data reliably and get answers from it quickly.
Not sure this is the right level? Compare all Microsoft 365 training courses.
- 1 day
- Virtual or on-site
- Private team training
Trusted by teams at
Course overview
Microsoft Access is a desktop database that many organisations rely on to track records, contacts, assets and orders. This course gives you the foundations to use an existing database confidently or to build a well-structured one of your own.
You start by understanding how a database differs from a spreadsheet, then design tables and relationships that keep data consistent. From there you build queries that answer real questions, forms that make data entry quick and accurate, and reports ready to print or share.
Throughout the day you work on a realistic sample database with an experienced instructor, so every step is practical and repeatable on your own data.
Who it's for
- New Access users who maintain or inherit a database
- Staff who manage records that have outgrown a spreadsheet
- Administrators who need reliable reports from stored data
What you need before you start
- Basic computer skills
- Microsoft Access for Windows (included in some Microsoft 365 plans)
What you'll learn
What you will be able to do by the end of the course.
- Explain how tables, queries, forms and reports work together
- Design tables with suitable field types and primary keys
- Create relationships and enforce referential integrity
- Build select queries with criteria, sorting and calculated fields
- Create forms for quick, accurate data entry
- Produce grouped and formatted reports
- Import data from Excel and export results
Course outline
7 modules across 1 day.
1Getting Started with Access3 topics+
- Databases versus spreadsheets
- Navigate the Access interface
- Open, use and close database objects
2Designing Tables4 topics+
- Plan a table structure
- Choose field types and properties
- Set primary keys
- Add validation and input masks
3Relationships3 topics+
- One-to-many relationships
- Enforce referential integrity
- Use lookup fields sensibly
4Queries5 topics+
- Create select queries
- Add criteria and sort results
- Create calculated fields
- Summarise data with totals queries
- Use parameter queries
5Forms3 topics+
- Create forms with the Form Wizard
- Arrange and format controls
- Use forms to add and edit records
6Reports3 topics+
- Create reports with the Report Wizard
- Group, sort and total data
- Format reports for print and PDF
7Importing and Exporting3 topics+
- Import data from Excel
- Export query results to Excel
- Compact and back up a database
Get a quote
Run Access Introduction for your team
Delivered for your organisation alone, on a date you choose, online or at your offices.
Or call 0333 305 8855
What happens next
- 1We reply with available dates and a price for your team
- 2You pick a date that suits your team — we work around you
- 3We tailor the examples and exercises to the work your team does
- 4We confirm the delivery details and next steps in writing
Booked with a 100% money-back guarantee
Every course we run is covered. Book with confidence — if it isn’t right, you aren’t left out of pocket.
Why Future Savvy
Practical training, backed properly
Rated 4.72/5
From 696 reviews by learners and clients.
Money-back guarantee
A 100% money-back guarantee, for peace of mind.
Up to six learners
Small enough that every delegate gets trainer time on their own work.
Trainers who do the job
Practitioners who use these tools on real work, not career instructors.
Support after the course
Email your trainer when you hit something back at your desk.
What delegates say
Independently verified reviews, alongside quotes collected from delegates after their course.
I had a good experience with this Microsoft Excel training course! Mark the trainer was exceptionally knowledgeable, patient, and engaging, taking the time to explain complex functions and formulas in a way that was easy to understand. The pace of the class was well-managed, and there was plenty of opportunity to ask questions without feeling rushed. I left the session feeling much more confident, efficient, and equipped with time-saving shortcuts. Highly recommended for anyone looking to upgrade their spreadsheet skills!
good value for money, I understood notions that were very not clear to me. Thanks to Mark.
Very good communication and an excellent tutor.
Very happy with Mark's training ethos and training he provided.
Excellent course and really well presented. Starting from basic knowledge the course guided you through step by step and was well paced for all.
Really enjoyed the course. Tutor was knowledgeable, friendly and gave real-world, practical advice to get the most out of the training.
The trainer really tailored the course to our needs, encouraged us to ask questions, and was knowledgeable and really helpful.
The trainer was very patient and did not mind having to explain things a few times to make sure we were all on the same page, was very helpful for someone like myself who sometimes misses details on the first go around
Excellent trainer, the format of the training was fantastic and I got a lot from the course.
This was, by far, one of the best training courses I have had the pleasure of attending. The trainer was extremely knowledgeable and delivered a great course!
This was the first time I have joined an excel course and I found it very informative and very helpful.
I liked how the trainer tailored the training around what our needs and roles are.
A great pace for somebody just starting and never an issue with questions, and always had a good way of answering.
From knowing nothing to what I know now and in less than a day I would highly recommend as it was extremely useful, and has made my understanding of MP a 100x better. Thank you the trainer for the great lesson!
Excellent course, definitely the best 'power' course I have attended. The trainer was enthusiastic about the material and kept it relevant to our needs
The trainer was really knowledgeable and extremely helpful in helping us to build our own reports.
It was very productive as a working session. I learnt a lot.
His careful delivery of the course really made the difference not only in its usefulness but in how well we, as learners, will retain and apply this new information.
Verified reviews are published on our Reviews.io profile, where anyone can read every one of them.
Frequently asked questions
Do I need database experience?+
No. The course starts with how databases work and builds up step by step.
Can I bring my own database?+
For private courses, yes. We can use a copy of your database, with sensitive data removed, as the basis for exercises.
Which version of Access is used?+
We use Access for Microsoft 365 on Windows. The skills also apply to recent standalone versions.
How is the course delivered?+
Live with an instructor, in a virtual classroom or at your offices.
What should I learn after Access?+
If your data needs grow beyond Access, our SQL and Power BI courses are natural next steps for querying and reporting at scale.
