When will I have access to the lectures and assignments?

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.

What will I get if I subscribe to this Specialization?

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.

Is financial aid available?

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.

Microsoft Access for Office 365: Part 2

4 days left! Save on skills that make you shine with 40% off 3 months of Coursera Plus. Save now

Microsoft Access for Office 365: Part 2

This course is part of Microsoft Access 365 Essentials Specialization

Instructor: Bill Rosenthal

Included with

Learn more

7 modules

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

7 modules

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

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

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

Learn more about Coursera for Business

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

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

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.

This course is the second part of a three-course Specialization that covers the skills needed to perform database design and development in Access. This course may be a useful component in your preparation for the Microsoft Access Expert (Microsoft 365 Apps and Office 2019): Exam MO-500 certification exam. This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Microsoft 365. In this course, you will: provide input validation features to promote the entry of quality data into a database; organize a database for efficiency and performance, and to maintain data integrity; improve the usability of Access tables; create advanced queries to join and summarize data; use advanced formatting and controls to improve form presentation; and use advanced formatting and calculated fields to improve reports. This course requires that you have Microsoft Access installed on a Windows PC. The course setup instructions provided in the first module of the course go into more detail about the hardware and software requirements.

Module details

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

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