Access level 3 - Advanced

Course Overview

Experience the full power of an Access database.

This course is designed to extend the attendee's knowledge of Access both by expanding upon the skills gained on the Level 1 and 2 courses, and by introducing further techniques. The course is suitable for delegates who will be building and designing their own databases.

This is a one-day course running from 9:30 am - 4:30 pm.
Training is hands-on and tutor-led.
We provide a comprehensive training manual, lunch and certification.
Courses run at both Swansea and Cardiff locations.
This course can be run as a company specific option either at your site or our own.

• Course Content

  Customising the Interface

  Creating forms to use as switchboards; creating
  command buttons.

  Macros

  Defining an action; action arguments; running a
  macro from a command button; the Autoexec macro;
  group macros & conditional macros.

  Custom Forms/Form Control

  Creating multiple page forms and sub-forms, combo
  box properties; functions (including IF and SUM) and
  option groups.

  Reports

  Designing reports; aggregate controls on reports;
  limiting records by using parameter queries.

  Database Security

  Setting a password; user level security; setting up an
  administrator's account and user accounts; assigning
  permission to database accounts.

• Prerequisites

  To gain the maximum benefit from this course an attendee should have attended Levels 1 and 2 or have a thorough knowledge of the information contained within those courses.

• Qualification

  This course covers material from the Advanced European Computer Driving Licence.

• What Next?

  Visual Basic for Applications
  Use VBA to further customise your database. Use the Visual Basic Editor to create modules, view their contents, create or edit macro source code, dialogue boxes and perform any other functions related to writing and maintaining VBA programs.
  
  This is a two-day company specific course - please contact us for details.