Microsoft Access 2021 for Beginners: Master the Essentials

About Microsoft Access 2021 for Beginners: Master the Essentials

_

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 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.

This course includes:

1.

7 hours

of video tutorials 2.

66 individual video

lectures 3.

Course and Exercise Files

to follow along 4.

Certificate of completion