Skip to main content
by learnformula
search
For Business
Team license & compliance management
For Higher Education
Academic partnerships
For Government Agencies
Government training solutions
For Instructors & Course Creators
Teach on our marketplace
Become a Sponsor
Reach professionals where they learn
Log inStart 7-Day Free TrialStart Free TrialStart Free Trial
search
  1. Courses
  2. /Information Technology
  3. /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_premiumBest Instructor
BeginnerUpdated Feb 10, 2026

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.

Course Content

16 activities • 66 videos • duration: 7h

remove
Introduction4 videos • 1 quiz • 13 min
  • videocamIntroduction to Access 2021
    Duration 4:50
  • videocamAcquiring Access 2021
    Duration 3:57
  • videocamWhat's New in Access 2021?
    Duration 3:33
  • videocamExercise 01
    Duration 1:24
  • quizSection 1 Quiz
add
Get Started with Access 20219 videos • 1 quiz • 1 hour
add
Work with Tables6 videos • 1 quiz • 40 min
add
Import Data3 videos • 1 quiz • 10 min
add
Datasheet View4 videos • 1 quiz • 20 min
add
Create Relationships6 videos • 1 quiz • 36 min
add
Forms6 videos • 1 quiz • 47 min
add
Subforms3 videos • 1 quiz • 28 min
add
Queries4 videos • 1 quiz • 26 min
add
Validations and Expressions3 videos • 1 quiz • 19 min
add
Reports4 videos • 1 quiz • 29 min
add
More Data Types3 videos • 1 quiz • 15 min
add
More About Forms4 videos • 1 quiz • 33 min
add
Share an Access Database3 videos • 1 quiz • 17 min
add
Additional Access Features3 videos • 1 quiz • 13 min
add
Course Close1 videos • 5 min

Your Instructors

Simon Sez IT

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

menu_book151 courses
star9,306 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

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

What Students Are Saying

4.7 out of 5
Student's Choice
10 reviews
  • AE
    Anna E.
    starstarstarstarstar

    Very helpful, explained in a clear manner

Frequently Asked Questions

We are a registered provider with 300+ associations and regulatory bodies worldwide. We operate across 27 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.

You May Also Like

  • Engineering: Engineering Management

    Project Management for Engineers

    starRated5.0out of 5,(22 reviews)
    1.5 CPD hrs
  • Engineering: Working with Concrete

    Basics of Reinforced Concrete

    starRated5.0out of 5,(90 reviews)
    3 CPD hrs
  • Engineering: Engineering Management

    AI Management Systems for Engineering Organisations

    starRated4.9out of 5,(19 reviews)
    1 CPD hr