Microsoft Access 365 Essentials

via Coursera Specialization

Go to class Write review

Details

Go to class

Provider

Coursera Specialization
Pricing

Paid Course
Languages

English
Certificate

Certificate Available
Duration & workload

4 weeks, 10 hours a week

Found in

Overview

Coursera Flash Sale

40% Off Coursera Plus for 3 Months!

Grab it

This Specialization equips learners with the skills to create, sort, filter, format, and present data efficiently using Microsoft Access. It covers everything from queries, forms, reports, macros, and Visual Basic for Applications (VBA). Whether you work in business, non-profit, or government, this expertise enables professionals to make data-driven decisions, streamline workflows, and boost productivity across the organization.

Syllabus

Course 1: Microsoft Access for Office 365: Part 1
Course 2: Microsoft Access for Office 365: Part 2
Course 3: Microsoft Access for Office 365: Part 3

Courses

0 reviews
8 hours 35 minutes
View details

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.
0 reviews
10 hours 40 minutes
View details

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.
0 reviews
11 hours 50 minutes
View details

You've covered many of the basic functions of Microsoft® Access®, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separates database professionals from the casual database users or occasional designers. This course is the third part of a three-course Specialization that covers the skills needed to perform basic 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. Students taking this course are database administrators or prospective database administrators who have experience working with Access for Microsoft 365 and need to learn advanced skills. In this course, you will: share data across applications; use action, unmatched, and duplicate queries to manage data; create complex reports and forms; use macros to improve user interface design; use VBA to extend database capabilities; perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting; and implement security strategies and distribute a database to multiple users. 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.