Online Class: Microsoft Access 2019

Name: Microsoft Access 2019
Price: 95.00 USD

Designed for beginners, this course covers Access 2019's fundamental and advanced tools, highlighting its advantages over Excel for handling extensive data. Those experienced with Access will find value in exploring new features and updates.

$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:

Microsoft Office: Word, Excel, PowerPoint and Outlook

Microsoft Word Level 1

Microsoft Excel 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"

(737 votes)

Lesson 1. Journey into Database Mastery: Navigating Microsoft Access 2019

This course demystifies the database creation process in Access, breaking it down into essential components like tables, queries, and reports, thus easing the journey from novice to proficient user. By integrating automation through macros and promoting seamless interconnectivity with other Microsoft tools, Access redefines collaboration and workflow efficiency. 4 Total Points

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

Lesson 2. Access 2019 Setup and System Essentials

In a small business, Access 2019 aids in optimal customer, inventory, and sales management, fostering enhanced team collaboration. It supports multiple user access, underpinning critical decision-making processes with robust data interactions. 3 Total Points

Lesson 2 Video
Assessment: Lesson 2 Exam

Lesson 3. The Core Structure of Databases: Tables and Relationships Explored

Modern databases are integral to industries, facilitating data-driven decisions with AI and machine-learning integration. As ethical data usage becomes paramount, understanding databases prepares us for an interconnected future. 5 Total Points

Lesson 3 Video
Assessment: Lesson 3 Exam

Lesson 4. Database Objects in Access 2019: A Comprehensive Guide

MS Access 2019 serves as a gateway to transforming data management practices by providing foundational tools for data storage, interface design, strategic querying, and data presentation. The inclusion of macros enhances this utility, offering possibilities for consistent and efficient task automation necessary for advanced database operations. 5 Total Points

Lesson 4 Video
Assessment: Lesson 4 Exam

Lesson 5. Streamlining Your Workflow: MS Access Fundamentals Unveiled

Macros and VBA elevate MS Access by automating tasks and extending functionality beyond simple database operations. These advanced features allow users to automate workflows, saving time and fostering innovation in handling complex data-driven tasks with precision. 4 Total Points

Lesson 5 Video
Assessment: Lesson 5 Exam

Lesson 6. Harnessing Microsoft Access for Seamless Data Management

The journey from a blank Access database to a fully-functioning relational system fosters understanding of key concepts like table creation, data linkage, and integrity enforcement. This empowered learning allows users to manipulate large datasets accurately, aligning with real-world applications from libraries to cinemas. 5 Total Points

Lesson 6 Video
Assessment: Lesson 6 Exam

Lesson 7. A Deep Dive into Access Views for Database Mastery

Query Views, such as Design and SQL Views, allow precise data extraction and manipulation, equipping users with tools to sift through and analyze information effectively. Datasheet View enables users to review and validate query results similarly to spreadsheet analysis, confirming data hypotheses. 5 Total Points

Lesson 7 Video
Assessment: Lesson 7 Exam

Lesson 8. Mastering the Art of MS Access Forms

Advanced Access form features include custom controls, event handling, and calculated fields, which enrich form functionality and user efficiency. Designing complex forms with tabbed interfaces and thoughtful visual layouts further enhances user interaction and data clarity. 5 Total Points

Lesson 8 Video
Assessment: Lesson 8 Exam

Lesson 9. Database Controls Simplified

Harnessing the potential of controls within databases, like Access, turns data management into a strategic advantage, offering both precision in operation and creativity in design. From streamlining input orders to applying personalized themes, data handling becomes both efficient and engaging. 5 Total Points

Lesson 9 Video
Assessment: Lesson 9 Exam

Lesson 10. Unleashing the Power of Queries in Database Management

In the world of queries, MS Access 2019 transforms unwieldy datasets into insightful summaries, facilitating tasks from identifying duplicate entries to generating detailed sales reports. Queries empower users to transition from manual data trawl to informed decision-making, optimizing efficiency with precision. 8 Total Points

Lesson 10 Video
Assessment: Lesson 10 Exam

Lesson 11. Mastering the Art of Database Query Criteria

The lesson on query criteria reveals the potent capabilities of database filtering and logic application. Techniques ranging from simple matches to interval-based and wildcard searches refine the querying craft. 5 Total Points

Lesson 11 Video
Assessment: Lesson 11 Exam

Lesson 12. Dynamic Data Sorting with Parameter Queries in Access

Leveraging parameter queries in Access 2019 transforms daunting data sorting tasks into an intuitive experience by allowing users to input criteria each run. This tool enhances user engagement by efficiently prompting users for specific input, thus simplifying data retrieval. 3 Total Points

Lesson 12 Video
Assessment: Lesson 12 Exam

Lesson 13. Database Connections Simplified

Exploring joins in detail, learn how inner, outer, and cross joins offer unique methods for integrating data across tables, driving precise and comprehensive data analysis. This lesson illustrates the nuances of joins through real-world applications, empowering users to make informed decisions with enhanced data insights. 5 Total Points

Lesson 13 Video
Assessment: Lesson 13 Exam

Lesson 14. Streamlining Data Storage: The Art of Normalization

The essence of normalization lies in eliminating redundant data and ensuring logical data dependencies, optimizing database space and integrity. By adhering to structured guidelines known as normal forms, databases are organized efficiently, paving the way for smoother data management and updates. 5 Total Points

Lesson 14 Video
Assessment: Lesson 14 Exam

Lesson 15. Create Dynamic Data Tables with Calculated Fields

Mastering expressions in Access 2019 transforms databases into effective analytical tools by enabling accurate data manipulation, from calculations and text handling to data validation. Key elements like functions, identifiers, and operators streamline processes, turning routine interactions into strategic advantages. 5 Total Points

Lesson 15 Video
Assessment: Lesson 15 Exam

Lesson 16. Mastering Aggregate Queries for Data Insights

Using aggregate queries such as SUM, AVG, and COUNT, businesses can transform extensive datasets into succinct insights that guide strategic decisions and enhance operational understanding. These functionalities integrate seamlessly into platforms like Microsoft Access, supporting comprehensive data analysis across diverse sectors. 3 Total Points

Lesson 16 Video
Assessment: Lesson 16 Exam

Lesson 17. Data Aggregation: Unlocking Insights through Query Efficiency

Explore the realm of data summarization through aggregate queries which utilize essential functions like COUNT, SUM, and AVERAGE to extract critical insights. This lesson reveals how these queries simplify complex data analysis into comprehensible summaries for strategic purposes. 0 Total Points

Lesson 18. Harnessing the Power of Access 2019 for Report Generation

Efficient data visualization is vital in decision-making, and Access 2019 provides tools to generate both rapid and intricate reports. With the Report Tool offering immediate views and the customizable Report Wizard, users can craft narratives from complex datasets effortlessly. 4 Total Points

Lesson 18 Video
Assessment: Lesson 17 Exam

Lesson 19. Crafting Compelling Reports: Design and Customization

Lesson 18 explores the art of transforming raw data into a visually appealing and informative report, emphasizing the importance of narrative structure and design principles. From initial sketches to the final layout, each step integrates graphic design, writing, and user experience to ensure clarity and engagement. 5 Total Points

Lesson 19 Video
Assessment: Lesson 18 Exam

Lesson 20. Dynamic Data Insights for Impactful Storytelling

Data bars provide a visual summary, offering instant insight into numerical data comparisons within reports. They simplify understanding by transforming quantitative information into intuitive graphical representations, facilitating informed decision-making. 3 Total Points

Lesson 20 Video
Assessment: Lesson 19 Exam

Lesson 21. Access Report Mastery: From Screen to Paper

6 Total Points

Lesson 21 Video
Assessment: Lesson 20 Exam

Lesson 22. Effortless Data Movement: Import and Export Skills

Access 2019 simplifies data integration with versatile support for multiple file formats, paving the way for dynamic data organization and transformation. Harnessing these capabilities is crucial for any data-rich environment seeking streamlined data flow and actionable results. 4 Total Points

Lesson 22 Video
Assessment: Lesson 21 Exam

Lesson 23. Navigating the External Data Workflow

Microsoft Access 2019 empowers users by facilitating seamless data import and export, crucial for data management across diverse platforms. With features like the 'External Data' tab, Access simplifies integration processes, enhancing data manipulation and reporting capabilities significantly. 0 Total Points

Lesson 24. Access 2019: Unveiled Enhancements

Access 2019's Property Sheet Sorting feature enhances user experience by enabling efficient customization of forms and reports, saving time and streamlining workflows. Moreover, improved analytics and connectivity options allow users to link data from varied sources seamlessly, facilitating comprehensive data analyses and informed decision-making. 80 Total Points

Lesson 24 Video
Lesson discussions: What do you think about this course?; Program Evaluation Follow-up Survey (End of Course); Course Comments; 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

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 2019

Course Number: 9770519

Lessons Rating: 4.39 / 5 Stars (737 votes)

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

Category:

UniversalClass.com > Computers & Technology > Microsoft Office Certification Courses

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

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.

Course Type: Self-Paced, Online Classes

Assessment Method: Lesson assignments and review exams

Proctor: UniversalClass Instructional Team

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
Instructor support
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
Includes CEUs
Self-paced
Instructor support
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
Includes CEUs
Self-paced
Instructor support
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
Includes CEUs
Self-paced
Instructor support
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.