MS Access Advanced Course


From £630 - FAQ's - Included - Course outline - Bespoke Course

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

Course summary


This course will help you to structure tables, import and manage your data effectively.
MS Access versions 2007 and later, Mac & PC. Mostly covering creating advanced Reports, forms and macros. Our private style tuition helps to maximise the value that each delegate gets from the day.
Create and amend Advanced Forms and Advanced Reports. Macro buttons

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
Brief 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


What is included in this MS Access Advanced Course:


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
Tea, coffees, but no lunch
To assist after the course, 1 free session for questions online MS Access Advanced Course via Skype or Teamviewer.

Is this the course for you? Book today and start preparing for the course

PCWorkshops specialises in Java Courses, Database courses and MS Project Courses.

Free Examples and Tips