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?

In this course, you will extend your knowledge of some of the most specialised and advanced capabilities within Microsoft Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports and maintaining a database.

 

Course Content

Module One:

Understanding Properties Building forms, forms based on joined tables, automating data entry using grouped controls, enhancing the user interface, sub-forms, changing tab order, inserting the date and time into a form header

Module Two:

Create a PivotTable, modify a PivotTable, working with a PivotChart

Module Three:

Creating and running macros, attaching macros to events, macros and database objects

Module Four:

Macros to provide user interaction, user decision defined macros, using auto keys, auto exec macros

Module Five:

Working with hyperlink fields

Module Six:

Protecting databases and user level security

 

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