Microsoft Access 2021 Beginner To Advanced Course Bundle

Master Microsoft Access 2021 with this great value beginner to advanced course bundle and elevate your database skills!

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

Understand indexing rules and guidelines

Work effectively in and customize datasheet view

Apply advanced sorting and filtering techniques

Link to tables in other Access databases

Address multi-user issues when sharing database files

Maximize the effective use of macros

Write, edit, debug, and run VBA code

Build advanced queries

Write and modify SQL statements.

Requirements

Microsoft Access 2021 desktop version for Windows installed and ready to use on your computer (ideal but not required)

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

Description

**This bundle includes practice exercises, downloadable files, and LIFETIME access**Whether you are an absolute beginner looking to get started with database management or you aspire to become a database expert and advance your career, this Microsoft Access 2021 beginner to advanced course bundle will meet you at your skill level and provide the necessary guidance to take you to the next level.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.Explore the basic functionalities of Access and get familiar with the terminology, the interface, and the commands. This will provide a fantastic starting point from which to build more advanced Access database knowledge. Then embark on an immersive learning journey and explore a wide range of advanced topics. We will guide you through mastering complex queries, optimizing database performance, writing SQL code, developing macros, leveraging advanced forms and reports, and integrating Access with other applications and data sources.What's included?Access 2021 BeginnersExplain 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.Access 2021 AdvancedCreate primary keysUnderstand indexing rules and guidelinesSet up the sample ‘Northwind’ databaseWork efficiently in datasheet viewCustomize datasheet viewApply advanced sorting and filtering techniquesCreate sub-datasheetsLink to tables in other Access databasesInstall and set up SQL Server ExpressSplit an Access database into front end and back endConvert tables to local tablesAddress multi-user issues when sharing database filesWork through the basics of macrosModify the AutoExec macroUnderstand macro eventsAdjust macro security settingsHandle macro errorsCustomize the quick access toolbarConvert macros to VBA codeWrite and run VBA codeUnderstand VBA error handlingCreate modules, subs, functions, IntelliSense, and variablesName variables and stringsWork with standard functionsAdd events to a databaseCreate switchboards and navigation forms.Format bound and control formsSplit formsCreate tabbed formsAdjust combo-box propertiesBuild advanced queriesWrite and modify SQL statementsUnderstand joins and join typesWork with action queriesCreate subqueriesProtect the database and VBA code.This course bundle includes:13+ hours of video tutorials110+ individual video lecturesCourse and exercise files to follow alongCertificate of completion

Overview

Section 1: Beginners: 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 Downloadable Course Transcript

Lecture 6 Acquiring Access 2021

Lecture 7 What's New in Access 2021?

Lecture 8 Exercise 01

Section 2: Beginners: Get Started with Access 2021

Lecture 9 Use Database Templates

Lecture 10 Create, Save, and Open Databases

Lecture 11 Explore the Access Interface and Backstage

Lecture 12 Customize the Quick Access Toolbar

Lecture 13 Access Menus

Lecture 14 Keyboard Shortcuts and Key Tips

Lecture 15 Online Help

Lecture 16 Access Options

Lecture 17 Exercise 02

Section 3: Beginners: Work with Tables

Lecture 18 Create a Table and Fields

Lecture 19 Index Fields, Primary Keys, and Add Records

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

Lecture 21 Numeric Fields and Data Validation Rules

Lecture 22 Add More Table Fields

Lecture 23 Exercise 03

Section 4: Beginners: Import Data

Lecture 24 Importing Data from Excel

Lecture 25 Import Data from a Text File

Lecture 26 Exercise 04

Section 5: Beginners: Datasheet View

Lecture 27 Design in the Datasheet View

Lecture 28 Sort and Filter in Datasheet View

Lecture 29 Enter and Modify Data in Datasheet View

Lecture 30 Exercise 05

Section 6: Beginners: Create Relationships

Lecture 31 Relationships Explained

Lecture 32 Set up Relationships

Lecture 33 Create a Link Table: Part 1

Lecture 34 Create a Link Table: Part 2

Lecture 35 Edit the Link Table

Lecture 36 Exercise 06

Section 7: Beginners: Forms

Lecture 37 Create a Form: Form Wizard

Lecture 38 Form Properties

Lecture 39 Modify a Form: Single Form vs Continuous View

Lecture 40 Forms in Layout View

Lecture 41 Forms in Design View

Lecture 42 Exercise 07

Section 8: Beginners: Subforms

Lecture 43 Setting up Subforms: Part 1

Lecture 44 Setting up Subforms: Part 2

Lecture 45 Exercise 08

Section 9: Beginners: Queries

Lecture 46 Create a Query

Lecture 47 INNER, RIGHT, and LEFT Joins

Lecture 48 Run Queries and Aggregate Numeric Data using Query Wizard

Lecture 49 Exercise 09

Section 10: Beginners: Validations and Expressions

Lecture 50 Set up More Validations and Expressions

Lecture 51 Basic Calculations using Expressions

Lecture 52 Exercise 10

Section 11: Beginners: Reports

Lecture 53 Run a Basic Report

Lecture 54 Custom Report Design

Lecture 55 Complex Reports

Lecture 56 Exercise 11

Section 12: Beginners: More Data Types

Lecture 57 Other Data Types: Yes/No

Lecture 58 Other Data Types: Attachments

Lecture 59 Exercise 12

Section 13: Beginners: More About Forms

Lecture 60 Form Controls: Option Buttons

Lecture 61 Form Themes and Design

Lecture 62 Navigation Forms

Lecture 63 Exercise 13

Section 14: Beginners: Share an Access Database

Lecture 64 Export Parts of an Access Database

Lecture 65 Database Properties and Encryption

Lecture 66 Exercise 14

Section 15: Beginners: Additional Access Features

Lecture 67 Compact and Repair

Lecture 68 Printing and Database Documenter

Lecture 69 Exercise 15

Section 16: Beginners: Course Close

Lecture 70 Course Close

Section 17: Advanced: Introduction

Lecture 71 Course Introduction

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

Lecture 73 DOWNLOAD ME: Course Exercise Files

Lecture 74 DOWNLOAD ME: Course Demo Files

Lecture 75 Downloadable Course Transcript

Lecture 76 Set Up for Success in Access 2021

Section 18: Advanced: Primary Keys and Indexes

Lecture 77 Primary Keys and Indexing Rules and Guidelines

Lecture 78 More About Indexes

Section 19: Advanced: Using Datasheet View

Lecture 79 Setup the Northwind Database

Lecture 80 Work in a Datasheet View

Lecture 81 Customize Datasheet View

Lecture 82 Advanced Sorting and Filtering in Datasheet View

Lecture 83 Subdatasheets

Lecture 84 Exercise 01

Section 20: Advanced: Linking to Other Access Databases

Lecture 85 Linking Two Tables to Other Access Databases

Section 21: Advanced: Using ODBC and SQL Server

Lecture 86 Install SQL Server Express

Lecture 87 Setup SQL Server Express

Lecture 88 Exercise 02

Section 22: Advanced: Splitting an Access Database

Lecture 89 Splitting an Access Database into Frontend and Backend

Lecture 90 Convert To Local Table

Lecture 91 Addressing Multi-user Issues when Sharing Data

Lecture 92 Exercise 03

Section 23: Advanced: Macros

Lecture 93 Basics of Macros

Lecture 94 Macro on Events; AutoExec

Lecture 95 More About AutoExec

Lecture 96 Macro Security Settings

Lecture 97 Exercise 04

Section 24: Advanced: The Ribbon

Lecture 98 Customize the Quick Access Toolbar and Tabs

Section 25: Advanced: Visual Basic for Applications

Lecture 99 Convert Macros to VBA

Lecture 100 Run VBA Code and Error Handling

Lecture 101 Create Modules: Subs, Functions, Intellisense and Variables

Lecture 102 Scope, Variable Naming and Strings

Lecture 103 Standard Functions: Logical, Case and Loops

Section 26: Advanced: Access Events Model

Lecture 104 Adding Events to Assets Database

Lecture 105 Exercise 05

Lecture 106 Common Events: Form and Report Events

Lecture 107 Switchboard, Navigation Forms and Error Handling

Lecture 108 Exercise 06

Section 27: Advanced: Forms

Lecture 109 Formatting Bound and Control Forms

Lecture 110 Split Forms and Macro Error Handling

Lecture 111 Creating Form with Tab

Lecture 112 Go To Combo Box and Its Properties

Lecture 113 Exercise 07

Section 28: Advanced: Advanced Use of Queries

Lecture 114 Basics of Queries

Lecture 115 Syntax of SQL Statements

Lecture 116 Use of Multiple Where Criteria & Select Statements Function

Lecture 117 Joins and Join Types

Lecture 118 Exercise 08

Lecture 119 Action Queries - Part 1

Lecture 120 Action Queries - Part 2

Lecture 121 Subqueries

Section 29: Advanced: Protecting the Database and Code

Lecture 122 Protect the Database and VBA Code

Lecture 123 Exercise 09

Section 30: Advanced: Conclusion

Lecture 124 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,Experienced database managers or those who are familiar with Access 2021 wanting to expand their skills and explore the software's more advanced features,Anyone who wants to learn data and database management using Microsoft Access