Access 2019 Beginner
Beginner
4h
By: Andy Altaner
Overview
This course is an introduction to Microsoft Access 2019. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create databases, create objects, perform calculations, navigate and work with tables, understand and work with queries, review and work with various reports and reporting features, and review forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2019 Intermediate course.
Modules
1. Introduction
1.1 Access 2019 Beginner Introduction1 min
2. Getting Started with Access
2.1 What is a Database3 min
2.2 Understanding Database Terminology4 min
2.3 Navigating the Access Interface9 min
2.4 What is a Flat File Database3 min
2.5 What is a Relational Database10 min
2.6 Relating Tables8 min
2.7 Reviewing the Access Ribbon2 min
3. Working with Data
3.1 Working with Tables7 min
3.2 Navigating Tables3 min
3.3 Editing Data3 min
3.4 Adding New Records3 min
3.5 Using Subdatasheets4 min
4. Creating Databases and Objects
4.1 Understanding Database and Table Design Principles9 min
4.2 Using Table Data Sheet View4 min
4.3 Working with Field Data Types7 min
4.4 Using Table Design View4 min
4.5 Using Calculated Fields8 min
4.6 Calculating Dates4 min
4.7 Calculating Strings4 min
4.8 Using the Lookup Wizard11 min
4.9 Lookup Wizard Linking Tables6 min
4.10 Using Indexes5 min
5. Working with Queries
5.1 What are Queries6 min
5.2 Creating Simple Queries5 min
5.3 Understanding the Dynaset3 min
5.4 Entering Criteria-Exact Match and Ranger Operators6 min
5.5 Understanding And Vs Or6 min
5.6 Using Wild Cards4 min
5.7 Using Key Words4 min
5.8 Sorting and Hiding Fields3 min
5.9 Creating Multi-Table Queries3 min
5.10 Creating a Calculated Field in a Query5 min
5.11 Additional Tips5 min
6. Working with Reports
6.1 What are Reports4 min
6.2 Understanding Report Types3 min
6.3 Building Good Reports2 min
6.4 Using Autoreport6 min
6.5 The Report Wizard12 min
6.6 Using the Report Design View7 min
6.7 Printing Reports4 min
6.8 Creating Labels5 min
6.9 Additional Tips9 min
7. Working with Forms
7.1 What are Forms3 min
7.2 Understanding Form Types3 min
7.3 Creating Forms2 min
7.4 Navigating Forms2 min
7.5 Editing Data in Forms5 min
7.6 Understanding The Form Wizard5 min
7.7 Using The Form Design View4 min
7.8 Working with Controls7 min
7.9 Using The Form Layout View3 min
7.10 Additional Tips7 min
8. Conclusion
8.1 Access 2019 Beginner Recap1 min
Ready to Elevate Your Team's Learning?
Talk with our sales team to see how StormWind can transform the way your organization trains and grows.
CONTACT SALES