What you'll learn

This training course is designed to enable users to get to grips with the main features of Access, including a thorough treatment of the new 'Ribbon' interface.

Requirements

Delegates should be proficient in using a PC with the Windows operating system, but no prior experience with Access is required.

Description

MODULE 1: Getting Started with Access

Learning outcomes: Understand how to start Microsoft Access and some of its basic navigation and help controls.

Topics covered:

Starting Out

Interface Basics

Database Security

Getting Help

MODULE 2: The New Ribbon Interface

Learning outcomes: Exploring the Ribbon's different tabs and options.

Topics covered:

The Quick Access Toolbar

Basics of Tabs

The Home Tab

The Create Tab

The External Data Tab

The Database Tools Tab

MODULE 3: Creating a Simple Database

Learning outcomes: Creating basic tables and a look at the different types of fields available.

Topics covered:

First Steps in Database Creation

Database Records

Creating a Table

Formatting Text

MODULE 4: Forms; Queries; Reports and Filters

Learning outcomes: Creating basic forms, queries, reports and filters; essential to the successful creation and administration of an Access Database.

Topics covered:

Creating and Using Forms

Creating and Using Queries

Creating and Using Reports

Sorting and Filtering Data

Viewing Data

Printing a Database Object

Who this course is for:

The course is intended for new users of MS Access 2007, 2010, 2013 or 2016 who want to become productive in the shortest possible time.