Microsoft Access Advanced Training

Vantage Training Ltd (vtl)
4.3
60 reviews
  • I personally enjoyed the small number of trainees in attendance, which allowed for a personal approach. The room was very comfortable.
    ← | →
  • The tutor was fantastic, I would like to book another course with the same person.He gave extra help when needed. I learnt more than I thought I would and really enjoyed the course.
    ← | →
  • The course was perfect for the team and to expand their abilities. If there is any IT Training we think we could benefit from and fits into the budget in the future, you are definitely our first port of call.
    ← | →

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

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

Start date

Different dates availableEnrolment now open
Timperley (Cheshire)
See map
Canal Road, WA14 1TD
Timetable: 09:30 - 16:30

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.

What do I need to know before attending?

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.3
fantastic
  • I personally enjoyed the small number of trainees in attendance, which allowed for a personal approach. The room was very comfortable.
    ← | →
  • The tutor was fantastic, I would like to book another course with the same person.He gave extra help when needed. I learnt more than I thought I would and really enjoyed the course.
    ← | →
  • The course was perfect for the team and to expand their abilities. If there is any IT Training we think we could benefit from and fits into the budget in the future, you are definitely our first port of call.
    ← | →
100%
4.4
fantastic

Course rating

Recommended

Centre rating

Blake Smith

0.0
14/04/2017
What I would highlight: I personally enjoyed the small number of trainees in attendance, which allowed for a personal approach. The room was very comfortable.
Would you recommend this course?: Yes

Chanelle Ontal

4.5
02/03/2017
What I would highlight: The tutor was fantastic, I would like to book another course with the same person.He gave extra help when needed. I learnt more than I thought I would and really enjoyed the course.
Would you recommend this course?: Yes

Former Student

5.0
21/02/2017
What I would highlight: The course was perfect for the team and to expand their abilities. If there is any IT Training we think we could benefit from and fits into the budget in the future, you are definitely our first port of call.
Would you recommend this course?: Yes

Eleonora R

4.5
20/02/2017
What I would highlight: All the team found it interesting and useful. The course was well presented, very concise and clear in delivery and well structured. The course leader was patient and helpful and no one felt left behind.
Would you recommend this course?: Yes

Carol Rhodes

5.0
09/11/2016
What I would highlight: Splendid course to study, truly supportive and learnt a great deal, I will put what I have learnt into practice.
What could be improved: Everything was positive.
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
  • Security
  • Microsoft Word
  • Accounts
  • Excel
  • Programming
  • Database
  • Data Collection
  • Access
  • Access Control
  • Database Design
  • Data Management

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 Advanced Training

£ 190 + VAT

The best Access courses

See all

See all