Supercharge your skills on MS Access Database
PCWorkshops

MS Access Database Advanced Course

5.0 excellent 5 opinions
PCWorkshops
In London

£900
VAT exempt
Prefer to call the centre directly?
77843... More
Want to speak to an Advisor about this course?

Important information

Typology Short course
Level Advanced
Location London
Duration 2 Days
Start Different dates available
  • Short course
  • Advanced
  • London
  • Duration:
    2 Days
  • Start:
    Different dates available
Description

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

Facilities (1)
Where and when
Starts Location
Different dates available
London
8 Duncannon Street, WC2N 4JF, London, England
See map
Starts Different dates available
Location
London
8 Duncannon Street, WC2N 4JF, London, England
See map

To take into account

· What are the objectives of 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

· Who is it intended for?

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

· Requirements

Experience in MS Access database

· What marks this course apart?

Private 1-to-1

Questions & Answers

Ask a question and other users will answer you

Opinions

5.0
excellent
Course rating
100%
Recommended
5.0
excellent
Centre rating

Reviews on this course

S
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
Did this opinion help you? Yes (0)
O
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
Did this opinion help you? Yes (0)
V
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
Did this opinion help you? Yes (0)
K
Kelinner Franba
5.0 21/07/2016
What I would highlight: I had a great day learning, the office was a bit small and I didn't expect to come to such a place but apart from that the teaching is great, the course material was good too.
What could be improved: -
Would you recommend this course?: Yes
Did this opinion help you? Yes (0)
S
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
Did this opinion help you? Yes (0)
Reviews gathered by Emagister & iAgora

Achievements for this centre

2018

How do you get the CUM LAUDE seal?

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

What you'll learn on the course

Access
Database Design
Database
SQL
Database training
Reports
Data Types
Forms
Queries
Access
Access
Access Macros
Access Macros
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

Students that were interested in this course also looked at...
See all