Course Offerings

Virtually every industry can benefit from the use of Microsoft Access to organize, store and document essential information. Data ranging from inventory and customer information to orders details and vendors can be effectively organized with Microsoft's longstanding software. If you work with databases of any kind, learning how to use Access adds a valuable skill set to your professional profile.

This course teaches you one of the most useful skills for both job-seekers and those looking for promotion. If you know how to use Microsoft Excel, learning Access informs and enhances your current skill set, allowing you to take a stronger role in database management. This course is for Access versions 2019, 2021 and Office 365.

Course Objectives

Build and customize Access databases

Gain more understanding of existing Access databases

Gain knowledge to take a stronger role in database maintenance

Design professional-looking forms and reports

Outline of Instruction

Getting to Know Access 2019


Controlling Your Access Table Fields

Creating Tables and Relationships

Building Powerful Forms

Adding Versatility to Forms

Interviewing Your Database

Taking Queries to the Next Level

Multi-Table Query Control

Reporting on Your Tables

Creating Query-Based Reports

Mastering Report Design

Automating Your Database With Macros

Contact Hours

24

CEUs

No

Industry Standard, State or National Certification

Certification

None

Website

None

Certification Learning Outcomes/Requirements

CE or CU Articulation

No

Prerequisites

N/A

Learning Supplies Needed

Hardware requirements:
This course can be taken on either a PC, a Mac or a Chromebook.

Software requirements:
PC: Windows 10 or later
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
Microsoft Access 2019, 2021 or Office 365 desktop (not included in enrollment). Available to download with a subscription to Microsoft 365, or with Microsoft Office Professional. Microsoft Access 2016 is also acceptable.
NOTE: There may be some differences between your version of Access and what you see in the course.
Adobe Acrobat Reader
Software must be installed and fully operational before the course begins.

Other:
Email capabilities and access to a personal email account

Instructional material requirements:
The instructional materials required for this course are included in enrollment and will be available online.

Clinical Site/Special Facilities

N/A

Requirements for Successful Completion

90% attendance
Students must pass 10 quizzes with a minimum grade of 70% by the second attempt. If all quizzes are not passed with 70% or better by the second attempt, the final exam score must be 70% or higher on the first attempt. The final exam must be taken by the Wake Tech course end date.

Accreditation/Special Approval Requirements

N/A

Intended Audience

If you want to learn the 2019 version of Microsoft Access, this course is for you!

Specific Industry or Business Support Needs

N/A

Wake County Need for Industry Positions

N/A

Industry or Job Titles Related to Training Outcomes for Employment

Related Courses

Course Contact Information

Courtney Boney
919-532-5581
[email protected]