Menu
  1. Home
  2. Microsoft
  3. Microsoft
  4. Certified
  5. MS Access Database Advanced Course, Private 1-to-1, Live Virtual Classroom
Enquire Now

MS Access Database Advanced Course, Private 1-to-1, Live Virtual Classroom

Study Method
Online
Institution
PCWorkshops
Start Date
Enrol anytime

Course overview

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.

Expand all and read more

Study method

  • Online
  • Blended
  • In-class
xo-logo

coursesonline.co.uk customers are now eligible to apply for an XO Student Discount Card.

Enrol in a course today to unlock exclusive deals.

Duration study load

  • 2 Days

Course features

  • MS Access Advanced course certificate on completion (assessment based)
  • MS Access Advanced course notes
  • Practical MS Access Advanced course exercises, MS Access Advanced course homework/MS Access Advanced course revision work
  • To assist after the course, 1 free session for questions online MS Access Advanced course via Skype or Teamviewer

Subjects

Units
Advanced Data Management
  • Database Design: Planning the Database and its Purpose
  • Referential Integrity
  • Creating Tables, Data Types, 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
Want more information about the subjects for this course?
Get the course guide

Payment options

Course fees – £380

  • No government funding available for this course
Find out more about the payment options for this course
Get the course guide

About PCWorkshops

PCWorkshops mission is to be an integral partner to companies who up-skill and cross-skill their software and data staff.

We are based in London, Milton Keynes, Southend-On-Sea, Birmingham, Portsmouth and Manchester.

Our clients are in a variety of industries, e.g. e-commerce companies,
finance companies, insurance companies, software and technology companies and more.