Free Course Image Microsoft Access for Beginners: Building Your First Database

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 Tutorial 15m
  • 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 Tutorial 14m
  • 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 Tutorial 21m
  • 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 Tutorial 16m
  • 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 Tutorial 25m
  • 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 Tutorial 21m
  • 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 Tutorial 21m
  • Video class: Microsoft Access Beginner 1, Lesson 07: Entering Data, Part 2. For Access 2016, 2019, 365 Tutorial 15m
  • 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 Tutorial 18m
  • 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 Tutorial 24m
  • 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 Tutorial 18m
  • 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 Tutorial 10m
  • 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 Tutorial 25m
  • Exercise: In Microsoft Access, what is the main purpose of a report compared to a form?
  • Video class: Microsoft Access Beginner 1, Lesson 13: Review 07m
  • Video class: Microsoft Access Beginner 1, Lesson 14: Questions 16m
  • 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 Boxes 12m
  • 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, Themes 12m
  • 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, Primary 15m
  • 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 Boxes 20m
  • 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?

This free course includes:

6 hours and 19 minutes of online video course

Digital certificate of course completion (Free)

Exercises to train your knowledge

100% free, from content to certificate

Ready to get started?Download the app and get started today.

Install the app now

to access the course
Icon representing technology and business courses

Over 5,000 free courses

Programming, English, Digital Marketing and much more! Learn whatever you want, for free.

Calendar icon with target representing study planning

Study plan with AI

Our app's Artificial Intelligence can create a study schedule for the course you choose.

Professional icon representing career and business

From zero to professional success

Improve your resume with our free Certificate and then use our Artificial Intelligence to find your dream job.

You can also use the QR Code or the links below.

QR Code - Download Cursa - Online Courses

More free courses at Office Productivity (Excel, Word and More)

Free Ebook + Audiobooks! Learn by listening or reading!

Download the App now to have access to + 5000 free courses, exercises, certificates and lots of content without paying anything!

  • 100% free online courses from start to finish

    Thousands of online courses in video, ebooks and audiobooks.

  • More than 60 thousand free exercises

    To test your knowledge during online courses

  • Valid free Digital Certificate with QR Code

    Generated directly from your cell phone's photo gallery and sent to your email

Cursa app on the ebook screen, the video course screen and the course exercises screen, plus the course completion certificate