Access 2021 Full Course - Beginner To Advanced

Take your Access skills to the next level with creating databases, queries, and database security!

What you'll learn

Introduction into How Databases Operate

Creating A New Database

Create Reports for Data Output

How Table Relationships Affect Queries

Calculating Data with Queries

Advanced Report Design Techniques

Advanced Form Design Techniques

Introduction into Access Visual Basic for Complex Automation

Customizing Database Options

Requirements

None

Description

Who it's for: Beginners or experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Access. What it is: Access is Microsoft’s relational database application used to organize and store data. Access also has reporting capabilities.What you'll learn: We start with navigating a completed database while exploring the concept of relational databases and the objects they contain. We’ll move on to learning the Access interface, so you can become comfortable in the working environment. Then, we dive into how to plan, design, and create database tables. We’ll continue by importing table data from Excel, as well as manually entering table data. Sorting and filtering techniques will be explored before we move on to exploring table relationships, the key to a successful relational database. We will create database queries, forms, and reports. We’ll spend time on learning how table relationships affect queries, how to automate queries, and how to create action queries. Our advanced training starts with Advanced Report and Form Design techniques. We will learn how to create switchboards, write macros, and use Access Visual Basic for Applications (VBA) for complex automation. We will end by covering database security and customization options. Learn it all in this all inclusive Access class.

Overview

Section 1: Exercise Files - Download Before Starting the Course

Lecture 1 Exercise Files

Section 2: Access 2021 Beginner

Lecture 2 Introduction

Lecture 3 Introduction to Database Objects and the Access Interface

Lecture 4 Introduction to Database Objects and the Access Interface

Lecture 5 Accessing the Northwind Template

Lecture 6 Exploring the Login and Homes Forms

Lecture 7 Navigation Pane Default View and Datasheet and Design Views for Tables

Lecture 8 Exploring Datasheet View, Design View, and SQL View for Query Objects

Lecture 9 Exploring Form View, Layout View, and Design View for Form Objects

Lecture 10 Exploring Report View, Layout View, Design View, and Print Preview for Report

Lecture 11 Running Macros and Exploring Design View

Lecture 12 Examining VBA Code

Lecture 13 Access Ribbon and Status Bar

Lecture 14 Exploring the Relationships Window and Closing the Database

Lecture 15 Introduction to Creating New Databases

Lecture 16 Creating Blank Databases

Lecture 17 Switching Default Table to Design View and Renaming the Primary Key Field

Lecture 18 Adding Remaining Fields to the Customers Table

Lecture 19 Field Descriptions, Format and Text Limit, and Input Mask

Lecture 20 Using the Caption Field Property

Lecture 21 Creating New Tables in Design View

Lecture 22 Introduction to Entering Data into Tables

Lecture 23 Manually Entering Table Data

Lecture 24 Importing from Excel - Appending to Existing Table - Employees

Lecture 25 Importing from Excel - Appending with Different Data Types Error - Customers

Lecture 26 Importing from Excel - Adding Data into A New Table - Categories

Lecture 27 Importing from Excel - Adding Data into New Tables

Lecture 28 Reviewing Data Types and Field Properties for Imported Tables - Products

Lecture 29 Reviewing Data Types and Field Properties for Imported Tables - Orders

Lecture 30 Order Details Table - Discussing Composite Key Fields

Lecture 31 Setting a Composite Key - Order Details

Lecture 32 Sorting Table Data

Lecture 33 Inclusive Filtering, Exclusive Filtering, and Filtering by Form

Lecture 34 Introduction to Relationships

Lecture 35 Adding Tables to the Relationships Window and Organizing Them

Lecture 36 Common Fields Between Tables

Lecture 37 Creating a One-To-Many Relationship Between Customers and Employees Tables

Lecture 38 Creating Relationship Errors

Lecture 39 Resolving Data Type Errors and Repopulating Table Fields

Lecture 40 Manually Repopulating Table Fields

Lecture 41 Creating Lookup Fields in a Table

Lecture 42 Changing the Field Size of a Numeric Data Type to Resolve a Relationship Error

Lecture 43 Resolving a Data Type Error and Repopulating Table Fields

Lecture 44 Creating a Lookup Field in Another Table and the Many-to-Many Relationship

Lecture 45 Database Basics Recap

Lecture 46 Conclusion

Section 3: Access 2021 Intermediate

Lecture 47 Introduction

Lecture 48 Introduction to Queries, Forms, and Reports

Lecture 49 Fixing Minor Table Issues

Lecture 50 Creating Two Queries Using the Simple Query Wizard

Lecture 51 Creating Queries from Scratch in Design View

Lecture 52 Customizing Queries with Criteria and Criteria Wildcards

Lecture 53 Viewing Expanded Table Data

Lecture 54 Creating Customer Forms Using the Form Wizard

Lecture 55 Creating Employee Forms Using the Form Wizard

Lecture 56 Creating Forms in Form Design View

Lecture 57 Creating Forms by Using Save As on a Table Object

Lecture 58 Using Forms for Data Entry

Lecture 59 Entering Customer Records

Lecture 60 Creating Reports by Using Save As on a Query

Lecture 61 Creating Reports from Scratch in Design View and Adding a Logo

Lecture 62 Queries, Forms, and Reports Recap

Lecture 63 Introduction to Query Reports and Complex Queries

Lecture 64 Creating Queries Using Multiple Tables with an Inner Join

Lecture 65 Changing Queries to a Left Outer Join

Lecture 66 Using And Or Conditions in Criteria and Multiple Criteria

Lecture 67 Using the Like Keyword for a Range of Characters

Lecture 68 Creating Custom Fields with Calculations in a Query

Lecture 69 Adding Another Table Fields to an Existing Query and Creating a Calculated Field

Lecture 70 Creating and Formatting Another Calculated Field

Lecture 71 Summarizing Query Results with Grouping

Lecture 72 Query Reports and Complex Queries

Lecture 73 Introduction to Automation, Wizards, and Advanced Reports

Lecture 74 Creating Automated Requests for Criteria

Lecture 75 Using Wildcards in a Parameter Query

Lecture 76 Using Range Operators in Parameter Queries

Lecture 77 Crosstab Query Wizard

Lecture 78 Find Unmatched Query Wizard

Lecture 79 Find Duplicates Query Wizard

Lecture 80 Introduction to Action Queries

Lecture 81 Make-Table Action Query

Lecture 82 Append Action Query

Lecture 83 Update Action Query

Lecture 84 Delete Action Query

Lecture 85 Advanced Report Design Techniques

Lecture 86 Report Design View

Lecture 87 Automation, Wizards, and Advanced Reports Recap

Lecture 88 Conclusion

Section 4: Access 2021 Advanced

Lecture 89 Introduction

Lecture 90 Introduction to Advanced Forms and Automation

Lecture 91 Creating Main Forms and Subforms

Lecture 92 Using Subform Control to Connect Sub and Main Forms

Lecture 93 Creating Tabbed Forms and Populating Pages

Lecture 94 Populating, Aligning, and Spacing Fields and Testing Tabbed Forms

Lecture 95 Renaming Page Tabs and Adding Form Headers to Tabbed Forms

Lecture 96 Creating Split Forms

Lecture 97 Adding Default Values to Form Fields for Data Entry

Lecture 98 Adjusting the Tab Order on a Form

Lecture 99 Adding Command Buttons to Forms for Navigation

Lecture 100 Adding Switchboard Managers to the QAT

Lecture 101 Adding Items to Switchboards

Lecture 102 Introduction to Designing Macros to Automate Database Tasks

Lecture 103 Creating and Testing AutoExec Macros

Lecture 104 Using Message Boxes to Inform Users

Lecture 105 Automating Parameter Queries with Macros

Lecture 106 Viewing Related Records in a Form with Macros

Lecture 107 Hiding and Unhiding Field Controls with Macros

Lecture 108 Testing the Previous Macro

Lecture 109 Using Macros to Validate Data Entry

Lecture 110 Introduction to Access Visual Basic for Complex Automation

Lecture 111 Using VBA to Secure a Form with a Password

Lecture 112 Creating User Input Boxes with VBA

Lecture 113 Using Logic Programming to Interpret One or Multiple Conditions

Lecture 114 Advanced Forms and Automation Recap

Lecture 115 Introduction to Database Security and Options

Lecture 116 Splitting Databases for Table Security

Lecture 117 Examining Back-End Databases

Lecture 118 Moving Back-End Databases and Using Linked Table Manager to Point to a New Path

Lecture 119 Customizing Database Options

Lecture 120 Applying the Compact and Repair Tool

Lecture 121 Generating Database and Relationship Reports

Lecture 122 Database Security and Options Recap

Lecture 123 Conclusion

IT professionals, data analysts, database users and coordinators, managers and directors, and anyone who uses Access!