Course not currently available
Microsoft Access Upgrading to 2007
Short course
In Horsham ()
Description
-
Type
Short course
There are a lot of new enhancements that add to Access 2007 experience. The new interface, combined with a lot of little improvements here and there, really do make for a more polished experience. A variety of new templates as well as solid support for older Access files will help the seasoned Access user become comfortable with Access 2007 quickly. Suitable for: This course is aimed at users of Access who require a greater knowledge of the application and have previously used Access.
Reviews
Subjects
- Microsoft Access
Course programme
Overview
There are a lot of new enhancements that add to Access 2007 experience. The new interface, combined with a lot of little improvements here and there, really do make for a more polished experience. A variety of new templates as well as solid support for older Access files will help the seasoned Access user become comfortable with Access 2007 quickly. A new user can pick it up very quickly and an experienced user will find it a bit faster to use and slightly familiar. It's very easy to customize a central toolbar (called the Quick Access Toolbar) which lets you add any command at any time to a toolbar that you can always see! The new styles, fonts, WordArt, and overall polished visuals make your screen a nice thing to look at.
Course objectives
The course is designed to give delegates a better understanding of Access. It concentrates on the features of Access that provide a smoother interface between user and database, in particular, using forms and macros to automate database operations. By the end of this course you will have learned
- How to use calculations in queries
- How to change a query type and use functions in queries
- How to set defaults for forms
- How to design advanced combo and list boxes
- How to use option groups
- How to create a subform
- How to enter expressions in reports
- How to create subtotals
- How to design macros
- How to add macro buttons to forms
- How to group macros; conditional macros
- How to assign macros to events
Who should attend and Pre-requisites
This course is aimed at users of Access who require a greater knowledge of the application and have previously used Access.
Course synopsis
- Queries; using calculations; changing a query type; using functions in queries
- Forms Setting properties for forms; setting defaults for forms; advanced combo and list boxes; use of option groups; calculated controls; creating a main form / subform; linking forms
- Macros Designing macros; macro actions; adding macro buttons to forms; grouping macros; conditional macros; assigning macros to events
- Toolbars and Menus Customising toolbars; creating custom toolbars; customising menus; creating custom menu bars; attaching menus and toolbars to forms; customising startup
- Reports Entering expressions in reports; creating subtotals; using queries to produce reports; adding objects to reports
Microsoft Access Upgrading to 2007