1 2 3 4

Access Intermediate

Loading Map....

Date/Time
Date(s) - Enquire Now


All Day

Location
The Quill Consultancy

Categories


This two-day course is appropriate if you have a sound knowledge of Access. You should be familiar with setting up a multi-table database, creating relationships between tables and developing queries, forms and reports. This course will give you the skills and knowledge required to create and distribute more sophisticated Access applications that are intended for others to use.

Prerequisite skills/knowledge:
It is assumed you have attended our introductory Access course (or similar) or have the equivalent knowledge.

Topics include:

  • review of database design and creation techniques
  • review of table, query, form and report design
  • database documentation
  • using the Expression Builder
  • creating switchboard forms
  • enhancing Access forms
  • an introduction to programming in Access VBA
  • creating a custom menu
  • enhancing Access reports
  • using Access security

At the completion of the course you should have gained a better understanding of the techniques required for developing more sophisticated databases incorporating menu switchboards, smarter forms and reports, custom menus and Access security.