Microsoft Access Upgrading to 2007

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