Access Skills

Learn Microsoft Access with our easy to follow videos

Bite-size videos show you how to use Microsoft Access

See some examples below of lessons that will help you learn Microsoft Access

Explore Access
Create Queries
Build Databases
Generate Forms
Build Tables
Analyse Data
Link Tables
Design Reports

Become awesome at Access

What’s included

Module 1 : Access Essentials

In this first module you’ll learn the essentials of navigating Access; Introduction to Access; Starting access; Opening an existing database; Exploring using the navigation pane; Closing a database and exiting Access; and Creating a new database.

5 Lessons : 1 Quiz : 25 Points towards your Microsoft Office Skills Score

Module 2 : Working with Tables

In Access, you work with Tables. These lessons cover all you need to know; Opening existing tables; Editing, adding and deleting records; Sorting and filtering records; Creating a new table; Adding Fields; The Primary Key; Data Types; Field Properties for Short Text; Field Properties for Numbers; Field Properties for Currency; Field Properties for Date/Time; Table Relationships; Linking to create a relationship between tables; Editing a relationship link; and Deleting a relationship link.

14 Lessons : 1 Quiz : 25 Points towards your Microsoft Office Skills Score

Module 3 : Working with Queries

This short module covers Queries; Creating and Saving a query; Sorting records in a query; Specifying criteria; Finding empty cells; Criteria For Numbers & Dates; Entering multiple criteria; Using multiple tables in a query; and Different query types.

8 Lessons : 1 Quiz : 25 Points towards your Microsoft Office Skills Score

Module 4 : Forms and Reports

Learn how to;Creating a form; Editing a forms design; More form design features; Rename and delete a form; Creating a report; Editing a reports design; Adding an image and a calculated field; and Rename and delete a report.

8 Lessons : 1 Quiz : 25 Points towards your Microsoft Office Skills Score

Skills you'll have

Create and understand relational database models
Query a database and create summary reports
Create simple forms and reports for data entry
Create macros to automate reports and forms
Perform sales and analysis

You'll know how to

Build databases incorporating forms and queries
Print and export into presentations
Design a query to extract information from the
Export information into other Windows based products
Create and edit macros to automate the database

Join now and be amazing at Microsoft Office

JOIN NOW