Advanced Microsoft Access XP/2003 Course
- Duration:2 Days
- Cost:On request
- Ref:ADA
Become a master of Access databases - make them work for you, not the other way round!
Who is it for
Experienced users of Access (Windows 2000 or XP versions) or those with specific Access issues they would like help with. This course is ideal for anyone who has completed the Introduction to Microsoft Access course.
Not sure if this course is the right level for you? Why don't you take our quick online test to find out >
Prerequisites
A working knowledge of Access introduction topics or attendance to our Introduction to Access course.
What is it about
Access databases can be challenging even to experienced users - this course delivers expert advice to help you get the most out of your database, as well as integrating it with other office applications.
Course Overview
- Using queries to update and delete records
- Preparing archive queries
- Testing cascading updates and deletes
- Find duplicate records queries
- Find unmatched records queries
- A review of macros
- Macro writing: Actions, arguments, conditional testing, attaching to events, design window, invoking from another macro
- Keys, menus etc. Using macros with forms for entry, updating and deleting
- Setting form values via a macro
- Debugging macros. Access integration. Object Linking and Embedding (OLE)
- Adding graphics to forms and reports
- Excel and OLE, Word and OLE
- Database performance issues
- Indexing, data types
- Computed fields versus stored fields
What will I get out of it?
At course completion you will be able to write secure queries for the purpose of handling batch updates and deletions for your database. You will have had the opportunity to write macros that run queries, make decisions at run time, are invoked by activating windows, from another macro and a menu etc. Macros will also be used to control forms e.g. selecting and sizing, adding a record etc. Further time will be spent reviewing and discussing integration with applications such as Excel and Word. Finally, you will be made aware of areas of any database application that may impact performance and advice will be given on how you may improve performance.
Accredited by
