First Training

 

"Your IT & Business Training Providers"   

Training Courses

Call us on 01324 719698 or Fax 01324 719942

 

Microsoft Access Advanced

Duration:  1 - 2 Days

 

Introduction / Intermediate / Advanced

Course Description

This is a one to two day workshop course designed for experienced users of Access who wish to learn the use of Macros and Visual Basic for Applications in the design of sophisticated Access applications.

The topics below represent a suggested course content. However these can be adapted to meet specific objectives.

Course Contents

  • Access Overview
  • Relationships and Query Windows
  • Queries
  • Advanced Forms
  • Dates and Expressions
  • Objects, Controls and Properties
  • Adding an Option button, Check box or Toggle Button. Adding a List box or Combo List box. Setting Form and Object Properties

  • Reports and Sections
  • Changing AutoReport Style. Changing Report Wizard Style. Page Breaks.

  • Expressions
  • Inserting the current date and page number. Entering an Expression

  • Macros
  • Creating, adding, saving, changing, deleting and moving macros.

  • Security and Passwords
    Group Security and User Security

 

For further information call us on 01324 719698

 

© First Training Limited, 2-4 Crichton Place, Brightons, Falkirk FK2 0RZ

www.firsttraining.co.uk