MS Access Database Advanced 1-Day Course. Online Instructor-led.

MS Access Database Advanced 1-Day Course. Online Instructor-led.

Overview

Master MS Access Database in our Advanced Access Course. Private 1-to-1, Online, Interactive, Instructor-Led, Practical.

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

Our private style tuition helps to maximise the value that each delegate gets from the day.

This course will help you to :

  • structure tables,
  • import and manage your data effectively.
  • Create and amend Advanced Forms
  • Advanced Reports.
  • Macro buttons


Details:

  • All versions offered, request your preference
  • Duration: 1-Day.
  • Instructor-led
  • Customisable
  • Online or At your office


Course Outline

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


Query revision


Forms : Forms Tasks Using Subforms Creating a Navigation Form Restricting Form Entries - controlling input Exporting a Form Other Form Tasks


Reports Creating reports


Access Macros: Creating command buttons, create menu systems


Included:

  • PCWorkshops Certificate on completion
  • Course notes , examples, exercises, Course Homework / Revision work
  • After the Access course, 1 free session for questions via Gotomeeting.com.


Good to know

Highlights

  • 6 hours
  • In-person

Location

PCWorkshops at Regus

Golden Cross House

8 Duncannon Street London WC2N 4jf

How do you want to get there?

Map
Organised by
Report this event

More events from PCWorkshops

Discover more events from PCWorkshops, from Science & Tech to other experiences you might love.

Still looking for the right event?

Explore all events in London and filter by date, category, and more to find the perfect fit.