Access Level 1
Course Outline

DURATION 1 day
PREREQUISITES Must be confident in at least one other Microsoft Application, preferably Excel.
DESCRIPTION This course provides an introduction to using Microsoft Access for database creation, focussing mostly on table design and select queries. Forms and Reports are introduced mostly using the inbuilt wizards.
COURSE DATES  SPECIAL: Four Days of MS Office training for the price of Three!

Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.
Evening Wed, 22-Feb-12 and Thu, 23-Feb-12 18:30 - 21:30 £200.00 +VAT
Weekday Tue, 6-Mar-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 24-Mar-12 10:00 - 16:30 £200.00 +VAT
Weekday Mon, 9-Apr-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 23-Apr-12 and Tue, 24-Apr-12 18:30 - 21:30 £200.00 +VAT
Weekday Tue, 1-May-12 09:30 - 16:30 £200.00 +VAT
Evening Wed, 23-May-12 and Thu, 24-May-12 18:30 - 21:30 £200.00 +VAT
Weekday Fri, 1-Jun-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 23-Jun-12 10:00 - 16:30 £200.00 +VAT
Weekday Mon, 2-Jul-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 23-Jul-12 and Tue, 24-Jul-12 18:30 - 21:30 £180.00 +VAT
Weekday Wed, 1-Aug-12 09:30 - 16:30 £200.00 +VAT
Evening Wed, 22-Aug-12 and Thu, 23-Aug-12 18:30 - 21:30 £200.00 +VAT
Weekday Tue, 11-Sep-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 22-Sep-12 10:00 - 16:30 £200.00 +VAT
Weekday Mon, 1-Oct-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 22-Oct-12 and Tue, 23-Oct-12 18:30 - 21:30 £200.00 +VAT
Weekday Thu, 1-Nov-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 24-Nov-12 10:00 - 16:30 £200.00 +VAT
Weekday Mon, 3-Dec-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 22-Dec-12 10:00 - 16:30 £200.00 +VAT
Any One-to-One Tuition
Any Date - Fully Customisable		 09:30 - 16:30 £375.00 +VAT

Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

 

 

 

INTRODUCTION

  • Database Basic Concepts

  • Database Object Overview

 

USING TABLES

  • Field Names vs Records

  • Navigating around a table

  • Entering Data

  • Deleting Records

  • Modifying the datasheet

    • Moving Columns (Fields)

    •  Hiding/Unhiding Fields

  • Understanding Table Relationships

 

CREATING TABLES

  • Defining Field Names

  • Selecting Data Types

  • Using Descriptions

  • Modifying Field Properties

  • Using Primary Keys

  • Attaching a photo or file to a record

 

SELECT QUERIES

  • What is a query

  • Designing a Query

  • Using Criteria

  • Sorting Results

  • Creating a Calculation

  • Setting the format property of a calculated column

 

SIMPLE FORMS

  • What is a Form

  • Why use a Form

  • Creating a Form using the wizard

  • Making simple formatting changes

  • Adding a Form Header

  • Adding a Calculation

  • Moving and Resizing Objects

  • Understanding Properties of a Form

 

SIMPLE REPORTS

  • What is a Report

  • Why use a Report

  • Creating a Report using the wizard

  • Making simple formatting changes

  • Moving and Resizing Objects

  • Understanding Properties of a Form

 

 

 

 

 

 
 

 

 Home | Contact