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.