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

Mon 30th Oct
11:00am - 6:00pm

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

£290.00 17% off
£240.7
per course

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

Mon 30th Oct
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£290.00 17% off
£240.7
per course

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

Mon 30th Oct
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£290.00 17% off
£240.7
per course

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

Tue 31st Oct
11:00am - 6:00pm

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

£290.00 17% off
£240.7
per course

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

Tue 31st Oct
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£290.00 17% off
£240.7
per course

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

Tue 31st Oct
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£290.00 17% off
£240.7
per course

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

Wed 01st Nov
11:00am - 6:00pm

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

£290.00 17% off
£240.7
per course

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

Wed 01st Nov
11:00am - 6:00pm

1 day
Full time
Milton Keynes,
MK9 2UB
Map

£290.00 17% off
£240.7
per course

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

Wed 01st Nov
11:00am - 6:00pm

1 day
Full time
London,
WC2N 5BY
Map

£290.00 17% off
£240.7
per course

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

Thu 02nd Nov
11:00am - 6:00pm

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

£290.00 17% off
£240.7
per course

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