Display & Accessibility Options
Access Advanced
Microsoft Office 2000, 2002, 2003
 Next available Norwich date: 24 September 2010   |
Course Aims:
This course is designed to provide delegates with the knowledge and skills needed to handle the advanced features of Access.
In particular, delegates will learn how to customise and automate their database application through the use of command buttons, macros, events and Switchboard Manager.
Assumed Knowledge:
Delegates must have a good working knowledge of Access. They must be regular users who have built Access databases. They must be able to create and maintain tables, forms, queries and reports. It is an advantage to have attended the Jarrold Training Access Intermediate course.
Versions:
Microsoft Office 2000, 2002 or 2003
Special Offer
Book one person onto the Access Intermediate and Access Advanced course and receive £30 off the total price.
Profile Outline:
Automation
- Command buttons in forms
- Command button properties
- Linking forms with buttons
- Using PopUp forms
- Finding records by combo box
Macros
- Creating macros
- Macro commands & arguments
- Running a macro
- Attaching to command buttons
- Editing a macro
- Macro groups
- Conditional macros
Events
- The stages of a record
- Event properties of a form
- Event properties of a control
- Attaching macros to events
- Using events to set properties
- Using Expression Builder
Other Queries
- Unique values
- Re-query to update a combo box
- Query by form
- Top values queries
- Summary & grouping queries
Action Queries
- Make table queries
- Append, delete & update queries
- Hide/show queries
The Finished Application
- Using Switchboard Manager to build a Switchboard
- The Autoexec macro
- Access Startup options
- Disabling user access
- Running from a desktop shortcut
Multi-User Databases
- Shared Databases
- Setting Default Locking Properties
- Creating Groups and Users
- Setting User Permissions
- Assigning Ownership
- Splitting an Access Database
- Changing the Location of the Back-end Database
DO NOT DELETE THIS TEXT
Profile Details:
-
Price: £165.00 
Duration: 1 day
Norwich Dates:
-
24 September 2010
Links:
People who attended this course, also booked:
Information & print:
