MS Access Intermediate Course

PCWorkshops
5.0
9 reviews
  • I learnt a lot through the exercises given in class. It was real life examples and that made it perfect because it is easier to relate to which makes it worth your time.
    ← | →
  • Very good course. Sarah follows the course outline in the right order making it easy to follow a long. Her teaching pace was also just right, thank you
    ← | →
  • Fantastic teacher. I feel more confident with my skills
    ← | →

Short course

Online

Save 9%
£ 500 VAT exempt

The best Access courses

See all

See all

Description

  • Type

    Short course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    1 Day

Expand your MS Access skills with this course

The MS Access intermediate course is the next step for anyone looking to further enhance their skills.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course

To understand table relationships and referential integrity. Be capable of making queries such as total queries, expression queries and action queries. Managing data, creating forms and reports.

People who need to do creative and in-depth queries of databases.

Previous experience with MS Access required.

Private 1-to-1

Questions & Answers

Add your question

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

Fill in your details to get a reply

We will only publish your name and question

Reviews

5.0
excellent
  • I learnt a lot through the exercises given in class. It was real life examples and that made it perfect because it is easier to relate to which makes it worth your time.
    ← | →
  • Very good course. Sarah follows the course outline in the right order making it easy to follow a long. Her teaching pace was also just right, thank you
    ← | →
  • Fantastic teacher. I feel more confident with my skills
    ← | →
100%
5.0
excellent

Course rating

Recommended

Centre rating

Rachel Sharp

5.0
08/07/2018
What I would highlight: I learnt a lot through the exercises given in class. It was real life examples and that made it perfect because it is easier to relate to which makes it worth your time.
What could be improved: -
Would you recommend this course?: Yes

Steve Wallace

5.0
01/07/2018
What I would highlight: Very good course. Sarah follows the course outline in the right order making it easy to follow a long. Her teaching pace was also just right, thank you
What could be improved: -
Would you recommend this course?: Yes

Maxwell Knight

5.0
06/01/2018
What I would highlight: Fantastic teacher. I feel more confident with my skills
What could be improved: -
Would you recommend this course?: Yes

Zach Kovacevic

5.0
03/12/2017
What I would highlight: The course contained a lot of exercises and it was very fun to learn a long the way as well as to do these exercises. These weren't your usual exercises, they were related to real life situations which is great to incorporate in to a class.
What could be improved: .
Would you recommend this course?: Yes

Kath McPherson

5.0
12/04/2017
What I would highlight: It was private 1 to 1 and allowed me to focus on what is useful for my objective.
What could be improved: .
Would you recommend this course?: Yes

Harold North

5.0
18/02/2017
What I would highlight: I learnt so much with Sarah, it has helped me so much at work. Thank you!
What could be improved: -
Would you recommend this course?: Yes

Alexandra Schubert

5.0
14/07/2016
What I would highlight: Very glad to learn something new. The teacher was very good at making her explanations clear and simple
What could be improved: nothing
Would you recommend this course?: Yes

Karen Adams

5.0
18/04/2016
What I would highlight: Great teacher, great explanation - worth the money
What could be improved: .
Would you recommend this course?: Yes

Donna Hussain

5.0
09/03/2015
What I would highlight: Learning Access with Sarah has been a very fun experience for me. Not only did I learn a lot from her, I never thought the exercises could be so fun when you understand the concepts. Thank you!
What could be improved: .
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2018

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 7 years

Subjects

  • Access
  • Database
  • Database training
  • Tables
  • Reports
  • Forms
  • Queries
  • Data
  • Database Concepts
  • Data Retrieval

Teachers and trainers (1)

Mary Smith

Mary Smith

Tutor

How Mary Smith teaches: I am consultative, flexible and understanding. I appreciate the trust given to me. What Mary Smith teaches: Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder. Java Coding Basics.

Course programme

Course Outline

Tables

  • Referential Integrity
  • Table Relationships

Queries

  1. Queries
  2. Wildcards
  3. Totals Queries
  4. Expression queries
  5. Action queries:
  • Make Table,
  • Inserting records
  • Append,
  • Update and
  • Delete Queries

Data

  • Importing Data
  • Exporting Data
  • Linking Data

Creating Forms

  • Creating forms, Form wizards
  • Creating a Navigation Form

Creating reports, On-screen and Paper / Pdf based. On screen queries via preprepared form

See related categories

MS Access Intermediate Course

£ 500 VAT exempt

The best Access courses

See all

See all