Online Class: Microsoft Access 2016

This course covers all the important features of Access 2016 and demonstrates how to use them.

$95.00
no certificate

- OR -

$120.00
with CEU Certificate*

Start Right Now!

$120.00 (with CEU Certificate)

Taking multiple courses? Save with our platinum program.

22

Lessons
23

Exams &
Assignments
4,268

Students
have taken this course
12

Hours
average time
1.2

CEUs

Course Description

Microsoft Access 2016 is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you. Access makes it easy to keep track, organize, and sort your data. It can be the back-end of a business, keeping your records for you.

This course covers all the important features of Access 2016 and demonstrates how to use them. This course is designed for beginners so that even if you've never so much as opened the program before, you can learn how to use it like a pro. Once we cover the basics, we'll move on to advanced features. If you've used Access before, perhaps previous versions, the first few lessons will be a refresher and introduce you to some of the updates you'll encounter in the newest version of Microsoft Access.

You'll learn:

· All about databases and how they work

· An understanding of how Access works to make even its complex inner workings seem simple

· How to navigate Access

· How to create tables, forms, reports, and queries

· How to enter criteria into your data

· How to form expressions and create functions

· How to customize the appearance of forms and reports

· How to use Access for home-record keeping or for a business

And much, much more.

If you're not familiar with Access 2016, it can be overwhelming. The program is large and navigating it without any help or experience can seem impossible. This course takes its time and shows you around Access. We'll break everything down into small chunks so that Access 2016 is just as easy for the beginner to use as it is someone who's been using it for years. With step-by-step written directions, screenshots of every procedure, and HD Video tutorials, you'll have no problems learning this program! And if you've used Access before, don't worry. We have plenty of updates to show you – and a few more things to teach you as well. So join us today!

Courses Frequently Bought Together:

Microsoft Excel Level 1

Microsoft Word Level 1

Microsoft PowerPoint Level 1

Completely Online
Self-Paced
Printable Lessons
Full HD Video
6 Months to Complete
24/7 Availability
Start Anytime
PC & Mac Compatible
Android & iOS Friendly
Accredited CEUs

Universal Class is an IACET Accredited Provider

Course Lessons

Average Lesson Rating:

"Extraordinarily Helpful"

(2,089 votes)

Lesson 1: Introduction to Microsoft Access 2016

Microsoft Access is an information management tool that allows you to store, report, and analyze information. 5 Total Points

Lesson 1 Video
Lesson discussions: Access 2016; Reasons for Taking this Course
Complete Assignment: Motives for Taking this Course
Assessment: Lesson 1 Exam

Lesson 2: Access 2016 Requirements and Setup

Access 2016 Requirements and Setup 3 Total Points

Lesson 2 Video
Assessment: Lesson 2 Exam

Lesson 3: About Databases and Design

About Databases and Design 5 Total Points

Lesson 3 Video
Assessment: Lesson 3 Exam

Lesson 4: Access 2016 Database Objects

Access 2016 Database Objects 5 Total Points

Lesson 4 Video
Assessment: Lesson 4 Exam

Lesson 5: Navigating MS Access 2016

Navigating MS Access 2016 4 Total Points

Lesson 5 Video
Assessment: Lesson 5 Exam

Lesson 6: Creating a Database and Adding Tables

Creating a Database and Adding Tables 5 Total Points

Lesson 6 Video
Assessment: Lesson 6 Exam

Lesson 7: Object Views

Object Views 5 Total Points

Lesson 7 Video
Assessment: Lesson 7 Exam

Lesson 8: Creating Simple Forms

Creating Simple Forms 5 Total Points

Lesson 8 Video
Assessment: Lesson 8 Exam

Lesson 9: Introduction to Controls and Formatting Forms

Introduction to Controls and Formatting Forms 5 Total Points

Lesson 9 Video
Assessment: Lesson 9 Exam

Lesson 10: Queries

Understanding Queries 8 Total Points

Lesson 10 Video
Assessment: Lesson 10 Exam

Lesson 11: Using Criteria, Operators, and Wildcards

Using Criteria, Operators, and Wildcards 5 Total Points

Lesson 11 Video
Assessment: Lesson 11 Exam

Lesson 12: Parameter Queries

Parameter Queries 3 Total Points

Lesson 12 Video
Assessment: Lesson 12 Exam

Lesson 13: Relationships

Relationships 5 Total Points

Lesson 13 Video
Assessment: Lesson 13 Exam

Lesson 14: Normalization

Normalization 5 Total Points

Lesson 14 Video
Assessment: Lesson 14 Exam

Lesson 15: Creating Calculated Expressions

Creating Calculated Expressions 5 Total Points

Lesson 15 Video
Assessment: Lesson 15 Exam

Lesson 16: Summarizing Data

Summarizing Data 3 Total Points

Lesson 16 Video
Assessment: Lesson 16 Exam

Lesson 17: Reports

Creating reports using the report tool 4 Total Points

Lesson 17 Video
Assessment: Lesson 17 Exam

Lesson 18: Designing Your Report

Once you have your report created, you can now modify it to create a more attractive design for it. 5 Total Points

Lesson 18 Video
Assessment: Lesson 18 Exam

Lesson 19: Advanced Formatting for Reports

Advanced Formatting for Reports 3 Total Points

Lesson 19 Video
Assessment: Lesson 19 Exam

Lesson 20: Printing and Exporting Reports

There are many new ways to print and export reports in Access 2013. In this lesson, we will both introduce and show you how to do them. 6 Total Points

Lesson 20 Video
Assessment: Lesson 20 Exam

Lesson 21: Importing and Exporting Data

In this lesson, we're going to learn the multiple ways that you can import and export data to and from Access. 4 Total Points

Lesson 21 Video
Assessment: Lesson 21 Exam

Lesson 22: Overview of New Features in Access 2016

Review of new features in Access 2016. 83 Total Points

Lesson 22 Video
Lesson discussions: What do you think about this course?; Program Evaluation Follow-up Survey (End of Course)
Assessment: The Final Exam

181

Total Course Points

Learning Outcomes

By successfully completing this course, students will be able to:

Identify what MS Access is and what its capabilities are.
Summarize databases and design.
Describe database objects.
Demonstrate creating a database and adding tables.
Summarize object views.
Summarize how to create simple forms.
Describe controls and formatting forms.
Describe queries.
Describe using criteria, operators, and wildcards.
Summarize parameter queries.
Describe relationships.
Describe normalization.
Describe creating calculated expressions.
Describe summarizing data and reports.
Describe printing and exporting reports.
Summarize importing and exporting data.
Demonstrate mastery of lesson content at levels of 70% or higher.

Additional Course Information

Document Your Lifelong Learning Achievements
Earn an Official Certificate Documenting Course Hours and CEUs
Verify Your Certificate with a Unique Serial Number Online

View and Share Your Certificate Online or Download/Print as PDF
Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media

Course Title: Microsoft Access 2016

Course Number: 9770431

Lessons Rating: 4.4 / 5 Stars (2,089 votes)

Languages: English - United States, Canada and other English speaking countries

Category:

UniversalClass.com > Computers & Technology > Microsoft Office Courses

Availability: This course is online and available in all 50 states including: California, Florida, Georgia, Illinois, New York, Pennsylvania, Ohio, Texas, and Washington.

Last Updated: July 2023

Course Type: Self-Paced, Online Class

CEU Value: 1.2 IACET CEUs (Continuing Education Units)

CE Accreditation: Universal Class, Inc. has been accredited as an Authorized Provider by the International Association for Continuing Education and Training (IACET).

Grading Policy: Earn a final grade of 70% or higher to receive an online/downloadable CEU Certification documenting CEUs earned.

Assessment Method: Lesson assignments and review exams

Instructor: UniversalClass Instructional Team

Syllabus: View Syllabus

Course Fee: $120.00 U.S. dollars