Microsoft Access for Beginners

Testimonials (7 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!


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



Syllabus

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.  

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.

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. 

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.

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.

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. 

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. 

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.

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.

1

Calculations Using Expressions

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

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.

1

Data Types: Yes/No Checkbox

Add a Yes/No checkbox control to a form.

2

Data Types: Attachments

Add an attachment form control. 

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. 

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.

1

Course Close

Course Close

Download syllabus