Book now

MS Access Database Advanced Course, Private 1-to-1

Course summary

Course Aims (Access 2003, 2007, 2010, 2013, 2016 and Mac)

This course is offered one-to-one, for individual attention to your requirements. This private style tuition helps to maximise the value that each delegate gets from the day.

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.

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

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

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 25th Sep
11:00am - 6:00pm

2 day
Full time
London,
WC2N 5BY
Map

£580
per course

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

Mon 25th Sep
11:00am - 6:00pm

2 days
Full time
Southend-On-Sea,
SS1 1NE
Map

£580
per course

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

Mon 25th Sep
11:00am - 6:00pm

2 days
Full time
Milton Keynes,
MK9 2UB
Map

£580
per course

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

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

2 day
Full time
London,
WC2N 5BY
Map

£580
per course

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

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

2 days
Full time
Southend-On-Sea,
SS1 1NE
Map

£580
per course

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

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

2 days
Full time
Milton Keynes,
MK9 2UB
Map

£580
per course

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

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

2 day
Full time
London,
WC2N 5BY
Map

£580.00 17% off
£481.4
per course

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

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

2 days
Full time
Southend-On-Sea,
SS1 1NE
Map

£580.00 17% off
£481.4
per course

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

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

2 days
Full time
Milton Keynes,
MK9 2UB
Map

£580.00 17% off
£481.4
per course

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

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

2 day
Full time
London,
WC2N 5BY
Map

£580.00 17% off
£481.4
per course

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