- All Courses
- Microsoft Office
- Microsoft Access
Microsoft Access Training Courses
You will learn how to effectively use Access to manage your data; such as creating a new database, constructing tables, designing forms and reports, creating queries to join, filter, and sort data.
Microsoft Access Introduction Course
Start learning Microsoft Access by creating databases, tables, forms, and reports, and executing queries to filter, sort, and join data.
- Develop skills in organising, managing, and querying data within Access tables.
- Learn to navigate, create, and customise Access databases efficiently.
- Utilise forms for easier data input, and create and format custom reports.
Microsoft Access Intermediate Course
Build on from the basics and learn to improve and customise tables, queries, forms and reports, and share Access data with other applications.
- Master Relational Database Fundamentals by Learning about database normalisation, table relationships, and referential integrity for effective data organisation.
- Enhance Data Analysis with Advanced Queries including table joins, calculated fields, and value summarisation.
- Polish Presentation and Reporting Skills by developing proficiency in advanced form design, report formatting, and chart integration for professional data presentation.
Microsoft Access Advanced Course
Maximise the potential of Microsoft Access by creating structured databases, writing advanced queries, working with macros, and performing database maintenance.
- Efficient Data Management and Integration, including techniques for importing, exporting, and performing mail merges with table data.
- Advanced Reporting and Automation; Creating complex reports and forms, incorporating subreports, navigation forms, and detailed subforms.
- Automating tasks with Access macros, including standalone macros and data macros, and extend capabilities using VBA with form controls.
Don’t know which level you need?
Enquire Now for a free Microsoft Access AssessmentWhat is Microsoft Access?
Microsoft Access is a Database Management System (DBMS) from Microsoft and is a member of the Microsoft Office suite of applications.
Study Microsoft Access courses with Infero Training
Welcome to our comprehensive Microsoft Access training program! We offer a variety of courses tailored to meet your needs, from Beginners to Advanced levels. Our Access courses take in all levels, including Introduction, Intermediate and Advanced. Each course lasts a day, but we can also create custom courses for specific requirements.
Introduction: This course is ideal for students looking to build a solid foundation in Microsoft Office Access. You’ll learn essential skills such as creating databases, designing tables, forms, and reports, and executing queries to manage and analyse data effectively.
Intermediate: Designed for individuals seeking to expand their knowledge of Access, this course covers intermediate-level operations. You’ll enhance and customise tables, queries, forms, and reports, as well as learn how to share Access data with other applications.
Advanced: Geared towards database administrators or those aspiring to be, this course dives into advanced Access skills. You’ll master tasks like structuring complex databases, writing advanced queries, utilising macros for automation, and maintaining database integrity.
Testimonials
Top Microsoft Access FAQs
- Start: 9:00am
- Break: 11:00am
- Lunch: 1:00pm
- Break: 3:00pm
- Finish: 5:00pm