This comprehensive bundle combines Access 2021 Beginners (Part 1) and Access 2021 Advanced (Part 2), offering a complete path to mastering Microsoft Access. Starting with relational database fundamentals, you’ll learn how to download, install, and navigate Access 2021 while working with ribbons, commands, and shortcuts. You’ll build strong foundations in creating tables, managing field properties, setting index fields, and applying primary keys. As you progress, you’ll improve data accuracy using lookup menus and validation rules, import and organize data, and establish relationships for meaningful insights. The course also covers designing user-friendly forms and sub-forms, building navigation interfaces, and creating queries ranging from simple filters to complex expressions and calculations. Advanced modules focus on linking tables across databases, managing multi-user environments, automating workflows with macros and VBA, and writing SQL statements for precise control. By the end, you’ll have the skills to design, manage, and optimize databases efficiently with Access 2021.
Who should take this Course?
This course is ideal for beginners who want to get started with Microsoft Access as well as intermediate users aiming to refine and advance their skills. Business professionals, data analysts, and office administrators will benefit from learning to build, manage, and automate relational databases. It’s also suitable for students, freelancers, and IT professionals seeking practical database management skills to handle real-world projects with Access 2021.
What you will learn
Download, install, and navigate the interface of Access 2021
Create tables and fields for organized data structure
Understand index fields and primary keys for data integrity
Craft lookup menus for enhanced data interaction
Import data from Excel and text files, enriching your dataset
Write, edit, debug, and run VBA code along with building advanced queries
Course Outline
Introduction to the Beginner's Course
Introduction to Access 2021
Acquiring Access 2021
What's New in Access 2021?
Exercise 01
Get Started with Access 2021
Use Database Templates
Create, Save, and Open Databases
Explore the Access Interface and Backstage
Customize the Quick Access Toolbar
Access Menus
Keyboard Shortcuts and Key Tips
Online Help
Access Options
Exercise 02
Work with Tables
Create a Table and Fields
Index Fields, Primary Keys, and Add Records
Use the Lookup Wizard to Create a Drop-Down List
Numeric Fields and Data Validation Rules
Add More Table Fields
Exercise 03
Import Data
Importing Data from Excel
Importing Data from a Text File
Exercise 04
Datasheet View
Design in the Datasheet View
Sort and Filter in Datasheet View
Enter and Modify Data in Datasheet View
Exercise 05
Create Relationships
Relationships Explained
Set Up Relationships
Create a Link Table: Part 1
Create a Link Table: Part 2
Edit the Link Table
Exercise 06
Forms
Create a Form: Form Wizard
Form Properties
Modify a Form: Single Form Versus Continuous View
Forms in Layout View
Forms in Design View
Exercise 07
Subforms
Setting Up Subforms: Part 1
Setting Up Subforms: Part 2
Exercise 08
Queries
Create a Query
INNER, RIGHT, and LEFT Joins
Run Queries and Aggregate Numeric Data Using Query Wizard
Exercise 09
Validations and Expressions
Set Up More Validations and Expressions
Basic Calculations Using Expressions
Exercise 10
Reports
Run a Basic Report
Custom Report Design
Complex Reports
Exercise 11
More Data Types
Other Data Types: Yes/No
Other Data Types: Attachments
Exercise 12
More About Forms
Form Controls: Option Buttons
Form Themes and Design
Navigation Forms
Exercise 13
Share an Access Database
Export Parts of an Access Database
Database Properties and Encryption
Exercise 14
Additional Access Features
Compact and Repair
Printing and Database Documenter
Exercise 15
Beginner Course
Course
Introduction to the Advanced Course
Course Introduction
Set Up for Success in Access 2021
Primary Keys and Indexes
Primary Keys and Indexing Rules and Guidelines
More About Indexes
Using Datasheet View
Set Up the Northwind Database
Work in a Datasheet View
Customize Datasheet View
Advanced Sorting and Filtering in Datasheet View
Subdatasheets
Exercise 01
Linking to Other Access Databases
Linking Two Tables to Other Access Databases
Using ODBC and SQL Servers
Install SQL Server Express
Set Up SQL Server Express
Exercise 02
Splitting an Access Database
Splitting an Access Database into Frontend and Backend
Convert to Local Table
Addressing Multi-User Issues When Sharing Data
Exercise 03
Macros
Basics of Macros
Macro on Events; AutoExec
More About AutoExec
Macro Security Settings
Exercise 04
The Ribbon
Customize the Quick Access Toolbar and Tabs
Visual Basic for Applications
Convert Macros to VBA
Run VBA Code and Error Handling
Create Modules: Subs, Functions, Intellisense, and Variables
Scope, Variable Naming, and Strings
Standard Functions: Logical, Case, and Loops
Access Events Model
Adding Events to Assets Database
Exercise 05
Common Events: Form and Report Events
Switchboard, Navigation Forms, and Error Handling
Exercise 06
Forms
Formatting Bound and Control Forms
Split Forms and Macro Error Handling
Creating Form with Tab
Go to Combo Box and Its Properties
Exercise 07
Advanced Use of Queries
Basics of Queries
Syntax of SQL Statements
Use of Multiple Where Criteria and Select Statements Function
