Microsoft Access Introduction Training

Vantage Training Ltd (vtl)
4.4
28 reviews
  • Incredible course, truly helped me enhance my Excel aptitudes. The guide was extremely kind and supportive.
    ← | →
  • It was extremely useful and there was a decent learning environment.
    ← | →
  • It was truly useful, due to there being extra backing on required ranges.
    ← | →

Short course

In Nottingham and Timperley

£ 190 + VAT

The best Access courses

See all

See all

Description

  • Type

    Short course

  • Level

    Beginner

  • Location

    At 2 venues

  • Duration

    1 Day

  • Start date

    Different dates available

As a new user, with little or no experience of Microsoft Access, the topics covered on this course introduce you to the main concepts involved in creating and maintaining a simple 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

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:

Create a basic database structure.
Create standard forms for inputting and amending your data.
Use simple queries to manipulate your data.
Produce basic Access reports.

As a new user, with little or no experience of Microsoft Access, the topics covered on this course introduce you to the main concepts involved in creating and maintaining a simple relational database.

It is assumed only that you have a basic knowledge and understanding of the Windows environment.

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
  • Incredible course, truly helped me enhance my Excel aptitudes. The guide was extremely kind and supportive.
    ← | →
  • It was extremely useful and there was a decent learning environment.
    ← | →
  • It was truly useful, due to there being extra backing on required ranges.
    ← | →
100%
4.4
fantastic

Course rating

Recommended

Centre rating

Katie Birchall

4.0
09/11/2016
What I would highlight: Incredible course, truly helped me enhance my Excel aptitudes. The guide was extremely kind and supportive.
What could be improved: No negative aspects.
Would you recommend this course?: Yes

Amy Franklin

5.0
30/10/2016
What I would highlight: It was extremely useful and there was a decent learning environment.
What could be improved: Nothing bad.
Would you recommend this course?: Yes

Amy Franklin

5.0
30/10/2016
What I would highlight: It was truly useful, due to there being extra backing on required ranges.
What could be improved: Nothing bad.
Would you recommend this course?: Yes

Amy Franklin

3.5
28/10/2016
What I would highlight: It was a decent presentation that was conveyed well, the issues I had were resolved.
What could be improved: Everything OK.
Would you recommend this course?: Yes

Nicola Bicknell

5.0
14/10/2016
What I would highlight: What I preferred most about the course was the snappy tips and a few essentials that will spare my time. Little gathering, so could concentrate on us and zones we wished to see a greater amount of. Contented with the manuals we got to bring home and invigorate what we have learnt.
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
  • Database Design
  • Data Collection
  • Data Management
  • Access
  • Access Control
  • Microsoft Access
  • Data analysis
  • Microsoft Access Training
  • Microsoft Access Introduction training

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

Introducing Access
An overview of the power and benefits of computer databases.
Terminology.
Tour of the Access initial screen.
The Ribbon and other toolbars.

Data Entry & Editing
Adding and editing records.
Navigation through data.
Finding specific records.
Sorting and filtering data.

Tables
Creating tables.
Setting field attributes.
Importing from Excel.

Relational Databases
What they are and why relational databases are useful.
How data stored in different tables can be related.

Queries
Using SELECT Queries to build new record sets.
Sorting and basic filtering.
Deriving new information in queries.
Combining data from different tables through a query.

Forms
Creating forms with and without the Access Forms Wizard.
Using queries and tables as the basis for forms.
Introducing object properties within forms to change data and display characteristics.

Reporting
Creating simple reports with and without the Access Reports Wizard.
Introducing object properties within reports to change report definitions.

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

£ 190 + VAT

The best Access courses

See all

See all