Access Introduction course content

Introduction to Microsoft Access

Microsoft Office Access 2010 IntroductionInstructor-led Access 2010 Introduction Outline

Duration:

Intended audience:

1 day

Anyone who has outgrown Excel or needs to start using Microsoft Access as part of their job

Aims:

To familiarise delegates with the Access interface and demonstrate using the software by worked examples

Objectives:

By the end of the session delegates will:

  • Understand basic database structure
  • Be able to create a simple database from scratch
  • Understand fields and records
  • Be able to create a basic query
  • Understand how to print, preview and select data for printing

Prerequisites:

The ability to use the keyboard and mouse in a Windows environment

Microsoft Access has been designed for user friendliness, with a familiar interface that people recognise and easy navigation. It is not for everyone, however, and despite its ease of use some people would feel intimidated by the appearance of datasheet view. It is for this reason that our courses focus on making delegates aware of all the database objects Access has available, including Forms for user input and Reports for output. This is the first step in turning a database into a database application in which it is easy to store and retrieve information. The subject of referential integrity is not covered in this course as we deal with a single table.

Exploring the Access 2010 environment

Access Basics
Planning and designing databases
Creating Databases
Closing a database and Access
Using Microsoft Access Templates

Getting help

Working in design view

Using design view

Importing, Exporting and Linking

Importing Access objects
Exporting Access objects
Linking Access objects

Creating and Using Forms

Creating forms by using AutoForm
Using the form wizard

Exploring reports

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

Exploring tables

Using the table wizard
Changing the design of a table
Adding and deleting records
Sorting and filtering records
Finding and editing records

Database concepts and terminology

Working with Fields and Records

Querying Tables

Examining queries
Creating and using queries
Modifying query results and queries
Using calculations in queries

Microsoft Access Introduction Courses

We have versions for Microsoft Office 2007, Microsoft Office 2010 and Microsoft Office 2013

If you don’t have time to take one of our instructor-led courses, you might enjoy our Access 2010 online e Learning Access Tutorials instead

Looking for an Access 2010 Intermediate course?

Or an Access 2010 Advanced course?