MS Access Database Advanced Course

PCWorkshops
5.0
4 reviews
  • Sarah teaches very well. She could explain lots of concepts in different ways and that was really impressive.
    ← | →
  • Thanks to Sarah I am more confident with my access skills and can now do advance stuff that even some of my team members still cannot do.
    ← | →
  • Lots of exercises and the day was just packed with lots of learning - worth the money!
    ← | →

Short course

In Jersey Guernsey (UK Offshore Dependencies)

£ 900 VAT exempt

The best Access courses

See all

See all

Description

  • Type

    Short course

  • Level

    Advanced

  • Location

    Jersey guernsey (UK Offshore Dependencies)

  • Duration

    2 Days

Supercharge your skills on MS Access Database

Become fully proficient with MS Access Database by taking PCWorkshops advanced course and become the Access database expert.

Facilities

Location

Start date

Jersey Guernsey (Channel Islands)
See map

Start date

Different dates availableEnrolment now closed

About this course

This course will help you to structure, import, manage and query your data effectively. Advanced forms. Macro buttons linking forms and Menu systems. Power Queries

Candidates who have gone through PCWorkshops Beginners and Intermediate course or have experience in Access database

Experience in MS Access database

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
  • Sarah teaches very well. She could explain lots of concepts in different ways and that was really impressive.
    ← | →
  • Thanks to Sarah I am more confident with my access skills and can now do advance stuff that even some of my team members still cannot do.
    ← | →
  • Lots of exercises and the day was just packed with lots of learning - worth the money!
    ← | →
100%
5.0
excellent

Course rating

Recommended

Centre rating

Samuel Musini

5.0
08/02/2018
What I would highlight: Sarah teaches very well. She could explain lots of concepts in different ways and that was really impressive.
What could be improved: nothing
Would you recommend this course?: Yes

Olga Makhlonora

5.0
17/09/2016
What I would highlight: Thanks to Sarah I am more confident with my access skills and can now do advance stuff that even some of my team members still cannot do.
What could be improved: -
Would you recommend this course?: Yes

Vanessa Le Grand

5.0
10/08/2016
What I would highlight: Lots of exercises and the day was just packed with lots of learning - worth the money!
What could be improved: .
Would you recommend this course?: Yes

Sarah Harrison

5.0
18/06/2016
What I would highlight: Sarah is an excellent teacher! She made the lesson very fun and it taught me a lot.
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 Design
  • Database
  • SQL
  • Database training
  • Reports
  • Data Types
  • Forms
  • Queries
  • Access Macros

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

Advanced Data Management

  • Database design: planning the database and its purpose
  • Referential Integrity
  • Creating tables, datatypes, primary keys
  • Table Relationships
  • Importing data, and the planning of data migration
  • An Introduction to SQL

Queries

  • Brief Query revision

Forms Tasks

  • Using Subforms
  • Creating a Navigation Form
  • Restricting Form Entries - controlling input
  • Exporting a Form
  • Other Form Tasks

Creating reports

Access Macros

SQL and Microsoft Access

  • Understanding SQL
  • Using the SELECT Statement
  • Using Subqueries
  • Using SQL Joins

See related categories

MS Access Database Advanced Course

£ 900 VAT exempt

The best Access courses

See all

See all