Microsoft Access Introduction

Versions Available: 2007, 2010 and 2013

Course Overview:

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.

Course Content:

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

Duration: One Day

Availability: Course only available on Customer Premises

WS Training is affiliated and associated with the following organisations: