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 1

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 1

This course is part of Microsoft Access 365 Essentials Specialization

Instructor: Bill Rosenthal

Included with

Learn more

6 modules

Gain insight into a topic and learn the fundamentals.

9 hours to complete

Flexible schedule

Learn at your own pace

6 modules

Gain insight into a topic and learn the fundamentals.

9 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

In this course, you will create and manage 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 6 modules in this course

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Access® can help you and your organization with this task. This course is the first 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 looking to establish a foundational understanding of Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries. In this course, you will: navigate within the Access application environment, create a simple database, and customize Access configuration options; organize and manage data stored within Access tables; use queries to join, sort, and filter data from different tables; use forms to make it easier to view, access, and input data; and create and format custom 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

In this lesson, you will become familiar with the general capabilities of the Office app Microsoft® Access®, and with the user interface, by working with a completed version of the database you will develop.

What's included

9 plugins

9 pluginsTotal 160 minutes

Getting Started with This Course30 minutes
Lesson Introduction5 minutes
Launch Access and Open a Database20 minutes
Use Tables to Store Data20 minutes
Use Queries to Combine, Find, Filter, and Sort Data20 minutes
Use Forms to View, Add, and Update Data20 minutes
Use Reports to Present Data20 minutes
Get Help and Configure Options in Access20 minutes
Lesson Summary5 minutes

You have navigated within an existing Microsoft® Access® database and have become familiar with the various components used to construct a database, including tables, queries, forms, and reports. Now you will create your own Access database, starting out by planning the database design. Then you will create a database file and tables, and populate those tables with data.

What's included

7 plugins

You have created a database, populated tables, and made updates to database content in Microsoft® Access®. You have searched, sorted, and filtered datasheets. As powerful as those features are, however, they are limited. They are temporary and easily overwritten. In this lesson, you will see how queries enable you to create reusable instructions that perform complex operations on dynamic table data fast and precisely the same way each time.

What's included

6 plugins

You have worked with data through tables and queries in Microsoft® Access®, and now you will see how to use forms to access data. Forms present the data in an interface that make it easier to view. In this lesson, you will create a form and then experience how it can improve the way users work with data.

What's included

5 plugins

You created a database and managed its content by using a variety of tools provided by Microsoft® Access®. For many, the ultimate reason to collect and organize data is to produce a report. In this lesson, you will create a report, add controls and change the report's layout, apply themes and layout options, prepare a report to be printed, organize report information, and format reports.