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
Thursdays:
26 October
Monday Evening:
25 Sept 2017
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: £70 per hour. (Student rate may apply).
2007 or 2010 or 2013?
Access 2010 predominantly (Access 2007 and 2013 are very similar and any differences will be demonstrated).