LF logo
by learnformula
search
Log in
search
Courses/Information Technology/Information Technology Basics

Microsoft Access 2021/365 for Beginners

Harness the power of Microsoft Access 2021 and journey from database novice to superstar with this beginners’ course from Simon Sez IT.

Created bySimon Sez ITworkspace_premium
4.7
(10 reviews)
BeginnerUpdated Feb 10, 2026
Microsoft Access 2021/365 for Beginners

What You'll Learn

check_circleThe characteristics of a relational database
check_circleDownloading and installing Access 2021
check_circleThe differences between Access 2019 and Access 2021
check_circleLocating, opening, and saving Access database templates
check_circleOpening, closing, and saving a blank database file
check_circleNavigating the Access interface, ribbons, and commands
check_circleCustomizing the quick access toolbar with frequently used commands
check_circleUnderstanding the different menu systems in Access
check_circleUsing keyboard shortcuts to navigate and execute commands
check_circleAccessing the help files
check_circleCustomizing Access options
check_circleCreating tables and fields
check_circleModifying field properties
check_circleUnderstanding index fields and primary keys
check_circleCreating lookup menus
check_circleAdding data validation and data validation text to fields
check_circleImporting data into a table from Excel and from a text file
check_circleUsing datasheet view to manage data
check_circleSorting and filtering records in a table
check_circleCreating relationships between tables that share a common field
check_circleCreating relationships between tables using a link table
check_circleUnderstanding one-to-many relationships
check_circleDesigning user-friendly forms and setting up sub-forms
check_circleBuilding simple and complex queries to interrogate table data
check_circleAggregating numeric data
check_circleBuilding expressions to perform simple calculations
check_circleCreating and running a basic report
check_circleDesigning a custom report
check_circleUsing form controls to add checkboxes, attachments, and option buttons to forms
check_circleModifying a form’s design and theme
check_circleCreating a navigation form
check_circleExporting an Access database to other file formats
check_circleProtecting a database file by adding encryption and password protection
check_circlePreventing database issues using compact and repair functions
check_circlePrinting tables, forms, and reports.

About This Course

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.

Your Instructors

Simon Sez IT
Simon Sez IT

Since 2008, we've taught 2 million learners in over 190 countries, with 200+ courses

menu_book147 courses
star8,850 reviews

Since its formation in 2008, Simon Sez IT has been educating learners with one goal in mind: to make business and technical software simple to learn. The company extensive library of over 10,000 videos across more than 200 courses delivers comprehensive training for the most popular software applications used by professionals worldwide. Courses include training in everyday IT applications, from Microsoft suite of office productivity tools to more niche applications such as QuickBooks, Power BI and many more. Aimed at every level of proficiency, Simon Sez IT courses are designed to give learners the ability to quickly evolve from beginner to advanced, or to drop in at their relevant level and acquire new skills to continue in their development path. Simon Sez IT subject matter experts bring knowledge and practical insights to video-based courses and practice exercises – all designed to help learners immediately apply new knowledge and master learning goals. More than two million learners have relied on Simon Sez IT for its quality and engaging coursework. Student feedback is consistently ranked among the best in the industry, with particular emphasis on the quality, detail and delivery of the course materials. Many indicate that upon completion of a course, they are more confident and proficient in their area of study, and their skills have helped them progress in their careers.

Deborah Ashby
Deborah Ashby

Microsoft Office Specialist and Trainer

Deborah is a TAP accredited, MOS certified IT Trainer specializing in the design, development, and facilitation of Microsoft training courses both online and in the classroom. Deborah’s mantra is ‘making the complicated, simple for all’ and her driving motivation is to help people all over the world gain the skills they need to progress in their career, get that promotion or pass that exam.

Credit Information

Do these courses count toward my professional development requirements?

This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.

If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.

What Students Are Saying

4.7
Student's Choice
10 reviews

Frequently Asked Questions

We are a registered provider with 327+ associations and regulatory bodies worldwide. We operate across 29 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.