Access Introduction Training Course

Who is this course for?

Our Microsoft Access Introduction course is suitable for complete beginners to Microsoft Access.

Prerequisites

A working knowledge of Windows is required, or our Microsoft Windows Introduction course. No experience of MS Access is required.

Benefits

At the end of this course you will have a good working knowledge of Microsoft Access training basics. You will feel more confident using Access, and be able to create a database from scratch. Understanding and using tables, fields and records and the rules for entering your data is the foundation from which you can create simple queries, use forms and, ultimately create reports.

After completing this course you will be prepared to attend the Access Intermediate training course.

What's new in Access

Database Concepts

Database concepts and terminology
Exploring the Access environment
Planning and designing databases
Getting help
Closing a database and Access

Access Basics

Exploring tables
Examining queries
Exploring reports

Creating Databases

Creating a database
Using the table wizard
Working in design view

Working with Fields and Records

Changing the design of a table
Adding and deleting records
Finding and editing records
Sorting and filtering records Querying Tables
Creating and using queries
Modifying query results and queries
Using calculations in queries

Creating and Using Forms

Creating forms by using AutoForm
Using the form wizard
Using design view
Finding, sorting and filtering records

Creating and Using Reports

Using the report wizard and queries
Creating, modifying and printing reports

Importing, Exporting and Linking Objects

Importing Access objects
Exporting Access objects
Linking Access objects

Face-to-face training

Training is held in our modern, comfortable, air-conditioned suites.

Modern-spec IT, fully networked with internet access

Lunch, breaks and timing

A hot lunch is provided at local restaurants near our venues:

• Bloomsbury
• Limehouse

Courses start at 9:30am.

Please aim to be with us for 9:15am.

Browse the sample menus and view joining information (how to get to our venues).

Refreshments

Available throughout the day:

• Hot beverages
• Clean, filtered water
• Biscuits

Virtual training

Regular breaks throughout the day.

Learning tools

In-course handbook

Contains unit objectives, exercises and space to write notes

Reference material

Available online. 100+ pages with step-by-step instructions

24 months access to Microsoft trainers

Your questions answered on our support forum.