Intermediate Access

Learn how to create more sophisticated database systems and enhance your existing skills. A basic working knowledge of Access is assumed.

Benefits to you and your organisation
• improved knowledge of Access
• the ability to enhance existing database systems
• the ability to produce automated menu/reporting systems

Key features
• database design
• designing tables
– general table design
– field properties
– using field properties for protection
– using field properties to improve performance
– table relationships
– relationship types
– using lookups for referential integrity
• data import/export
• queries
• forms – using AutoForm to design forms, using Wizards
  to design forms, making enhancements to form
  designs, and object properties
• reports
• databases, intranets and the Internet

Dates and location
21 – 22 August, 25 – 26 September, 16 – 17 October, 22 – 23 November (each session runs from 09.30 to 16.30 and is held in London)

NB This course uses the current version of the software. Previous versions can also be taught.