Book now

MS Access Database Intermediate Course - Data Analysis with Access Queries, Private 1-to-1

Course summary

Course Aims (Access 2007, 2010, 2013, 2016 and Mac) This course is offered one-to-one, because we understand that indiovuals have varying skill levels and varying applications. This private style tuition helps to maximise the value you get from the day.

Bookings made via Hotcourses will be confirmed by PCWorkshops directly within 24Hours.

Who Should Attend

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

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 forms

Book this course

Choose from the start dates and other options below. Click on each row to get more information. When you have found your ideal combination click "Book now" to proceed.

Starting How long Where Price

Tue 26th Jun
11:00am - 6:00pm

1 day
Full time
Southend-On-Sea,
SS1 1NE
Map

£250
per course

> Book now

Tue 26th Jun
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£250
per course

> Book now

Wed 27th Jun
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£250
per course

> Book now

Online course
You study at your own pace

Variable - to suit the learner
Online
This is an online course
Map

£290
per course

> Book now