Course Offerings

Introduction to Microsoft Access 2016

Course ID: OST-3100ANE
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 not only develop strong Access skills, but you also gain a solid understanding of good database design concepts. By the time you've finished the course, you'll 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

Outline of Instruction

Getting to Know Access 2016
Find out what Access is and how individuals, businesses and organizations use it to store information
Begin to build an Access database, including all the components that turn a list of records into reports, forms and queries
Start by opening the application and creating a new database

Controlling Your Access Table Fields
Impose rules that automatically fill an Access table field with a preset value or that automatically insert the symbols commonly included in phone numbers
Set up rules that allow only certain kinds of data in certain fields
With just a few minutes of work, you can make data entry simpler, clearer and practically error-free.

Creating Tables and Relationships
Create additional tables for the class database, customize them along the way and then build relationships between them
This all paves the way for later database features, such as reports, queries and forms that draw from multiple tables in the database

Building Powerful Forms
Use forms for data entry and for viewing records in your tables
Meet the Form Wizard, which makes form building fast and easy and allows you to select one or more tables' fields to include
Determine the form layout

Adding Versatility to Forms
Add buttons and controls to forms
Adjust table relationships to support the creation of multi-table forms, which paves the way to creating queries and reports that draw data from more than one table

Interviewing Your Database
Using queries to sort, filter and search your database is one of the most important skills to master in this course.
Create queries that search for specific data
Customize how Access displays that data
Follow instructions step by step so you gain confidence with the process, and then create a query on your own.

Taking Queries to the Next Level
A query that puts specific records in order or finds all the records that have a general piece of information in common is pretty common. Being able to create that kind of query is a great foundation skill, but it won't help you find a very specific record. Nor will it let you search for records within a span of dates or other numeric values. It also won't help you exclude certain records, reducing a large pool of data to just those records you need to see.
Create queries that give you true power to search your database

Multi-Table Query Control
Learn to plan, build and use queries that pull data from multiple tables simultaneously. This gives you more power over your data and allows you to build the foundation for truly customized reports.

Reporting on Your Tables
Reports are easy to create and customize. Build a simple report using the Report Wizard.
Change the report's appearance using layout view and design view
These skills are foundational to creating and designing reports for any data in your database.

Creating Query-Based Reports
Create reports that are based on the results of queries you create to sort and filter your database
Because queries can combine data from multiple tables, filter for specific data and sort the results, your report reflects just the data that meet the query's criteria.

Mastering Report Design
Plan and create a completely customized report using a specialized query that controls which data the report includes
Add fields that perform calculations on your data
Customize your report's layout using design view's many tools for controlling the structure and appearance of your data.

Automating Your Database With Macros
Building macros (short programs that perform a series of steps) helps you speed up and create consistency in your more repetitive Access tasks. From opening a form to running a report to building a new record in a table, macros eliminate redundant procedures by turning them into something you can do with one click.

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 are 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 successfully 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 for successful completion. The final exam must be taken by the Wake Tech course end date.