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 Introduction

    Course Prerequisites:

    This course has been designed for new users of Microsoft Access.

    It is expected that users have attended the Microsoft Windows Introduction course or are proficient with Windows, the mouse and have a basic keyboard understanding. A working knowledge of Excel would be an advantage.

    Course content:

    Introduction
    Concepts of Access
    The Access screen
    Menus and dialog boxes
    Using help Access objects

    Designing and creating a database
    Designing a database
    Creating a database/table
    Adding and viewing records
    Editing data in a table
    Sorting records
    Printing
    Saving and closing a database

    Changing the database
    Inserting, deleting and re-arranging fields
    Field properties
    Datasheet layout

    Queries
    Introduction
    Creating, saving and closing a query
    Summarising data
    Action queries

    Forms
    Introduction
    Creating and printing a form
    Form design and Controls
    Creating a blank form
    Subforms Filters

    Reports
    Creating and saving a report
    Report design facilities
    Working with fields
    Printing a report

    Statistical functions
    Creating mailing labels

    Duration - 2 days

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