Microsoft Access for Beginners
Course Overview
Learn how to use Microsoft Access (Microsoft 365) to turn messy spreadsheets into neat, professional databases.
This course is easy to follow and teaches you how to make tables, build queries, design forms, and make clear reports that you can use right away. No technical jargon—just useful skills that will help you work more efficiently and manage data better.
Great for anyone who works with records, customers, or reports and wants to feel comfortable using Access.
Please note: Thames College is a One Education-approved resale partner for courses endorsed by the Quality Licence Scheme.
Duration: 2 hours, 45 minutes | Level: 7 | Language: English
What You'll Learn
- Learn how Microsoft Access works and when it's better than Excel.
- Make tables that are well-organised and have the right data types.
- Use relationships to set primary keys and link tables the right way.
- Make queries that let you quickly search, filter, and sort data.
- Write professional reports that make information easy to understand.
- Import data from Excel and send out reports when you need
- Put data in the right order to cut down on mistakes and duplicates.
- Make forms that are easy to use so that data can be entered quickly and accurately.
Exclusive Offer
Career Pathway
- Build your foundation: Start with this course to develop essential workplace skills in office administration, data coordination, record management, reporting, and operational support.
- Step into entry-level roles: Use your knowledge to apply for positions such as Office Assistant, Administrative Assistant, Data Coordinator, Records Clerk, or Operations Support Assistant.
- Gain practical experience: Strengthen your ability to manage documents, organise data, prepare reports, and support daily office processes while building hands-on experience in a professional setting.
- Upskill and expand responsibilities: Take on more complex tasks such as data analysis support, reporting coordination, workflow improvement, or compliance documentation as your confidence grows.
- Advance your career: Progress into roles like Office Manager, Operations Executive, Administrative Coordinator, or Business Support Specialist, continuing to develop leadership and organisational expertise.
Who Is This Course For?
It’s perfect for anyone who works with records, lists, or regular reports and is ready to move on from messy spreadsheets to a more organised and reliable system. This training will help you improve your data skills, whether you’re just starting out or already working in coordination, support, operations, or administrative roles. You’ll be able to use these skills every day.
Requirements
No formal entry requirements! No prerequisites or relevant experience is required!
This course is accessible to anyone with an eagerness to learn. All you require is —
- A smart device with a stable internet connection
- A keen interest in this subject
- And being over the age of 16.
Frequently Asked Questions
Q: Do I need any experience before taking this course?
A: No prior experience is required. This course is designed for complete beginners. Everything is explained step by step, from the very basics to building your own database.
Q: Which version of Microsoft Access is used in this course?
A: This course is based on Microsoft Access 365, the most up-to-date version included in Microsoft 365.
Q: Do I need Microsoft Excel before learning Access?
A: No. While basic Excel knowledge can help, it is not required. The course focuses fully on Microsoft Access and explains everything clearly.
Q: How long does it take to complete the course?
A: You can study at your own pace. Most learners complete the course within a few weeks of part-time study, but you will have one year of access to finish comfortably
Q:Will I receive a certificate after completion?
A:Yes. Upon successful completion, you will receive a Quality Licence Scheme endorsed certificate. A CPD Accredited certificate is also available.
Course Curriculum
| Module 01 | |||
| Orientation to Microsoft Access | 00:39:00 | ||
| Create a Simple Access Database | 00:10:00 | ||
| Get Help and Configure Options in Microsoft Access | 00:06:00 | ||
| Module 02 | |||
| Modify Table Data | 00:17:00 | ||
| Sort and Filter Records | 00:05:00 | ||
| Module 03 | |||
| Create Basic Queries | 00:15:00 | ||
| Sort and Filter Data in a Query | 00:14:00 | ||
| Perform Calculations in a Query | 00:08:00 | ||
| Module 04 | |||
| Create Basic Access Forms | 00:07:00 | ||
| Work with Data on Access Forms | 00:23:00 | ||
| Module 05 | |||
| Create a Report | 00:12:00 | ||
| Add Controls to a Report | 00:12:00 | ||
| Enhance the Appearance of a Report | 00:05:00 | ||
| Prepare a Report for Print | 00:03:00 | ||
| Organize Report Information | 00:15:00 | ||
| Format Reports | 00:12:00 | ||
| Workbooks | |||
| Workbooks: Microsoft Access for Beginners | 00:00:00 | ||
| Mock Exam | |||
| Mock Exam- Microsoft Access for Beginners | 00:20:00 | ||
| Final Exam | |||
| Final Exam- Microsoft Access for Beginners | 00:20:00 | ||
| Assignment | |||
| Assignment – Microsoft Access for Beginners | 1 week, 2 days | ||
Certificate of Achievement
Upon completion, you will receive a CPD-accredited certificate recognised globally. Choose from:
Pdf Certificate & Transcript £7.99
Hardcopy Certificate & Transcript £17.99
This certification validates your knowledge and skills, boosting your employability in healthcare.
Course Reviews
No Reviews found for this course.
Access
Level
Number of Units
Duration