Course Offerings

Introduction to Microsoft Access 2016

Course ID: OST-3100AOE
Overview
Course Outline
Requirements
Intended Audience
More Details

Take control of your data! In this course, you learn how to harness the power of Microsoft Access 2016 to organize, store, edit, manage and report on hundreds of thousands of records. Through easy-to-follow, step-by-step instructions, this course helps you master Access and put it to creative, confident use. You develop not only strong Access skills, but a solid understanding of good database design concepts. By the time you finish the course, you know how to organize and assemble an effective database for any kind of information you need to store, document and manage.

Course Objectives

Build, edit and maintain databases in Microsoft Access 2016 using tables, reports, forms and queries to give you fast access to all your important information

Gain the skills to create an effective database for any type of information at home or on the job

Outline of Instruction

Getting to Know Access 2016

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

CEUs

Industry Standard, State or National Certification

Certification

None

Website

None

Certification Learning Outcomes/Requirements

CE or CU Articulation

Prerequisites

N/A

Learning Supplies Needed

Hardware requirements:
This course must be taken on a PC. Macs are not compatible.

Software requirements:
PC: Windows 8 or later
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
Microsoft Access 2016 or 2019 (not included in enrollment)
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 quiz 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.