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.
What am I going to get from this course?
Basic familiarity and understanding of MS Access functions and components.
Prerequisites and Target Audience
What will students need to know or do before starting this course?
Basic computer skills. Knowledge of basic database concepts is helpful but not required.
Who should take this course? Who should not?
Anyone looking to increase Access knowledge and database program understanding.
Module 2: Getting Started with Access
What is a Database?
Understanding Database Terminology
Navigating the Access Interface
What is a Flat File Database?
What is a Relational Database?
Reviewing the Access Ribbon
Module 3: Working with Data
Working with Tables
Adding New Records
Module 4: Creating Databases and Objects
Understanding Database and Table Design Principles
Using Table Data Sheet View
Working with Field Data Types
Using Table Design View
Using Calculated Fields
Using the Lookup Wizard
Lookup Wizard Linking Tables
Module 5: Working with Queries
What are Queries?
Creating Simple Queries
Understanding the Dynaset
Entering Criteria: Exact Match and Range Operators
Understanding AND Versus OR
Using Wild Cards
Using Key Words
Sorting and Hiding Fields
Creating Multi-Table Queries
Creating a Calculated Field in a Query
Module 6: Working with Reports
What are Reports?
Understanding Report Types
Building Good Reports
Understanding the Report Wizard
Using the Report Design View
Module 7: Working with Forms
What are Forms?
Understanding Form Types
Editing Data in Forms
Understanding the Form Wizard
Using the Form Design View
Working with Controls
Using the Form Layout View
Module 9: Final Assessment Quiz - Access 2019 Beginner
Final Assessment Quiz - Access 2019 Beginner