Display & Accessibility Options
Access 2010 Advanced
Microsoft Office 2010
 Next available Norwich date: 06 July 2012   |
Course Aims:
This course is designed to provide delegates with the knowledge and skills needed to handle the advanced features of Access 2010.
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 2010 Intermediate course.
Version:
Microsoft Office 2010
Profile Outline:
Automation
- Collecting data by email
- Command buttons in forms
- Command button properties
- Linking forms with buttons
- Using popup forms
- Finding records by combo box
Macros
- Creating macros
- Macro command categories
- Macro commands & arguments
- Running a macro
- Attaching to command buttons
- Editing a macro
- Macro groups
- Conditional macros
Events
- 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
- Command line options
- Trusted locations
- Backup and restore databases
Multi-User Databases
- Shared Databases
- Record states
- Setting Default Locking Properties
- Encryption and password protection
- Splitting an Access Database
- Changing the location of the back-end database
- Making an ACCDE file
- Distributing the application
DO NOT DELETE THIS TEXT
Profile Details:
-
Price: £165.00 
Duration: 1 day- Rating:
Print Page
Norwich Dates:
-
06 July 2012
Links:
People who attended this course, also booked:
Information & print:
