ZPDI0583 - Microsoft Office 365: Access 2019 (Online)

Course Description

Explore the many facets of Microsoft Access 2019. Learn basic functions such as database objects, querying a database and creating reports, as well as advanced reporting techniques, macros and database design. Microsoft Office 365 required to complete coursework. 

Course Outline

Lesson 1: Database Basics

Explore features and properties of Microsoft Access, learning how to open and query a database to gather information and export data.

Lesson 2: Maintaining a Database and Creating Reports

Learn how to complete maintenance tasks like adding, modifying and removing data as well as restructuring the database and using the Wizard to create reports and forms.

Lesson 3: Advanced Reporting

Explore more advanced functions such as using multiple tables to run a query, advanced reporting, subreports and aggregate functions.

Lesson 4: Advanced Form Techniques and Macros

Learn how to insert and modify charts, use more advanced form techniques, and use macros to help with reporting and forms.

Lesson 5: Administering Access and Using SQL

Explore Microsoft Access administrative functions like creating custom data types, indexes and templates, and learn how SQL language works with Access.

Lesson 6: Database Design

Learn how to design a custom database, determining the tables and fields needed to fit your purpose and how to represent the design with a diagram.

Learner Outcomes

Upon successful completion of this course, students will be able to:

• Create a Microsoft Access database.
• Create a report from a database.
• Create queries in a database.
• Maintain a database by using action queries, formatting a datasheet and sorting records.
• Create reports and forms.
• Perform advanced report and form techniques.
• Create and modify macros in a database.
• Demonstrate the use of SQL language.
• Design a database.

Notes

Students must have a copy of Microsoft Office 365 in order to complete coursework.

Students have 12 months to complete this self-paced online course.

All necessary course materials included.

Certification(s):

• This course prepares a student to take the Microsoft Access 2019 national certification exam.

System Requirements:

Internet Connectivity Requirements:

• Cable and DSL internet connections recommended for best experience.

• CPU: 1 GHz or higher
• RAM: 2 GB or higher
• Resolution: 1280 x 720 or higher
• Speakers / Headphones
• Microphone (Webinar / Live Online sessions)

• Microsoft Windows 7 or 10 (Home, Pro)
• Mac OSX 10 or higher.
• Latest Chrome OS
• Latest Linux Distributions

NOTE: While our courses can be viewed on Android and iPhone devices, their size does not provide an optimal learning environment for online or live online-based courses.

• Latest Google Chrome recommended for best experience.
• Latest Mozilla FireFox
• Latest Microsoft Edge
• Latest Apple Safari

• Office suite software (Microsoft Office, OpenOffice or LibreOffice)
• PDF reader program (Adobe Reader, FoxIt)
• May require other software as denoted in course outline.