Microsoft Access 2021 Beginner to Advanced Course Bundle

About 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