Microsoft Access Training courses
Course schedule - Microsoft Access Training Courses
Online Microsoft Access courses we offer:
Microsoft Access Training – Build Powerful Desktop Databases for Your Business
Want to learn how to create a database that stores your business information, analyses data, and generates insightful reports? Our Microsoft Access courses are designed to give you the practical skills you need.
Whether you need a database for one user or multiple users, we’ll teach you how to plan, build, optimize, secure, and manage your Access database with confidence.
Understanding database design principles is just as important as mastering Microsoft Access software. Our expert trainers deliver engaging, easy-to-follow sessions that make learning simple and effective.
Looking for a Microsoft Access course for beginners or an advanced online Access course? We have options for every skill level—and we can even customise training to meet your specific requirements.
What makes TCS Training different from other IT Training providers?
We offer:
Hands-on IT training - engaging courses delivered by friendly and qualified trainers.
Public courses are small - up to 4 delegates only.
1 year after course support is included with all courses.
Group booking rates are available on request.
100% of participants recommend TCS Training - read live reviews
Microsoft Access Introduction Course – Two days – £445
Master the basics of Microsoft Access with TCS Training. This beginner-friendly course is perfect whether you’re new to Access or want to strengthen your foundation skills. Gain the confidence to create interactive databases that work seamlessly for your business needs.
Our comprehensive 2-day Microsoft Access training teaches you how to build a database from scratch. You’ll learn to:
- Create tables, fields, and records
- Set data entry rules for accuracy
- Design forms for easy input
- Extract data using queries and reports
- Export data to Excel, PDF, or Word (including mail merge)
We also cover essential database design principles, ensuring you understand how databases work and how to structure them effectively.
Who Should Attend?
This course is ideal for beginners or anyone looking to refresh their skills.
Pre-requisite: You must be comfortable using a computer.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
Microsoft Access Introduction training course outline
Getting Started and Table Design
Create a new database, Overview of the Microsoft Access Environment, Create new tables, Set field names, Choose data types, Consider and set field properties, Create a drop down list
Understanding Relationships
Create One to Many Relationships, Create One to One Relationships, Change Relationship Properties, Understand Referential Integrity
Work with Forms
Create a standard Form, Create a Form using the Wizard, Re-design a Form, Create a Form with a sub-form, Input data using Forms
Work with Queries
Create and save standard Queries, Sort data within a Query, Set criteria for Queries, Concatenate data within a Query, Create calculations in a Query, Use Parameter Query
Work with Reports
Create a report from Table data, Create a report from Query data, Group Information in a Report, Re-design Report elements, Create Mailing Labels
Export data from Microsoft Access
Export information to Microsoft Excel, Export information to Microsoft Word, Export information to a PDF file, Use the Mail Merge feature
Microsoft Access Intermediate Course- One day – £245
Take Your Access Skills to the Next Level
Ready to move beyond the basics of Microsoft Access? This one-day Access intermediate training is designed for users who want to upgrade their skills from beginner to intermediate level and unlock more advanced features of Access.
What You’ll Learn:
- Build a database application for multi-user environments
- Create advanced queries and reports for deeper insights
- Work with the interaction between Access objects
- Manage the database and build and Interface
This in-depth course gives you the tools to create smarter, more dynamic databases that streamline your workflow.
Pre-requisite:
Delegates should have completed our Microsoft Access Introduction course or be confident with the topics covered at that level.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
Microsoft Access Intermediate training course outline
Design a Database
Understand and perform Normalisation, Create a new database, Understand relationship types, Know how to resolve a many to many relationships
Import Data
Import data from Excel, Import data from a text file, Analyse imported data
Create an Interface
Create navigation forms, Use command buttons, Display a form at database start up
Work with Forms
Insert Sub-Forms, Create Combo-boxes, Work with Attachment data types
Work with Queries and Reports
Create Action Queries, Use Functions in Queries, Supply parameters to a form from a Query, Use the Expression Builder, Change Query Joins Types, Create Crosstab Queries, Create Total Queries, Build reports and summarise data
Back up a Database, Compact and Repair a Database, Password protect a database
Microsoft Access Advanced Course – Two days £495
Microsoft Access Advanced Course – Design and Administer Professional Databases
You’ve mastered the basics of storing and retrieving data—now it’s time to take your skills further. In this two-day advanced Microsoft Access training, you’ll learn how to plan, design, and administer a fully functional relational database system for real-world business applications.
What You’ll Learn:
- Create and manage efficient relational databases for company use
- Design systems that handle tasks like bookings, invoicing, and reporting
- Build an interactive database application with a secure back-end and user-friendly front-end
- Apply best practices for database design, maintenance, and optimisation
By the end of this course, you’ll have the skills to develop a robust, interactive system suitable for multi-user environments.
Who Should Attend?
This course is ideal for those who have completed our Microsoft Access Intermediate training or have a strong understanding of database design and are ready for advanced-level skills.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
Microsoft Access Advanced training course outline
Design a Database
Perform Normalisation of data, Create a new database, Set relationships, Import data
Work with Forms
Create a Combo Box Control, Create a List Box Control, Create an Option Group Control,
Create a Tabbed Control and manage elements, Insert sub-forms, Identify and understand Form Properties
Create Documents from a system
Work with reports, Use unbound controls, Use bound controls, Write functions, Create Macros to manage behaviour, Use Macros to provide system messages, Assign Macros to events
Work with Queries
Use Date Functions, Use Queries to generate data for Forms
Database Management and Security
Set a database password, Discuss database security, Set Start-up options
Save a database as ACCDE
You may also be interested in these related courses
SQL Courses (Structured Query Language)
Our SQL courses teach you coding which allows integration with Crystal Reports to enhance data management and analysis capbilities. Crystal Reports supports SQL bringing together all the skills you need with programming for importing, filtering and transforming data from multiple sources.
Microsoft Excel Courses
The Excel skills you learn by attending one of our Microsoft Excel courses, also transfer nicely to Microsoft Access. You can also link to Excel data sheets, along with other data scourses to build your comprehensive and meaningful reports within Microsoft Access. You can also write SQL directly to extract data from any database.
Microsoft Power BI courses
Our Microsoft Power BI training courses for data visualisation business intelligence and reporting. You can connect to your Access data, as well as other data sources, then analyse and transform your data. Use Power BI to create interactive reports and dashboards in your browser which you can easily share with others.
View all our IT Training Courses
Microsoft
Courses
Adobe
Courses
Programming
Courses
What our customers say
Why Choose TCS Training?
Expert Instructors
Our courses are led by experienced and certified trainers who are experts in their fields.
Flexible Learning Options
We offer both live online and on-site training to fit your schedule and learning preferences.
Comprehensive Course Materials
Receive detailed workbooks, reference manuals, and other resources to support your learning.
Post-Course Support
Benefit from up to a year of after-course support to help you apply what you've learned.
Customizable Training
We provide standard, tailored, or bespoke training solutions to meet your specific needs.
Group Booking Discounts
Take advantage of special rates for group bookings, whether for public or private courses.
Work with us
Want to chat to someone from our team about a training course or need something tailored for you - no problem.