Packt
Microsoft Access 2021 - Beginner to Advanced
Packt

Microsoft Access 2021 - Beginner to Advanced

Included with Coursera Plus

Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

31 hours to complete
3 weeks at 10 hours a week
Flexible schedule
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
Intermediate level

Recommended experience

31 hours to complete
3 weeks at 10 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • Build and manage relational databases, tables, and relationships efficiently using Access 2021.

  • Design interactive forms, subforms, and complex reports to visualize and enter data effectively.

  • Automate tasks with macros and write VBA code for advanced customization and control.

  • Implement SQL queries, secure your database, and manage multi-user environments confidently.

Details to know

Shareable certificate

Add to your LinkedIn profile

Recently updated!

July 2025

Assessments

30 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

 logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 30 modules in this course

In this module, we will introduce you to Microsoft Access 2021 and the course structure. You will learn how to acquire and install Access, explore new features, and complete your first hands-on exercise to set up your working environment.

What's included

4 videos1 reading

In this module, we will guide you through creating, saving, and opening databases. You’ll learn to customize the toolbar and menus, explore keyboard shortcuts, and practice building your first inventory database using templates.

What's included

9 videos1 assignment1 plugin

In this module, we will teach you the essentials of table creation and management. You will build tables, apply indexing and validation, and perform practical exercises to reinforce your data structuring skills in Access 2021.

What's included

6 videos1 assignment1 plugin

In this module, we will show you how to seamlessly import data from Excel spreadsheets and text files into Microsoft Access 2021. You will gain hands-on experience with data import processes to enhance your database's versatility.

What's included

3 videos1 assignment1 plugin

In this module, we will explore the Datasheet View in Access 2021, focusing on its design and data manipulation capabilities. You will practice sorting, filtering, and editing records to become proficient in managing data visually.

What's included

4 videos1 assignment1 plugin

In this module, we will guide you through setting up and managing relationships between tables in Access 2021. You will learn to create link tables and enforce integrity rules, ensuring your database maintains accurate and related data.

What's included

6 videos1 assignment1 plugin

In this module, we will teach you how to create and personalize forms to interact with your database. You’ll explore different views and form properties, culminating in a hands-on exercise building a custom order maintenance form.

What's included

6 videos1 assignment1 plugin

In this module, we will cover the process of creating and linking subforms in Access 2021. You’ll learn to build relational forms that improve data presentation and complete practical tasks to reinforce these concepts.

What's included

3 videos1 assignment

In this module, we will introduce you to creating and running queries in Access 2021. You’ll learn essential join types and practice building queries to extract meaningful information from your database.

What's included

4 videos1 assignment1 plugin

In this module, we will focus on setting up validations and expressions in Access 2021. You will learn how to enhance data accuracy and perform calculations, finishing with hands-on practice creating calculated controls on forms.

What's included

3 videos1 assignment1 plugin

In this module, we will explore report creation in Access 2021, from running simple reports to designing complex layouts. You will practice crafting personalized reports that showcase your database insights effectively.

What's included

4 videos1 assignment1 plugin

In this module, we will introduce additional data types available in Access 2021. You’ll learn to incorporate Boolean fields and attach files to records, expanding the functionality of your database with hands-on application.

What's included

3 videos1 assignment1 plugin

In this module, we will deepen your knowledge of form controls and design in Access 2021. You will explore option buttons, themes, and navigation forms, and complete exercises to create polished, user-friendly interfaces.

What's included

4 videos1 assignment1 plugin

In this module, we will teach you how to share your Access 2021 databases securely. You’ll learn to export data, set properties, encrypt files, and practice these skills to protect your information.

What's included

3 videos1 assignment1 plugin

In this module, we will explore advanced Access features that help maintain and document your database. You will practice compacting, repairing, printing reports, and generating detailed documentation.

What's included

3 videos1 assignment1 plugin

In this module, we will conclude the beginner course, recapping essential skills and achievements. This prepares you for the advanced topics coming next in your Access 2021 journey.

What's included

1 video1 assignment1 plugin

In this module, we will introduce the advanced Access 2021 course content. You’ll get set up for success and be ready to dive deeper into complex database management.

What's included

2 videos1 assignment1 plugin

In this module, we will cover advanced concepts of primary keys and indexes in Access 2021. You will learn best practices and strategies for efficient database design.

What's included

2 videos1 assignment1 plugin

In this module, we will guide you through advanced datasheet view techniques using the Northwind database. You’ll learn customization and data analysis skills to manage complex datasets.

What's included

6 videos1 assignment1 plugin

In this module, we will demonstrate how to link tables across Access databases. This technique expands your data sources and improves data management flexibility.

What's included

1 video1 assignment1 plugin

In this module, we will cover integrating Access 2021 with SQL Server using ODBC. You will gain skills in installation, configuration, and linking for enterprise-level database solutions.

What's included

3 videos1 assignment1 plugin

In this module, we will explore splitting your Access database to optimize performance and collaboration. You will practice dividing your database and addressing multi-user issues.

What's included

4 videos1 assignment1 plugin

In this module, we will introduce macro basics and automation in Access 2021. You’ll learn to build macros, manage events, and secure your macros for effective task automation.

What's included

5 videos1 assignment1 plugin

In this module, we will teach you how to personalize the Access ribbon and toolbar. Customizing these elements helps you work faster and more comfortably.

What's included

1 video1 assignment1 plugin

In this module, we will dive into VBA programming in Access 2021. You will unlock powerful customization options by learning to write and manage VBA code effectively.

What's included

5 videos1 assignment1 plugin

In this module, we will cover the Access events model, enabling you to automate and control user interactions. You will build advanced functions and user interfaces through event handling.

What's included

5 videos1 assignment1 plugin

In this module, we will teach advanced form design techniques. You will learn to format forms, manage errors, and build intuitive tabbed interfaces for better user experiences.

What's included

5 videos1 assignment1 plugin

In this module, we will deepen your query skills with advanced SQL and action queries. You will practice building powerful queries that manipulate and analyze data dynamically.

What's included

8 videos1 assignment1 plugin

In this module, we will teach you how to protect your Access 2021 databases and code. You’ll learn encryption, password management, and packaging techniques to safeguard your work.

What's included

2 videos1 assignment1 plugin

In this final module, we will summarize your advanced Access 2021 journey. You’ll revisit key concepts and celebrate your accomplishment as you complete the course.

What's included

1 video2 assignments

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Packt - Course Instructors
Packt
756 Courses157,214 learners

Offered by

Packt

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Coursera Plus

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions