Online Class: Microsoft Access 2019

Learn MS Access 2019 completely online with step-by-step directions, HD video, and classroom exercises.
$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.
 
  • 24
    Lessons
  • 23
    Exams &
    Assignments
  • 1,430
    Students
    have taken this course
  • 8
    Hours
    average time
  • 0.8
    CEUs
 
 
 

Course Description

The purpose of this course is to teach you the important features of Access 2019 and how to use them.  This course was designed for beginners so that even if you've never so much as opened the program before, you can learn how to use it. Once we cover the basics, we'll move on to advanced features. If you've used Access before, perhaps prior 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.
It's highly recommended that you install Access 2019 on your computer. You can purchase Microsoft Office to get all of the Office applications, or subscribe to Office 365 to pay a monthly subscription for the software.

What is Microsoft Access 2019?

Unless you've used Microsoft Access before, you may be unclear as to what exactly it is and how you'll use it.  Microsoft Excel, PowerPoint, and Word are very popular programs, so we're very familiar with them, if only by name. Access, however, isn't as widely used or discussed, so before we begin this course, it's important to look at what this software program does, and how it will help you.

Microsoft Access is an information management tool that allows you to store, report, and analyze information. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you.

You see, a spreadsheet program such as Excel is great if you want to maintain and calculate small bits of information. It's easy enough to use when you want to create a spreadsheet, enter data, create formulas, etc.

Excel makes it very easy to sort, filter, and format quickly. That said, though, Excel is not ideal for handling hundreds of records if you have one thing you need to track. It's easy to have errors, and that makes analysis, summing, and reporting difficult.

Microsoft Access is the answer to that problem. Think of it as Excel's big sister. She handles everything that Excel might have a tough time doing.
Courses Frequently Bought Together:
  • 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:
4.4 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(737 votes)

Lesson 1: Intro to Microsoft Access 2019

4 Points
Microsoft Access is an information management tool that allows you to store, report, and analyze information. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you.
  • Lesson 1 Video
  • Lesson discussions: Access 2016; Reasons for Taking this Course
  • Complete Assignment: An Introduction
  • Assessment: Lesson 1 Exam

Lesson 2: Understanding MS Access 2019 Requirements

3 Points
This lesson discusses the limits and requirements for running and operating MS Access 2019.
  • Lesson 2 Video
  • Assessment: Lesson 2 Exam

Lesson 3: What is a Database?

5 Points
In this lessons we'll cover what exactly is a database, how it is setup, and why you should use a database.
  • Lesson 3 Video
  • Assessment: Lesson 3 Exam

Lesson 4: What are Database Objects?

5 Points
Database objects are components that save and query information. A database contains objects that are used to store and display large, relational data.
  • Lesson 4 Video
  • Assessment: Lesson 4 Exam

Lesson 5: How to Navigate MS Access 2019

4 Points
This lesson covers how to navigate Access 2019 interface and menus.
  • Lesson 5 Video
  • Assessment: Lesson 5 Exam

Lesson 6: Creating Your First Database in Access 2019

5 Points
In this lesson, we cover how to create and save your first database as well as how to add tables.
  • Lesson 6 Video
  • Assessment: Lesson 6 Exam

Lesson 7: Using Object Views in Access 2019

5 Points
Object views are simply different ways of viewing the object that you're working on.
  • Lesson 7 Video
  • Assessment: Lesson 7 Exam

Lesson 8: Using Forms in Access 2019

5 Points
A form is an Access database object that's used to create an interface for a database application.
  • Lesson 8 Video
  • Assessment: Lesson 8 Exam

Lesson 9: Introduction to Controls and Formatting Forms

5 Points
This lesson covers forms and controls including using bound, unbounded, and calculated controls.
  • Lesson 9 Video
  • Assessment: Lesson 9 Exam

Lesson 10: Queries

8 Points
In this lesson, we're going to go more in depth and talk about queries.
  • Lesson 10 Video
  • Assessment: Lesson 10 Exam

Lesson 11: Using Criteria, Operators, and Wildcards

5 Points
You can limit the results of a query to values that are in a field. This is accomplished by using query criteria. Query criteria are expressions that Access will compare to the values in your query fields to decide whether or not to include the records that contain values.
  • Lesson 11 Video
  • Assessment: Lesson 11 Exam

Lesson 12: Understanding Parameter Queries

3 Points
Whenever you want a query to ask for input each time you run the query, you create what's called a parameter query in Access 2019.
  • Lesson 12 Video
  • Assessment: Lesson 12 Exam

Lesson 13: MS Access Creating and Using Relationships

5 Points
When you define a relationship in Access, you relate data from one table to another.
  • Lesson 13 Video
  • Assessment: Lesson 13 Exam

Lesson 14: What is Normalization?

5 Points
Normalization refers to the process of organizing data in your database efficiently.
  • Lesson 14 Video
  • Assessment: Lesson 14 Exam

Lesson 15: Calculated Expressions

5 Points
Expressions in Access 2019 are used to do mathematical calculations, combine or extract text, or validate the data in your database.
  • Lesson 15 Video
  • Assessment: Lesson 15 Exam

Lesson 16: Summarizing Data Using Aggregate Queries

3 Points
An aggregate query lets you determine statistics for a set of values. For example, you can determine the sum, average, and count. An aggregate query is also known as a Summary Query or a Totals Query.
  • Lesson 16 Video
  • Assessment: Lesson 16 Exam

Lesson 16: Summarizing Data Using Aggregate Queries

0 Points
An aggregate query lets you determine statistics for a set of values. For example, you can determine the sum, average, and count. An aggregate query is also known as a Summary Query or a Totals Query.

Lesson 17: Creating Reports in Access 2019

4 Points
Access 2019 gives you the ability to run reports to view your data. The Report Tool is the quickest way for you to run those reports because you don't have to enter any information.
  • Lesson 18 Video
  • Assessment: Lesson 17 Exam

Lesson 18: Designing and Customizing Your Report

5 Points
This lesson will discuss ways to design and customize your report in Access 2019.
  • Lesson 19 Video
  • Assessment: Lesson 18 Exam

Lesson 19: Advanced Formatting for Reports

3 Points
This lesson will focus on more ways to format your report such as using Group and Sort.
  • Lesson 20 Video
  • Assessment: Lesson 19 Exam

Lesson 20: Printing and Exporting Reports in Access 2019

6 Points
Printing and Exporting Reports in Access 2019 may take a few extra steps, but it is well worth it.
  • Lesson 21 Video
  • Assessment: Lesson 20 Exam

Lesson 21: Importing and Exporting Data

4 Points
In this lesson, we're going to learn the multiple ways that you can import and export data to and from Access.
  • Lesson 22 Video
  • Assessment: Lesson 21 Exam

Lesson 21: Importing and Exporting Data

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

Lesson 22: Overview of New Features in Access 2019

80 Points
In this lesson, we're going to look at the new features that have been introduced as part of Access 2019.
  • Lesson 24 Video
  • Lesson discussions: What do you think about this course?; Program Evaluation Follow-up Survey (End of Course); Course Comments
  • Assessment: The Final Exam
177
Total Course Points
 

Learning Outcomes

By successfully completing this course, students will be able to:
  • Describe what a database is how it differs from a spreadsheet and what the capabilities of MS Access are.
  • Describe what database objects are.
  • Demonstrate navigating the MS Access interface.
  • Demonstrate creating your first database.
  • Demonstrate using object views in Access.
  • Demonstrate using forms.
  • Summarize controls and formatting forms.
  • Describe what queries are and why they are important.
  • Describe using criteria, operators, and wildcards.
  • Describe parameter queries.
  • Describe creating and using relationships.
  • Define normalization.
  • Define calculated expressions.
  • Describe summarizing data using aggregate queries.
  • Demonstrate designing and customizing your report.
  • Describe methods for importing and exporting data in your database.
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 

Additional Course Information

Online CEU Certificate
  • 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
Document Your CEUs on Your Resume
 
Course Title: Microsoft Access 2019
Course Number: 9770519
Lessons Rating: 4.4 / 5 Stars (737 votes)
Languages: English - United States, Canada and other English speaking countries
Availability: This course is offered online and is accessible in every state across the U.S., including California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. Learners in English-speaking countries like Canada, Australia, the United Kingdom, and South Africa can also enroll.
Last Updated: March 2024
Course Type: Self-Paced, Online Class
CEU Value: 0.8 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
Syllabus: View Syllabus
Course Fee: $120.00 U.S. dollars

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
$95
for 6 months
 
Add to Cart
Billed once
This course only
Includes certificate X
Includes CEUs X
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Certificate Course
One Course
Certificate & CEUs
$120
for 6 months
 
Add to Cart
Billed once
This course only
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Platinum Yearly
ALL COURSES
Certificates & CEUs
$189
per year
 
Start Now
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 600+
Platinum 2 Years
ALL COURSES
Certificates & CEUs
$299
for 2 years
You save $79.00!
Start Now
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 24 Months
No. of courses 600+
 

Student Testimonials

  • "This course was VERY helpful in giving someone with no previous experience in Access a thorough understanding of how the program works and how to use it!" -- Lawerence R.
  • "My instructor responded quickly to my questions, which was helpful." -- Daniel O.

Related Courses