Home Page
82 Bankside
Bolton
BL5 2QH

Tel: 01204 36 37 38
Course Information
  • Word-processing
  • Spreadsheets
  • Presentations
  • Databases
  • Project
  • The Internet & E-mail
  • Course Details
    Access

  • Introduction
  • Intermediate
  • Advanced

  • Access Intermediate

    Course Prerequisites:

    This course has been designed for users of Microsoft Access and assumes a basic knowledge of Access.

    It is expected that users have attended the Access Introduction course or are proficient with Access and have good mouse and keyboard skills.

    Course content:

    Revision -
    Database design and Basic Table Structures
    Basic Queries
    Basic form Creation
    Review - Basic Report Creation

    Table Structures
    Importing external data (Excel, Access etc)
    Validating data
    Field formats
    Custom input masks
    Renaming tables

    Joining Tables
    Defining relationships between tables - One to one - One to many - Many to many
    Referential integrity
    Different types of Table joins

    Working with Queries
    Parameter queries
    Calculated queries
    Summary queries
    Update
    Delete
    Append
    Make table

    Forms and Subforms
    Parent and child forms
    Adding controls to forms
    Combo boxes
    Option groups
    Labels
    Unbound fields

    Building a User Interface
    Command buttons
    Designing menus
    Controlling form behaviour
    Form properties

    Using Advanced Reporting
    Now()
    Page()
    Sum()
    Group totals
    Sub reports
    Mailing Labels

    Macros
    Creating Macros
    Expression builder
    Using conditions

    Useful Functions
    IIF()

    Duration - 1 day

      Home | E-mail | Location Map | Booking Form
     
      Site maintained by chris@actraining.co.uk
      Last updated 1 January 2014, AcTraining