Microsoft Access

Microsoft Access is the industry-leading database and is used to store information.
This can be anything from a backup of your address book to a list of your small businesses stock and clients.
We offer some of the best Microsoft Access courses in London. The topics covered include:

Microsoft Access Courses: Morning

• Making Simple Tables
  
• Simple Forms
  
• Simple Reports
  
• Simple Queries
  
• The Primary Key
  
• Parameter Query
  
• Lookup
  
• Formatting Forms & Reports
  
• Report Sub Totals

Microsoft Access Courses: Afternoon

• Sorting
  
• Delete queries
  
• Make Table Query
  
• Append queries
  
• Queries To Group And Sum
  
• Multiple Tables, Referential Integrity.
  
• Inner Joins and Outer Joins
  
• To make an Access Macro
  
• Macros To Open Reports And Forms
  
• The If Function

Note: When practising you can work on a problem associated with your own business.

Private training:

A student who has some knowledge already of Access may benefit more from 2-3 hours of individual lessons. In that time advanced topics eg multiple tables, macros, sub forms etc can easily be covered.

Given time it would also be possible to consider any job-specific database requirements that a student has.

2003 or 2007?

Both Access 2003 and 2007 although 2003 predominates. If only 2007 is required, please let us know.