Free online courseMicrosoft Access for Beginners: Building Your First Database
Duration of the online course: 6 hours and 19 minutes
New
Free Microsoft Access course for beginners: plan a database, build tables, enter data, run queries, create forms and reports in Access 2016/2019/365.
In this free course, learn about
Access Fundamentals and Database Planning
Getting Started and Building the Customer Table
Entering, Managing, and Querying Customer Data
Forms and Reports for Users
Beginner Level 1 Review and Q&A
Beginner Level 2 Introduction and Security Setup
Form Design Essentials and Layout Tools
Relationships and Lookup Controls (Combo Boxes)
Student Questions and Next Steps
Course Description
Microsoft Access for Beginners: Building Your First Database is a free online course designed to help you move from spreadsheets to a structured database using Microsoft Access. Aimed at newcomers, it explains what Access is, when to use it, and how to plan a database before you start building, so your tables, fields, and data stay organized from day one.
You will learn to create and refine a customer table, enter data efficiently, and keep information clean and searchable. The course shows practical ways to sort and filter records, then introduces queries so you can pull exactly the information you need for everyday tasks and reporting.
As you progress, you will build user-friendly forms for data entry and navigation, then create reports to present information in a clear, printable format. Later sections introduce form design concepts and formatting, along with an accessible introduction to relationships, including primary keys and linking data across tables. You will also see how combo boxes can streamline input and reduce errors.
Built around Access versions 2016, 2019, and Microsoft 365, this training is a strong starting point for office productivity workflows, small business record-keeping, and anyone who wants to understand how databases work in a hands-on way.
Course content
Video class: Microsoft Access Beginner 1, Lesson 00: Introduction. For Access 2016, 2019, 365 Tutorial15m
Exercise: Which set lists the main components of a Microsoft Access database?
Video class: Microsoft Access Beginner 1, Lesson 01: What's Microsoft Access. For Access 2016, 2019, 365 Tutorial14m
Exercise: Which Microsoft Access object is primarily used to store all the data in a database?
Video class: Microsoft Access Beginner 1, Lesson 02: Planning Your Database. For Access 2016, 2019, 365 Tutorial21m
Exercise: When planning a new database, what should you do before you start building it in Access?
Video class: Microsoft Access Beginner 1, Lesson 03: Getting Started. For Access 2016, 2019, 365 Tutorial16m
Exercise: How do you switch Microsoft Access from the tabbed document interface to overlapping windows?
Video class: Microsoft Access Beginner 1, Lesson 04: Customer Table, Part 1. For Access 2016, 2019, 365 Tutorial25m
Exercise: When creating a new table for a database, what is the main advantage of using Table Design instead of Datasheet View?
Video class: Microsoft Access Beginner 1, Lesson 05: Customer Table, Part 2. For Access 2016, 2019, 365 Tutorial21m
Exercise: When designing a Customer table, which field type is recommended for a Phone Number field and why?
Video class: Microsoft Access Beginner 1, Lesson 06: Entering Data, Part 1. For Access 2016, 2019, 365 Tutorial21m
Video class: Microsoft Access Beginner 1, Lesson 07: Entering Data, Part 2. For Access 2016, 2019, 365 Tutorial15m
Exercise: In Microsoft Access, what is the purpose of the gray box on the far left of a table row (the record selector)?
Video class: Microsoft Access Beginner 1, Lesson 08: Sorting, Filtering Data. For Access 2016, 2019, 365 Tutorial18m
Exercise: In Microsoft Access Datasheet view, what determines whether a field sorts numerically or alphanumerically (as text)?
Video class: Microsoft Access Beginner 1, Lesson 09: Customer Queries. For Access 2016, 2019, 365 Tutorial24m
Exercise: In Query Design, how does Access determine the priority when sorting by multiple fields?
Video class: Microsoft Access Beginner 1, Lesson 10: Customer Form Part 1. For Access 2016, 2019, 365 Tutorial18m
Exercise: What is a key advantage of using a form instead of working directly in a table or query?
Video class: Microsoft Access Beginner 1, Lesson 11: Customer Form Part 2. For Access 2016, 2019, 365 Tutorial10m
Exercise: When creating a blank form in Design View, what should you set first so the form knows where to get its data?
Video class: Microsoft Access Beginner 1, Lesson 12: Customer Reports. For Access 2016, 2019, 365 Tutorial25m
Exercise: In Microsoft Access, what is the main purpose of a report compared to a form?
Video class: Microsoft Access Beginner 1, Lesson 13: Review07m
Video class: Microsoft Access Beginner 1, Lesson 14: Questions16m
Exercise: In Microsoft Access, what is a free option for users who need to run a database but should not make design changes?
Video class: Microsoft Access Beginner 2, Lesson 00: Introduction. What's Covered.04m
Exercise: In this course level, what is introduced as a way to avoid repeated security warnings when opening databases?
Video class: Microsoft Access Beginner 2, Lesson 01: Getting Started. Security Warning. Trusted Location. Review.09m
Video class: Microsoft Access Beginner 2, Lesson 02: Form Design, Intro to Relationships, Combo Boxes12m
Exercise: Where do you set the Record Source for a form in Microsoft Access?
Video class: Microsoft Access Beginner 2, Lesson 03: Form Formatting, The Grid, Properties, Themes12m
Exercise: What does the “Size to Grid” command do in Microsoft Access form design?
Video class: Microsoft Access Beginner 2, Lesson 04: Intro to Relationships, Primary15m
Exercise: In a one-to-many setup like Customers to Appointments, what field is stored in the Appointment table to link each appointment back to the correct customer?
Video class: Microsoft Access Beginner 2, Lesson 05: Trusted Locations, Form Design, Relationships, Combo Boxes20m
Exercise: When using the Combo Box Wizard on an Appointment form to select a customer, what should the combo box store in the Appointment table?
Video class: Microsoft Access Beginner 2, Lesson 06: Questions From Students, Custom Ribbon, Access on Mac, More.25m
Exercise: In Microsoft Access, what should AutoNumber fields primarily be used for?
Video class: Microsoft Access Beginner 2, Lesson 07: Coming Up Next...05m
Exercise: Which topic is a major focus in Access Beginner Level 3?