Logical Operations

Microsoft Access 365 Essentials Specialization

Logical Operations

Microsoft Access 365 Essentials Specialization

Use Access to Manage Relational Databases.

Solve business problems by managing relational databases with Access.

Bill Rosenthal

Instructor: Bill Rosenthal

Access provided by Vanderbilt University

Get in-depth knowledge of a subject
Beginner level

Recommended experience

4 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
Get in-depth knowledge of a subject
Beginner level

Recommended experience

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

What you'll learn

  • In this Specialization, you will learn a comprehensive set of Access skills—from the essentials to more advanced skills.

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English
Recently updated!

January 2026

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

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

Advance your subject-matter expertise

  • Learn in-demand skills from university and industry experts
  • Master a subject or tool with hands-on projects
  • Develop a deep understanding of key concepts
  • Earn a career certificate from Logical Operations

Specialization - 3 course series

Microsoft Access for Office 365: Part 1

Microsoft Access for Office 365: Part 1

Course 1, 9 hours

What you'll learn

  • Navigate the Access environment to open databases, understand object views, and configure basic application options.

  • Build relational tables, assign data types, establish primary keys, and enforce referential integrity between datasets.

  • Design custom queries, forms, and reports to easily filter data, compute calculations, and present professional layouts.

  • Learn by doing. Perform guided, step-by-step hands-on activities on your own computer.

Skills you'll gain

Category: Database Design
Category: Query Languages
Category: Microsoft Access
Category: Database Application
Category: Data Access
Category: Data Entry
Category: Productivity Software
Category: Database Management
Category: Database Development
Category: Relational Databases
Category: Data Management
Category: Microsoft Office
Category: User Interface (UI)
Category: Databases
Category: Data Integration
Category: Microsoft 365
Microsoft Access for Office 365: Part 2

Microsoft Access for Office 365: Part 2

Course 2, 11 hours

What you'll learn

  • Optimize performance and integrity of an Access database by applying field validation rules, record validation rules, and custom input masks.

  • Restructure tables into first, second, and third normal forms using junction tables to resolve many-to-many relationships.

  • Build advanced query joins, subqueries, and crosstab tables to isolate null values and cleanly summarize complex datasets.

  • Learn by doing. Perform guided, step-by-step hands-on activities on your own computer.

Skills you'll gain

Category: Microsoft Access
Category: Data Validation
Category: Database Management
Category: Productivity Software
Category: Database Management Systems
Category: Data Entry
Category: User Interface (UI) Design
Category: Data Management
Category: User Interface (UI)
Category: Database Design
Category: Database Development
Category: Data Presentation
Category: Microsoft 365
Category: Relational Databases
Category: Microsoft Office
Category: Data Integrity
Category: Databases
Category: Query Languages
Category: Database Software
Microsoft Access for Office 365: Part 3

Microsoft Access for Office 365: Part 3

Course 3, 12 hours

What you'll learn

  • Connect your database to outside sources by importing text files, linking Excel sheets, and setting up Word mail merges.

  • Clean up and maintain your tables using action queries to append or delete items, while identifying duplicate and unmatched records.

  • Secure and distribute your database by splitting it for multiple users, setting passwords, and converting files to compiled ACCDE formats.

  • Learn by doing. Perform guided, step-by-step hands-on activities on your own computer.

Skills you'll gain

Category: Database Management
Category: Microsoft Access
Category: Data Maintenance
Category: Productivity Software
Category: Database Development
Category: Database Software
Category: Database Management Systems
Category: Microsoft Windows
Category: Database Design
Category: Scripting
Category: Database Architecture and Administration
Category: Relational Databases
Category: Query Languages
Category: Microsoft Office
Category: Microsoft 365
Category: Data Entry
Category: Database Administration
Category: Data Presentation
Category: User Interface (UI)
Category: Databases

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

Bill Rosenthal
Logical Operations
158 Courses38,028 learners

Offered by

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."