Microsoft Access Intermediate Training

4.4
31 reviews
  • Enhanced my aptitudes on utilizing Excel.
    |
  • It secured every minute details in one day.
    |
  • I observed the course to be all around organized, conveyed in an intriguing path, and to be helpful. Great enjoyment.
    |

Short course

In Timperley and Nottingham

£ 190 + VAT

Description

  • Type

    Short course

  • Level

    Intermediate

  • 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 intensive course will help you to develop the power of your relational databases.

Facilities

Location

Start date

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:

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

Enhance your Access databases by developing selective queries and action queries.
Automate simple tasks using controls in forms.
Create subforms and subreports.
Sort group and calculate aggregate values in reports.
Create a customised startup menu.

With basic skills and some experience of Microsoft Access, the topics covered on this intensive course will help you to develop the power of your relational databases.

What do I need to know before attending?

It is assumed that you have a skill level equivalent to that gained through attending the introductory 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
  • Enhanced my aptitudes on utilizing Excel.
    |
  • It secured every minute details in one day.
    |
  • I observed the course to be all around organized, conveyed in an intriguing path, and to be helpful. Great enjoyment.
    |
100%
4.4
fantastic

Course rating

Recommended

Centre rating

Julie Turner

4.5
09/11/2016
What I would highlight: Enhanced my aptitudes on utilizing Excel.
What could be improved: Nothing.
Would you recommend this course?: Yes

Andrew Beardmore

5.0
30/10/2016
What I would highlight: It secured every minute details in one day.
What could be improved: Everything was positive.
Would you recommend this course?: Yes

Robert Williams

3.5
30/10/2016
What I would highlight: I observed the course to be all around organized, conveyed in an intriguing path, and to be helpful. Great enjoyment.
What could be improved: Nothing.
Would you recommend this course?: Yes

Eloise Henesey

5.0
28/10/2016
What I would highlight: The course contained important substance, gave me the chance to hone, the teacher was persistent and extremely proficient.
What could be improved: N/A.
Would you recommend this course?: Yes

Dave Kitchen

5.0
14/10/2016
What I would highlight: Easy to comprehend in addition to right pace.
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

  • Basic IT
  • Microsoft Access
  • Database training
  • Design
  • Access
  • Access Control
  • Database
  • Data Collection
  • Data Management
  • Database Design

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.
Understanding Indexes.


More on Queries
Reviewing the basics of SELECT Queries.
Using parameters as selection criteria.
Creating ACTION queries to perform automatic updates, archive and deletion of records.


More on Forms
Reviewing basic form creation.
Using controls such as Combo-Boxes to enhance forms.
Calculating simple expressions.
Using forms to provide selection criteria for queries.
Creating sub-forms.


More on Reporting
Reviewing basic reports design.
Using sorting and grouping in reports.
Calculating aggregate values, like totals and averages.
Using sub-reports.


Creating Menus
Introducing the Navigation options to design basic menus.
Startup menu options.


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

Microsoft Access Intermediate Training

£ 190 + VAT