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.

Buy a voucher
Starting How long Where Price

Tue 27th Feb
11:00am - 6:00pm

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

£250
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 27th Feb
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£250
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 28th Feb
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£250
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 06th Mar
11:00am - 6:00pm

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

£250
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 06th Mar
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£250
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 07th Mar
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£250
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 13th Mar
11:00am - 6:00pm

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

£250
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 13th Mar
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£250
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 14th Mar
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£250
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 20th Mar
11:00am - 6:00pm

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

£250
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher