Date(s) - 01/01/2050
The Quill Consultancy
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.
It is assumed you have attended our introductory Access course (or similar) or have the equivalent knowledge.
At Course Completion
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.
review of database design and creation techniques
review of table, query, form and report design
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