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

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.