Advanced Microsoft Access
Short course
In Worcester
Description
-
Type
Short course
-
Location
Worcester
-
Duration
1 Day
Design Forms and Subforms from scratch and link them together. Create calculations within Queries. Design Reports from both Queries and from scratch. Suitable for: Clerical and managerial staff who wish to design an Access database without the use of a Wizard and to create their own system of several Forms, Tables, Queries and Reports.
Facilities
Location
Start date
Start date
Reviews
Course programme
Course Overview -Advanced Microsoft Access
This course is intended for anyone who wishes to manipulate a database and understand the design functions in more detail.
Course Format and Duration
This is a tutor led and exercise based course which runs for one day, with a short lunch break. It allows the trainee to be led in group exercises as well as trying tasks out for themselves.
Course Outcomes
This course will equip delegates with the skills and knowledge to be able to:
• Link together previously created forms and subform objects
• Create select queries and use date parameters within them
• Introduce headers, footers and expressions onto a form
• Create command buttons on a form
• Design a report and format it
• Export data from an Access Table
Advanced Microsoft Access