Presentation Style: Tutor-led Classroom
Duration: 2 Days
Course Time: 09:30 - 16:30hrs
Course Location: Northampton
Cost: Public Courses: £480 + VAT per delegate (call for group discounts)
Closed Courses: please enquire

 

What will you learn on this course?

By the end of this course delegates will have gained a greater understanding of the features within Microsoft Access to enhance the efficiency and power of their database applications.

 

Course Content

Module One:

Understanding different types of relationships, one-one, one to many, join types, editing relationships, referential integrity

Module Two:

Cross tab queries, parameter queries, make table queries, delete queries, and append queries, update queries, multi-table queries

Module Three:

Adding graphics, sub forms, calculated fields, combo boxes, toggle buttons, command buttons

Module Four:

Headers and footers, adding controls, sub reports, forcing new pages, using calculative functions in a report

Module Five:

Creating charts in forms, creating charts in reports, modifying charts

Module Six:

Compact and repair, backing up and restoring databases

 

Additional Information

  • Buffet lunch included and free parking (only for courses held at Paradise Training Centre)
  • Joining instructions will be sent prior to attending the course