Access 365 Beginner
Beginner
5h
By: Andy Altaner
Overview
This course is an introduction to Microsoft Access 365. 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 365 Intermediate course.
Modules
1. Introduction
1.1 Access 365 Beginner Introduction2 min
2. Getting Started with Access
2.1 What is a Database3 min
2.2 Database Terminology5 min
2.3 The Access Interface8 min
2.4 What is a Flat File Database3 min
2.5 What is a Relational Database10 min
2.6 Relating Tables10 min
2.7 Reviewing the Access Ribbon2 min
3. Working with Data
3.1 Working with Tables7 min
3.2 Navigating Tables4 min
3.3 Editing Data3 min
3.4 Adding New Records5 min
3.5 Using Subdatasheets4 min
4. Creating Databases and Objects
4.1 Understanding Database and Table Design Principles8 min
4.2 Using Table Data Sheet View3 min
4.3 Working with Field Data Types7 min
4.4 Using Table Design View4 min
4.5 Using Calculated Fields4 min
4.6 Calculating Numbers5 min
4.7 Calculating Dates2 min
4.8 Calculating Strings3 min
4.9 Using the Lookup Wizard12 min
4.10 Lookup Wizard Linking Tables9 min
4.11 Using Indexes4 min
5. Working with Queries
5.1 What are Queries8 min
5.2 Creating Simple Queries5 min
5.3 Understanding the Dynaset2 min
5.4 Entering Criteria-Exact Match and Range Operators5 min
5.5 Understanding And Versus Or6 min
5.6 Using Wild Cards5 min
5.7 Using Key Words4 min
5.8 Sorting and Hiding Fields3 min
5.9 Creating Multi-Table Queries3 min
5.10 Additional Tips6 min
6. Working with Reports
6.1 What are Reports5 min
6.2 Understanding Report Types3 min
6.3 Building Good Reports2 min
6.4 Using AutoReport8 min
6.5 Understanding The Report Wizard11 min
6.6 Using the Report Design View8 min
6.7 Printing Reports4 min
6.8 Creating labels8 min
6.9 Additional Tips10 min
7. Working with Forms
7.1 What are Forms4 min
7.2 Understanding Form Types3 min
7.3 Creating Forms3 min
7.4 Navigating Forms3 min
7.5 Editing Data in Forms5 min
7.6 Understanding the Form Wizard5 min
7.7 Using Form Design View4 min
7.8 Working with Controls10 min
7.9 Using Form Layout View4 min
7.10 Additional Tips7 min
7.11 Getting Help3 min
8. Conclusion
8.1 Access 365 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