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:
9 August
13 September
11 October
Sat :
14 August
Monday Evening
9 August
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 2003 predominates. If only 2007 is required, please let us know.