Microsoft Access 2019

$65.00
no certificate
no certificate
- OR -
$90.00
with CEU Certificate*
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
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.
- Know 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, and
- Demonstrate mastery of lesson content at levels of 70% or higher.
Assessment Guide
Assessment | Points |
---|---|
Lesson 1 Exam | 3 |
Lesson 2 Exam | 3 |
Lesson 3 Exam | 5 |
Lesson 4 Exam | 5 |
Lesson 5 Exam | 4 |
Lesson 6 Exam | 5 |
Lesson 7 Exam | 5 |
Lesson 8 Exam | 5 |
Lesson 9 Exam | 5 |
Lesson 10 Exam | 8 |
Lesson 11 Exam | 5 |
Lesson 12 Exam | 3 |
Lesson 13 Exam | 5 |
Lesson 14 Exam | 5 |
Lesson 15 Exam | 5 |
Lesson 16 Exam | 3 |
Lesson 17 Exam | 4 |
Lesson 18 Exam | 5 |
Lesson 19 Exam | 3 |
Lesson 20 Exam | 6 |
Lesson 21 Exam | 4 |
The Final Exam | 80 |
Total Points: | 176 |
Related Articles
- The Most Useful And Overlooked Functions in Excel 2019
- Understanding Accounting Revenue Tracking Procedures: Inventory, Costs of Goods, FIFO and LIFO
- Adaptations Required with the Development of Social Networks
- Understanding HTML5 and Web Design
- Introduction to VBA and Microsoft Word 2019
- How to Read Email Headers in Outlook 2019
- Social Media Obstacles to Avoid for More Effective Marketing
- The Law of Accounting: The Balance Sheet
- Adding Transitions and Animation to PowerPoint 2019 Presentations
- Marketing Strategies that Effective Use of Pinterest Provides