Back
Course details
View pricing Try for free
View pricing Try for free

Microsoft Access for Beginners

Testimonials (21 reviews)

Features

Premium video tutorials

Award-winning instructors

Personalized learning

Get certified

Learn at your own pace

Mobile (learn on-the-go)

Unlimited tests and quizzes

Regularly updated content


Overview

Microsoft Access Course for Beginners: Master the skills to manage your own data tables and reports 

If you've ever felt overwhelmed by the mountains of data in your work, you're not alone. In order to effectively and efficiently manage a high volume of important information, enrolling in Microsoft Access training is essential.

In this Microsoft Access course for beginners, you'll learn:

  • How to navigate and work within the Microsoft Access interface, including tables and datasheets.
  • How to manage, view, import, and validate your own data sets.
  • How to create forms, queries, expressions, reports, and so much more! 

Through a series of interactive, bite-sized lessons, you'll quickly develop the confidence you need to work with your own data, enabling you to make smart decisions through efficient data management and reporting.

Start your journey to smarter data-driven decision-making today with our Microsoft Access course for beginners!

Microsoft Access for Beginners
Focus video player for keyboard shortcuts
Auto
  • HD
  • 720p
  • 540p
  • 360p
1.00x
  • 0.50x
  • 0.75x
  • 1.00x
  • 1.25x
  • 1.50x
  • 1.75x
  • 2.00x
cc

Summary

Skill level: Beginner
Certificate: Yes
Lessons: 43
Accredited by: CPD
Pre-requisites: None
Versions supported: 2016, 2019, 2021
Video duration: 4h 13m
Estimated study time: 16h for all materials

Accreditations and approvals

CPD - The CPD Certification Service. Microsoft Partner

Instructor

Deborah Ashby

Deborah Ashby

Presenter


Syllabus

Course Introduction 1 lesson Free Lesson

1

Try it!

Introduction to Access 2021

Who this course is for, what to expect and a first look at the database we will be creating in this course.  

Getting Started with Access 5 lessons Free Lesson

1

Try it!

Introduction to Database Templates

Explore the templates available in Access and create a contacts database using the template.

2

Creating, Saving, Opening and Closing Databases

Learn how to create a database, save it to a specific location, and how to open existing databases.

3

The Access Interface, Views, and Backstage

Understand the Access Interface including the different workspace elements, the ribbons, and the backstage area. 

4

Getting Help

Get Help on demand when working in Access. 

5

Customizing the Quick Access Toolbar

Learn how to work with the ribbons in Access and add frequently used commands to the Quick Access Toolbar.

Working with Tables 4 lessons Free Lesson

1

Try it!

Creating a Table and Adding Fields

In this lesson, we will learn about tables in Access, and then setup our first table and add fields. 

2

Indexing, Primary Keys and Adding Records

Understand indexing and the concept of primary key fields to identify records. We will then start to build our database by adding our first records to the Trip table. 

3

Using the Lookup Wizard to Create a Drop-down List

Control the information entered into a field by creating a drop-down list using the Lookup Wizard. 

4

Adding Numeric Fields and Setting Data Validation Rules

Add three numeric fields to the table and set the properties for each including data validation rules. 

Importing Data 1 lesson

1

Importing Data from an Excel spreadsheet and a Text File

Import additional data from an Excel file and a Text File into Access and append it to the bottom of the Ticket table.

Datasheet View 3 lessons

1

Working in Datasheet View

Explore the options for designing in the datasheet view.

2

Sorting and Filtering in Datasheet View

Organize and refine records in a table using sorting and filtering in datasheet view. 

3

Entering and Modifying Data in Datasheet View

Learn some useful tips for entering data into Datasheet view.

Creating Relationships 4 lessons

1

Relationships Explained

Understand how relationships work in Access and why they are fundemental to building a functional database. 

2

Creating a Link Table

Start the process of creating a relationship between two tables by setting up a link table.

3

Setting Up Relationships

Create a third table to hold the company information and then create a link table to link the ticket table to the company table. 

4

Editing the Link Table

Make changes to the link table and understand the types of error messages that can occur. 

Working with Forms 7 lessons

1

Creating a Form - Form Wizard

Creating a user form using the Form Wizard. 

2

Form Properties

Adjust the properties of the form using the Property Sheet and Form Properties. 

3

Modifying a Form - Single Form vs Continuous View

Make modifications to the way the form looks and behaves by switching it to Single form view.

4

Forms in Layout View - Part 1

Make design changes to a form using Layout View. 

5

Forms in Layout View - Part 2

Make design changes to a form using Layout View. 

6

Forms in Design View - Part 1

Create a blank form, add fields, and make changes to the form in Design View. 

7

Forms in Design View - Part 2

Continue editing the form in Design View. 

Subforms 2 lessons

1

Setting Up Subforms - Part 1

Create a new table, populate it with information, and link it to the ticket table in preparation for creating a subform. 

2

Setting Up Subforms - Part 2

Continue setting up the subform and protect it from editing.

Queries 3 lessons

1

Creating a Query - Query Design

Creating your first query to search through records in a database.

2

Understanding Joins

Learn how to use joins to create a query using information from more than one table.

3

Creating a Query - Query Wizard

Use the Query Wizard to build different types of query and perform aggregation.

Expressions 1 lesson

1

Calculations Using Expressions

Use an expression to perform calculations on fields and display new information, such as an end date.

Reports 2 lessons

1

Basic Reports

Create a basic report using the Report Wizard and explore Print Preview.

2

Report Design

Explore the basics of modifying a reports design.

More Data Types 2 lessons

1

Data Types: Yes/No Checkbox

Add a Yes/No checkbox control to a form.

2

Data Types: Attachments

Add an attachment form control. 

More About Forms 3 lessons

1

Form Controls: Option Buttons

Add option buttons to the form. 

2

Form Themes

Switch between different themes and customize a theme. 

3

Navigation Form

Limit users to just the forms they need by creating a navigation form. 

Access Options 4 lessons

1

Exporting an Access Database

Explore the different ways you can export tables, forms and reports. 

2

Database Properties and Encryption

Modify database properties and encrypt the database with a password.

3

Compact and Repair

Repair and fix errors in a database.

4

Printing and Database Documenter

How to adjust Print Properties and Print database objects.

Course Close 1 lesson

1

Course Close

Course Close

Download syllabus


Certificates

You can earn 2 certificates with this course

Certificate of Training

Rewarded upon successful completion of your training course.

See sample

Certificate of Achievement

Rewarded upon successful completion of your training course and test.

See sample
Get started View pricing
View pricing Get started

See what our customers are saying...

“Awesome! 😍”

    

Olusola Timothy Ogundepo

“Awesome learning. Great instructors.”

Nathan Magona

“Very interesting, and so helpfull! Will recommend it to anyone!!!”

Este Pieters Photography

“Good for visual learners”

Chi Bashangi

“I learned a lot that I did not know.”

RENEE HAWKINS

“Super impressed with the presentation and instruction. ”

Comptess Hammond

“Very good and informative.”

Craig Govender

Others who bought this course also viewed

Recommended
Project Management Basics
     4.7 (232 reviews)
GoSkills Unlimited
     4.7 (31,997 reviews)
Microsoft PowerPoint 365
     4.7 (101 reviews)
Recommended
Microsoft Excel 365 - Basic & Advanced
     4.7 (2,477 reviews)
Back to the top

© 2023 GoSkills Ltd. Skills for career advancement