Access level 3 - Advanced

Microsoft Office - Microsoft Access

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.

  • 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.

Booking Options Available for Access level 3 - Advanced

Please select the location you want to book the course

Download Booking Form

Alternatively you can download our booking form, fill in all the relevant information and mail it back to us.

Tailored Training

Tailored Training

Take advantage of a customised training programme to suit your needs at a location of your choice.

Learn More

Funded Training

Funded Training

Funding might be available for training depending on your circumstances.

Learn More

Funded Redundancy Training

Funded Redundancy Training

Are you about to be made redundant or have you been made redundant in the last three months? 100% funded training is available.

Learn More

Email Updates

Email Updates - Join Our Mailing List

Join our mailing list to keep updated on exclusive offers and latest news on our training courses.

  • ECDL
  • ECDL Advanced
  • Approved Test Centre
  • Skills for Industry

  • Computeraid Ltd, 4th Floor, 11 Wind Street, Swansea, SA1 1DP

  • Telephone: 01792 610550 / 029 2066 4285
  • [email protected]
Join Computeraid Ltd on Facebook
Follow Computeraid Ltd on Twitter
Tweets by @ComputeraidLtd
View Dizzee Designs on LinkedIn

Computeraid Ltd

Computeraid Ltd – LinkedIn

Computeraid is the largest supplier independent computer training and consultancy company in South Wales, training around 20,000
people days annually.

Swansea. South Wales