Microsoft Access Courses
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
- More advanced Select queries
- Delete queries
- Make Table Query
- Append queries
- Queries To Group, Sum & Count.
- Multiple Tables, Referential Integrity.
- Inner Joins and Outer Joins
- Subforms
- To make an Access Macro
- Macros To Open Reports And Forms
- Macros to run Queries.
- Introductionto VBA. Why would we need it?
- Introductionto SQL. Why would we need it?
- Practice and Application: It is possible to bring and work on a problems associated with your own business/work.
Cost
£185 per person per day.
Next Courses
Mondays:
12 October
09 November
16 Jan
13 Feb
13 March
23 April
21 May
Sat :
04 February
07 July
29 Sept
Monday Evening
06 February
07 July
29 Sept
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.
Cost: £60 per hour.
2003 or 2007?
Both Access 2003 and 2007 although 2007 predominates. If only 2003 is required, please let us know.