MS Access – Introduction

Microsoft Access Introduction Training Courses

Microsoft Access – Introduction Training Courses

1 Day Course | 1 delegate £195 plus VAT
*Book 2 or more delegates and receive significant discounts. Click here for information

Introduction

This one-day instructor led course is designed to give an introduction to the different aspects of Access including basic design principles and effective use of an existing database. By the end of the course delegates will be able to enter and edit data, extract data, and to design a new Access database table.

Course Objectives

  • Understand database terminology
  • Enter, edit and format data
  • Create a new database table
  • Design a new query to extract specified data
  • Create and edit a database form for data entry and manipulation
  • Create and edit simple reports to print out data

Pre-requisites

We recommend that all those who attend are able to:

  • Use the mouse to select and open menus and icons
  • Identify and use the Shift, Ctrl, TAB and Home keys on the keyboard

Course Content

Access Basics

  • Exploring the Access window
  • Understanding database terminology
  • Viewing an existing database
  • Understanding Access objects: Tables / Queries / Forms / Reports
  • Looking at relationships within a database
  • Understanding the function of the Primary Key
  • Keyboard Shortcuts and Menu Items

Database Tables

  • Understanding the difference between
    fields and records
  • Entering and editing data
  • Moving and copying data
  • Sorting and filtering data
  • Finding and replacing data
  • Looking at data types
  • Designing a new table
  • Printing data from a table


Query use and design

  • Understanding the role of the query
  • Modifying a query
  • Creating a new query

Form Creation

  • Creating a new form
  • Editing data within a form
  • Modifying the design of a form

Report Design

  • Creating a new report
  • Modifying the design of a report