Don't just take our word for it

We ask all our past delegates to rate our courses so you can decide if this course is really right for you - just click 'Hear what people say' to read ratings. If you've been on a course, log in to 'My Reed Learning' and leave your review to help others decide.

Introduction to Microsoft Access XP/2003 Course

  • Duration:2 Days
  • Cost:£350 + VAT
  • Ref:ITA

Make Access work for you - not the other way round!

Book now >

Cost £350.00 Duration 2 days Code ITA

Course rating:

(0  vote)

What's this?

  • Hear what people say
  • Send to a friend
  • Add to favourites

Who is it for

Those new to Access and those who are self taught and would like to consolidate or check their understanding.
Not sure if this level is right for you? Why don't you take our quick online test to find out >

What is it about

This course aims to develop your skills and confidence in using MS Access, by starting you off with a solid grounding in the basic techniques.

Course Overview

  • Unit1: Database concepts
    Database concepts and terminology
    Starting with Access
    The Access environment
    Planning and designing databases
    Getting Help
    Closing a database and exiting Access
  • Unit 2: Access basics
    Exploring tables and forms
    Exploring queries
    Exploring reports
  • Unit 3: Creating databases
    Creating a database
    Using the Table Wizard
    Working in Design view
  • Unit 4: Working with fields and records
    Changing the design of a table
    Adding and deleting records
    Finding and editing records
    Sorting and filtering records
  • Unit 5: Querying tables
    Viewing specific fields
    Modifying query results and queries
    Calculations in queries
  • Unit 6: Creating and using forms
    Creating forms by using AutoForm
    Using Form Wizard
    Using Design view
  • Unit 7: Creating and using reports
    Using the Report Wizard
    Using reports to perform calculations
  • Unit 8: Importing and exporting objects
    Importing Access objects
    Exporting Access objects
  • Unit 9: Creating Relational Databases
    Analysing Table Relationships
    Relating Tables
    Testing Referential Integrity
  • Unit 10: Working with Related Tables
    Using the Lookup Wizard
    Modifying Lookup Fields
    Adding Data to Related Tables
  • Unit 11: Defining Data Entry Rules
    Working with Input Masks
    Setting Required Properties
    Setting Validation Rules
    Setting Lookup Fields

What will I get out of it?

You will acquire the confidence and ability to manage the establishment and maintenance of Access databases.

Accredited by

This course is accredited for CPD

  • Hear what people say
  • Send to a friend
  • Add to favourites

Get in touch 

 

0800 170 7777

Email us

What's new this month >