Access 2021 Beginners
- Description
- Course Resources
Access 2021 Beginners
- DURATION: 6.59 hours
- VIDEOS: 66
- LEVEL: Beginner
Access 2021 is so much more than a way to create customizable desktop databases. It is a user-friendly tool that allows us to create business applications and templates from scratch without the need for high-level development skills. It allows even the novice database builder to start creating tables, forms, queries, and reports quickly.
Access 2021 is the latest on-premises release from Microsoft and the newest addition to the Access family of applications. 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 construct queries to interrogate the data. We’ll look at building nicely formatted forms so others can interact easily with our database and design 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 about:
- The characteristics of a relational database
- Downloading and installing Access 2021
- The differences between Access 2019 and Access 2021
- Locating, opening, and saving Access database templates
- Opening, closing, and saving a blank database file
- Navigating the Access interface, ribbons, and commands
- Customizing the quick access toolbar with frequently used commands
- Understanding the different menu systems in Access
- Using keyboard shortcuts to navigate and execute commands
- Accessing the help files
- Customizing Access options
- Creating tables and fields
- Modifying field properties
- Understanding index fields and primary keys
- Creating lookup menus
- Adding data validation and data validation text to fields
- Importing data into a table from Excel and from a text file
- Using datasheet view to manage data
- Sorting and filtering records in a table
- Creating relationships between tables that share a common field
- Creating relationships between tables using a link table
- Understanding one-to-many relationships
- Designing user-friendly forms and setting up sub-forms
- Building simple and complex queries to interrogate table data
- Aggregating numeric data
- Building expressions to perform simple calculations
- Creating and running a basic report
- Designing a custom report
- Using form controls to add checkboxes, attachments, and option buttons to forms
- Modifying a form’s design and theme
- Creating a navigation form
- Exporting an Access database to other file formats
- Protecting a database file by adding encryption and password protection
- Preventing database issues using compact and repair functions
- Printing tables, forms, and reports.
Access 2021 Beginners
The course comes with course and exercise files compressed into .zip format. You will need to download the .zip file to your PC or Mac (the files are not compatible with a mobile device) and unzip it. Once unzipped, all of the exercise files will reside in one folder.
Click on the below links to download the zip files.
What people are saying
Trusted by
Start Your Membership
Simon Sez: “Let’s make you a software superstar!”
From Excel to photo editing, experience quality courses that ensure easy learning.
START YOUR MEMBERSHIPLearn More