Microsoft Access VBA Training

Vantage Training Ltd (vtl)
4.4
48 reviews
  • The course filled in the crevices in my learning and addressed my questions. The coach, Stuart was useful and quiet. We truly felt delighted during the day and thought that it was exceptionally helpful. We would have no dithering in utilizing Vantage again for the skill enhancement.
    ← | →
  • The course kept running at a decent pace, the mentor was exceptionally tolerant and permitted you to attempt before getting included. I wasn't anticipating the preparation yet delighted in it in particular.
    ← | →
  • The chance to make my own particular equations and take in a great deal about them. Probability of applying what I have realized. Better than average course. Much obliged to you.
    ← | →

Short course

In Nottingham and Timperley

£ 190 + VAT

The best Access courses

See all

See all

Description

  • Type

    Short course

  • Level

    Advanced

  • Location

    At 2 venues

  • Duration

    1 Day

  • Start date

    Different dates available

With basic skills and some experience of Microsoft Access, the topics covered on this course will help you to enhance your relational database.

Facilities

Location

Start date

Nottingham (Nottinghamshire)
The Wharf, Trent Lane, East Bridgford,, NG13 8PF

Start date

Different dates availableEnrolment now open
Nottingham (Nottinghamshire)
The Wharf, Trent Lane, East Bridgford,, NG13 8PF

Start date

On request
Timperley (Cheshire)
See map
Canal Road, WA14 1TD

Start date

Different dates availableEnrolment now open

About this course

What will I expect to achieve at the end of the training?
At the end of this course
you will be able to:

Understand the 'languages' behind the scenes -including SQL and VBA.
Automate actions using macros and simple Visual Basic procedures.
Manipulate data for reports, either within Access or by outputting to other Office applications.
Understand the Access security model and the implications for protecting your data and application.

With basic skills and some experience of Microsoft Access, the topics covered on this course will help you to enhance your relational database.

It is assumed that you have a skill level equivalent to that gained through attending the intermediate Access training.

vtl attendance certificate

Vantage Training Ltd courses, are designed focusing on getting the best out of Access, interactive hand-on training – with practical exercises. We have been delivering high quality training to our customers for over 20 years. All course delegates are given a mouse-mat, pen and course manual to take away…plus 30 days post training support by telephone or email.

After enquiring about our IT courses, we will email you with the relevant course outline, course prices and date options. After agreeing a mutually convenient course date, we will send you a course booking form. When you have completed and returned your course booking form, we will send you your course joining instructions as confirmation of your booking.
After the course we will ring or email you to check that you are happy with your course and then send you your invoice, which is due within 30 day payment term.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.4
fantastic
  • The course filled in the crevices in my learning and addressed my questions. The coach, Stuart was useful and quiet. We truly felt delighted during the day and thought that it was exceptionally helpful. We would have no dithering in utilizing Vantage again for the skill enhancement.
    ← | →
  • The course kept running at a decent pace, the mentor was exceptionally tolerant and permitted you to attempt before getting included. I wasn't anticipating the preparation yet delighted in it in particular.
    ← | →
  • The chance to make my own particular equations and take in a great deal about them. Probability of applying what I have realized. Better than average course. Much obliged to you.
    ← | →
100%
4.4
fantastic

Course rating

Recommended

Centre rating

Lyndy Cox

4.0
09/11/2016
What I would highlight: The course filled in the crevices in my learning and addressed my questions. The coach, Stuart was useful and quiet. We truly felt delighted during the day and thought that it was exceptionally helpful. We would have no dithering in utilizing Vantage again for the skill enhancement.
What could be improved: Everything OK.
Would you recommend this course?: Yes

Anonymous

5.0
30/10/2016
What I would highlight: The course kept running at a decent pace, the mentor was exceptionally tolerant and permitted you to attempt before getting included. I wasn't anticipating the preparation yet delighted in it in particular.
What could be improved: No negative aspects.
Would you recommend this course?: Yes

Yulia Lewis

5.0
30/10/2016
What I would highlight: The chance to make my own particular equations and take in a great deal about them. Probability of applying what I have realized. Better than average course. Much obliged to you.
What could be improved: N/A.
Would you recommend this course?: Yes

Hannah Boylin

5.0
30/10/2016
What I would highlight: Chance to have a go! Magnificent course -obliged.
What could be improved: N/A.
Would you recommend this course?: Yes

Richard Clark

4.0
30/10/2016
What I would highlight: Covering significant points that can be connected to genuine information.
What could be improved: Nothing bad.
Would you recommend this course?: Yes
See all
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 15 years

Subjects

  • Database training
  • Microsoft Access
  • VBA (Microsoft Access / Office)
  • Access
  • Access Control
  • Database
  • Data Collection
  • Database Design
  • Data Management
  • Microsoft Access VBA Training
  • Microsoft Access VBA course

Teachers and trainers (1)

Gill Lewis

Gill Lewis

Technical Trainer

20+ years experience of training delivery. Manages a team of trainers and application developers with similar skills. Extensive programming experience using Microsoft Office based applications usually requiring Visual Basic programming. Designed, managed, and delivered corporate training roll-outs for several companies, including Astra Zenica, and Unilever. Responsible for initial training needs analysis, training delivery, through to effective evaluation and post training support. Providing training solutions for a variety of industries, public sector, and educational establishments.

Course programme

Content

Database Structure
Review of the elements of an Access database and the importance of table relationships.


Advanced Querying
Grouping in queries.
Creating cross-tab queries.
An introduction to the SQL (Structured Query Language) behind queries.
Creating & using Union queries.


Linking Tables/Importing & Exporting
Importing data and structures from other database applications.
Linking data to other database applications.
Exporting data to Microsoft Word and Excel.


An Overview of Macros & Modules
Explaining the differences and benefits of Macros and VBA Modules.
Creating macros to assist users with navigation through an application and other routines.
Assigning macros to buttons and designing end-user forms.
An introduction to the VBA programming power within Access modules.
Reading and writing simple procedures with and without Wizards.


Database Security
An overview of the security model and its application.
Understanding object permissions and ownership.
Setting a database password.
Setting up User and Group accounts.
Changing User and Group Permissions.
Starting your application using workgroups.


Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.

See related categories

Microsoft Access VBA Training

£ 190 + VAT

The best Access courses

See all

See all