Microsoft Access 2021 for Beginners: Master the Essentials

Unlock your database superstar potential with this comprehensive Microsoft Access 2021 beginner course!

Created by: Simon Sez IT
990,000+ Students, 290+ Courses, Learners in 180+ Countries

What Will I 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
• Build simple and complex queries to interrogate table data and create expressions to perform simple calculations
• Create and run a basic report and a custom report
• Use form controls to add checkboxes, attachments, and option buttons to forms
• Protect a database file by adding encryption and password protection and prevent database issues using compact and repair
• Export an Access database to other file formats and print tables, forms, and reports

Requirements

• Microsoft Access 2021 downloaded and installed on your machine (ideal but not essential)
• No prior experience needed, the course is for complete beginners.

Target audience

• 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
• Anyone who wants to learn data and database management using Microsoft Access