Microsoft Access 2021 For Beginners: Master The Essentials

Unlock your database superstar potential with this comprehensive Microsoft Access 2021 beginner course!

What you'll learn

Explain what a relational database is and download and install Access 2021

Know the differences between Access 2019 and Access 2021 and locate, open, and save Access database templates

Open, close, and save a blank database file and navigate the Access interface, ribbons, and commands

Customize the quick access toolbar with frequently used commands and understand the different menu systems in Access

Use keyboard shortcuts to navigate and execute commands and access the help files

Customize Access options and create tables and fields

Modify field properties and understand index fields and primary keys

Create lookup menus and add data validation and data validation text to fields

Import data into a table from Excel and from a text file and use datasheet view to manage data

Sort and filter records in a table and create relationships between tables that share a common field

Create and design user-friendly forms and setup subforms

Build simple and complex queries to interrogate table data and create expressions to perform simple calculations

Create and run a basic report and a custom report

Use form controls to add checkboxes, attachments, and option buttons to forms

Protect a database file by adding encryption and password protection and prevent database issues using compact and repair

Export an Access database to other file formats and print tables, forms, and reports

Requirements

Microsoft Access 2021 downloaded and installed on your machine (ideal but not essential)

No prior experience needed, the course is for complete beginners.

Description

**This course includes downloadable instructor files and exercise files to work with and follow along.**Take control of your data and discover the power of Access 2021, the latest on-premises release from Microsoft and the newest addition to the Access family of applications. Microsoft Access 2021 is so much more than a way to create customizable desktop databases. It is fair to say that Access 2021 is a user-friendly tool that allows us to create business applications and templates from scratch without the need for high-level development skills.Access 2021 allows even the novice database builder to start creating tables, forms, queries, and reports quickly. It is a full life-cycle database management tool that makes creating small to large databases easy.In this course, we will explore the basic functionality of Access and get familiar with the terminology, the interface, and the commands. We’ll look at the available templates and build tables and populate them with data. We’ll create relationships between tables and build queries to interrogate the data. We’ll look at building nicely formatted forms so others can interact easily with our database and build custom reports to help us gain deeper insight.This course is for the absolute beginner or anyone who is looking to refresh their basic skills. It will provide a fantastic starting point from which to build more advanced Access database knowledge.In this course, students will learn how to:Explain what a relational database isDownload and install Access 2021Know the differences between Access 2019 and Access 2021Locate, open, and save Access database templatesOpen, close, and save a blank database fileNavigate the Access interface, ribbons, and commandsCustomize the quick access toolbar with frequently used commandsUnderstand the different menu systems in AccessUse keyboard shortcuts to navigate and execute commandsAccess the help filesCustomize Access optionsCreate tables and fieldsModify field propertiesUnderstand index fields and primary keysCreate lookup menusAdd data validation and data validation text to fieldsImport data into a table from Excel and from a text fileUse datasheet view to manage dataSort and filter records in a tableCreate relationships between tables that share a common fieldCreate relationships between tables using a link tableUnderstand one-to-many relationshipsCreate and design user-friendly formsSetup subformsBuild simple and complex queries to interrogate table dataAggregate numeric dataCreate expressions to perform simple calculationsCreate and run a basic reportCreate a custom reportUse form controls to add checkboxes, attachments, and option buttons to formsModify a form’s design and themeCreate a navigation formExport an Access database to other file formatsProtect a database file by adding encryption and password protectionPrevent database issues using compact and repairPrint tables, forms, and reports.This course includes:7 hours of video tutorials66 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion

Overview

Section 1: Introduction

Lecture 1 Introduction to Access 2021

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Course Exercise Files

Lecture 4 DOWNLOAD ME: Course Demo Files

Lecture 5 Acquiring Access 2021

Lecture 6 What's New in Access 2021?

Lecture 7 Exercise 01

Section 2: Get Started with Access 2021

Lecture 8 Use Database Templates

Lecture 9 Create, Save, and Open Databases

Lecture 10 Explore the Access Interface and Backstage

Lecture 11 Customize the Quick Access Toolbar

Lecture 12 Access Menus

Lecture 13 Keyboard Shortcuts and Key Tips

Lecture 14 Online Help

Lecture 15 Access Options

Lecture 16 Exercise 02

Section 3: Work with Tables

Lecture 17 Create a Table and Fields

Lecture 18 Index Fields, Primary Keys, and Add Records

Lecture 19 Use the Lookup Wizard to Create a Drop-down List

Lecture 20 Numeric Fields and Data Validation Rules

Lecture 21 Add More Table Fields

Lecture 22 Exercise 03

Section 4: Import Data

Lecture 23 Importing Data from Excel

Lecture 24 Import Data from a Text File

Lecture 25 Exercise 04

Section 5: Datasheet View

Lecture 26 Design in the Datasheet View

Lecture 27 Sort and Filter in Datasheet View

Lecture 28 Enter and Modify Data in Datasheet View

Lecture 29 Exercise 05

Section 6: Create Relationships

Lecture 30 Relationships Explained

Lecture 31 Set up Relationships

Lecture 32 Create a Link Table: Part 1

Lecture 33 Create a Link Table: Part 2

Lecture 34 Edit the Link Table

Lecture 35 Exercise 06

Section 7: Forms

Lecture 36 Create a Form: Form Wizard

Lecture 37 Form Properties

Lecture 38 Modify a Form: Single Form vs Continuous View

Lecture 39 Forms in Layout View

Lecture 40 Forms in Design View

Lecture 41 Exercise 07

Section 8: Subforms

Lecture 42 Setting up Subforms: Part 1

Lecture 43 Setting up Subforms: Part 2

Lecture 44 Exercise 08

Section 9: Queries

Lecture 45 Create a Query

Lecture 46 INNER, RIGHT, and LEFT Joins

Lecture 47 Run Queries and Aggregate Numeric Data using Query Wizard

Lecture 48 Exercise 09

Section 10: Validations and Expressions

Lecture 49 Set up More Validations and Expressions

Lecture 50 Basic Calculations using Expressions

Lecture 51 Exercise 10

Section 11: Reports

Lecture 52 Run a Basic Report

Lecture 53 Custom Report Design

Lecture 54 Complex Reports

Lecture 55 Exercise 11

Section 12: More Data Types

Lecture 56 Other Data Types: Yes/No

Lecture 57 Other Data Types: Attachments

Lecture 58 Exercise 12

Section 13: More About Forms

Lecture 59 Form Controls: Option Buttons

Lecture 60 Form Themes and Design

Lecture 61 Navigation Forms

Lecture 62 Exercise 13

Section 14: Share an Access Database

Lecture 63 Export Parts of an Access Database

Lecture 64 Database Properties and Encryption

Lecture 65 Exercise 14

Section 15: Additional Access Features

Lecture 66 Compact and Repair

Lecture 67 Printing and Database Documenter

Lecture 68 Exercise 15

Section 16: Course Close

Lecture 69 Course Close

Beginner Access 2021 users who want to explore the software's functionalities,Users new to Microsoft Access 2021 and those upgrading from previous software versions,Anyone who wants to learn data and database management using Microsoft Access