Your training and experience using Microsoft® Access® has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.
Microsoft Access for Office 365: Part 2
Ends soon: Gain next-level skills with Coursera Plus for $199 (regularly $399). Save now.
Microsoft Access for Office 365: Part 2
This course is part of Microsoft Access 365 Essentials Specialization
Instructor: Bill Rosenthal
Included with
Gain insight into a topic and learn the fundamentals.
1 week to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
What you'll learn
In this course, you will optimize an Access database.
Skills you'll gain
Details to know
Shareable certificate
Add to your LinkedIn profile
Recently updated!
January 2026
Assessments
1 assignment
Taught in English
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
This course is part of the Microsoft Access 365 Essentials Specialization
When you enroll in this course, you'll also be enrolled in this Specialization.
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
There are 7 modules in this course
You've created a database, and now you're starting to flesh out the user interface. As you plan the forms and controls that will enable users to interact with the database, you must think about more than just presenting data so users can view and interpret it easily and correctly. You must also consider how you will help users enter the required data in the correct format and follow rules of the business the database was designed to serve. Microsoft® Access® provides a number of tools you can use to prevent users from making input mistakes.
What's included
1 reading6 plugins
You want a database that is logically designed, communicates its purpose and design clearly to users, and allows for speedy retrieval of data. In this lesson, you will examine the process for determining if your tables are structured correctly, finding ways to alleviate redundancy, and making improvements to an existing design in Microsoft® Access®.
What's included
6 plugins
Datasheets are efficient for repetitive data entry tasks in tables, and in some situations may be more efficient or easier to work with than forms. While every table can be viewed in a datasheet, sometimes you need to work with data from an associated table.
What's included
5 plugins
In a well-designed relational database, it is often necessary to join data from multiple tables in order to view the results you're looking for. Queries enable you to do this, but to get the results you need, you must understand your options for joining data. Different types of joins are possible, and you can even use one query to provide the source content for another query. Crosstab queries enable you to reveal patterns within data that might not be evident through other types of queries. In this lesson, you will learn how to use these types of queries in Microsoft® Access®.
What's included
6 plugins
A well-designed user interface can go a long way toward reducing data entry errors and confusion on the part of the user. In this lesson, you will work with advanced formatting features in Microsoft® Access® that will help you improve the way you present data to users within forms.
What's included
5 plugins
Microsoft® Access® provides various features you can use to enhance reports, such as conditional formatting, themes, quick styles, and calculated fields. Various layout options and report properties enable you to control how reports print.
What's included
7 plugins
You'll wrap things up and then validate what you've learned in this course by taking an assessment.
What's included
1 assignment2 plugins
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
Offered by
Explore more from Business Essentials
Logical Operations
Logical Operations
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."
Frequently asked questions
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
More questions
Financial aid available,