Microsoft Access 2021 Beginner to Advanced Course Bundle

**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 Beginners

• Explain what a relational database is

• Download and install Access 2021

• Know the differences between Access 2019 and Access 2021

• Locate, open, and save Access database templates

• Open, close, and save a blank database file

• Navigate the Access interface, ribbons, and commands

• Customize the quick access toolbar with frequently used commands

• Understand the different menu systems in Access

• Use keyboard shortcuts to navigate and execute commands

• Access the help files

• Customize Access options

• Create tables and fields

• Modify field properties

• Understand index fields and primary keys

• Create lookup menus

• Add data validation and data validation text to fields

• Import data into a table from Excel and from a text file

• Use datasheet view to manage data

• Sort and filter records in a table

• Create relationships between tables that share a common field

• Create relationships between tables using a link table

• Understand one-to-many relationships

• Create and design user-friendly forms

• Setup subforms

• Build simple and complex queries to interrogate table data

• Aggregate numeric data

• Create expressions to perform simple calculations

• Create and run a basic report

• Create a custom report

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

• Modify a form’s design and theme

• Create a navigation form

• Export an Access database to other file formats

• Protect a database file by adding encryption and password protection

• Prevent database issues using compact and repair

• Print tables, forms, and reports.

Access 2021 Advanced

• Create primary keys

• Understand indexing rules and guidelines

• Set up the sample ‘Northwind’ database

• Work efficiently in datasheet view

• Customize datasheet view

• Apply advanced sorting and filtering techniques

• Create sub-datasheets

• Link to tables in other Access databases

• Install and set up SQL Server Express

• Split an Access database into front end and back end

• Convert tables to local tables

• Address multi-user issues when sharing database files

• Work through the basics of macros

• Modify the AutoExec macro

• Understand macro events

• Adjust macro security settings

• Handle macro errors

• Customize the quick access toolbar

• Convert macros to VBA code

• Write and run VBA code

• Understand VBA error handling

• Create modules, subs, functions, IntelliSense, and variables

• Name variables and strings

• Work with standard functions

• Add events to a database

• Create switchboards and navigation forms.

• Format bound and control forms

• Split forms

• Create tabbed forms

• Adjust combo-box properties

• Build advanced queries

• Write and modify SQL statements

• Understand joins and join types

• Work with action queries

• Create subqueries

• Protect the database and VBA code.

This course bundle includes:

1. 13+ hours of video tutorials

2. 110+ individual video lectures

3. Course and exercise files to follow along

4. Certificate of completion