Call us on 01732 897511
01732 897511
Thursday 9th February 2012
Microsoft Access Advanced
Who is this recommended for?
Delegates should have basic keyboard and mouse skills and be familiar with working in the Windows environment. A very sound background of building Access database through attendance of the Microsoft Access Introduction and Intermediate courses or equivalent experience is essential.
What will you learn?
Course Objectives
- To build interfaces around database objects allowing others to use the database as an application
- To manage and maintain a database application
- To understand the position of Access in the workplace and plan for the future
Course content
Advanced Forms Design
- Adding Combo Box, List Box and Option Button Controls
- Creating Calculated Fields
Macros
- Revision of Basic Macros
- Using Macros to build a User Interface
- Macro Actions and Arguments
- Assigning Macros to Events
- Named Macros
- Adding Conditions to Macros
- Stepping through Macros
Custom Menus
- Using Menus to Build a User Interface
- Creating a Custom Menu
- Attaching Macros to Menus
- Attaching Menus to Forms and Reports
Administering Access
- Compacting and Repairing a Database
- Setting a Database Password
- Using the Linked Table Manager
- Documenting a Database
Where to go from here?
- Access Database Limitations
- Database Security
- Replication
- Upsizing
- Visual Basic for Applications (VBA)
Dates for this course
Please contact the team for dates of this course
