Online Class: Microsoft Access 2019
-
22Lessons
-
23Exams &
Assignments -
1,430Students
have taken this course -
8Hours
average time -
0.8CEUs
-
Video Audit
Available
Course Description
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.
Course Lessons
Lesson 1: Intro to Microsoft Access 2019
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 2: Understanding MS Access 2019 Requirements
This lesson discusses the limits and requirements for running and operating MS Access 2019.Lesson 3: What is a Database?
In this lessons we'll cover what exactly is a database, how it is setup, and why you should use a database.Lesson 4: What are Database Objects?
Database objects are components that save and query information. A database contains objects that are used to store and display large, relational data.Lesson 5: How to Navigate MS Access 2019
This lesson covers how to navigate Access 2019 interface and menus.Lesson 6: Creating Your First Database in Access 2019
In this lesson, we cover how to create and save your first database as well as how to add tables.Lesson 7: Using Object Views in Access 2019
Object views are simply different ways of viewing the object that you're working on.Lesson 8: Using Forms in Access 2019
A form is an Access database object that's used to create an interface for a database application.Lesson 9: Introduction to Controls and Formatting Forms
This lesson covers forms and controls including using bound, unbounded, and calculated controls.Lesson 10: Queries
In this lesson, we're going to go more in depth and talk about queries.Lesson 11: Using Criteria, Operators, and Wildcards
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 12: Understanding Parameter Queries
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 13: MS Access Creating and Using Relationships
When you define a relationship in Access, you relate data from one table to another.Lesson 14: What is Normalization?
Normalization refers to the process of organizing data in your database efficiently.Lesson 15: Calculated Expressions
Expressions in Access 2019 are used to do mathematical calculations, combine or extract text, or validate the data in your database.Lesson 16: Summarizing Data Using Aggregate Queries
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
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: Designing and Customizing Your Report
This lesson will discuss ways to design and customize your report in Access 2019.Lesson 19: Advanced Formatting for Reports
This lesson will focus on more ways to format your report such as using Group and Sort.Lesson 20: Printing and Exporting Reports in Access 2019
Printing and Exporting Reports in Access 2019 may take a few extra steps, but it is well worth it.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.Lesson 22: Overview of New Features in Access 2019
In this lesson, we're going to look at the new features that have been introduced as part of Access 2019.
Learning Outcomes
- 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
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
- 6 hours 0.6 CEUs Computer Literacy Level 2 - Internet Basics + More Info
- 7 hours 0.7 CEUs Microsoft Excel Level 3 + More Info
- 5 hours 0.5 CEUs Microsoft Outlook Level 1 + More Info
- 6 hours 0.6 CEUs Debt Reduction + More Info
- 6 hours 0.6 CEUs Microsoft Publisher Level 1 + More Info
- 4 hours 0.4 CEUs Slack + More Info
- 6 hours 0.6 CEUs Google Docs + More Info
- 14 hours 1.4 CEUs QuickBooks Online + More Info
- 7 hours 0.7 CEUs Microsoft Visio Level 1 + More Info
- 8 hours 0.8 CEUs Learn HTML - Create Webpages Using HTML5 + More Info
- 8 hours 0.8 CEUs Microsoft Access Level 1 + More Info
- 32 hours 3.2 CEUs Accounting & Bookkeeping 101 for Everyone + More Info
- 7 hours 0.7 CEUs Financial Analysis 101: Planning and Control + More Info
- 7 hours 0.7 CEUs Understanding Financial Statements + More Info
- 7 hours 0.7 CEUs Google Sheets + More Info
- 8 hours 0.8 CEUs Quicken Tutorial: All Versions + More Info
- 7 hours 0.7 CEUs Google Slides + More Info
- 6 hours 0.6 CEUs Computer Literacy Level 3 - Living and Working Online + More Info
- 6 hours 0.6 CEUs Cybersecurity 101 + More Info
- 9 hours 0.9 CEUs Microsoft Project Level 1 + More Info
- 8 hours 0.8 CEUs Microsoft PowerPoint Level 1 + More Info
- 7 hours 0.7 CEUs Introduction to Logic + More Info
- 7 hours 0.7 CEUs Computer Literacy Level 1 - Computer Basics + More Info
- 5 hours 0.5 CEUs Habits of Millionaires + More Info
- 7 hours 0.7 CEUs Microsoft Excel Level 2 + More Info