DT008 - Access 2003 Level 2

This two-day instructor-led intermediate to advanced course will provide students a thorough understanding of higher level Access functionality that will enable the participant to effectively use Microsoft Access 2003 through group and individual instruction, hands-on practical exercises, visual aids, and comprehensive training manuals and materials.

Upon successful completion of this course, students will be able to:

• Restructure data into appropriate tables to ensure data dependency and minimize redundancy
• Write advanced queries to analyze and summarize data
• Create and revise Access macros
• Display data more effectively in a form
• Customize reports by using various Access features, thus making them more effective
• Maintain your database using tools provided by Access

Importing, Linking and Exporting Tables
• Importing Data into Access
• Drag and Drop Import
• Linking Tables
• Modifying Linked Tables
• Importing Vs Linking Tables
• Exporting Data from Access
• ODBC and SQL

Creating Subforms
• About Subforms
• Creating a Subform
• Creating a Main Form
• Placing the Subform on the Main Form

Creating Subreports
• Creating the Subreports
• Inserting the Subreport into the Main Report

Publishing Reports to Word and Excel
• Publishing a Report to Microsoft Word
• Publishing a Report to Microsoft Excel

Creating Mail Merge Reports
• Creating a Mail Merge Using an Access Database

Defacto Naming Conventions
• Sample Bookshop Database
• Defacto Naming Conventions
• Naming of Database Objects
• Naming of Fields

Working with Controls
• Value Lists and Filling Lists
• Dynamic Combo Boxes
• Refreshing Data for a Combo Box
• Creating Option Groups
• Adding an Option Group
• Setting the Tab Order
• Enabling Quick Keys for Controls
• More on Control Properties
• Formatting Text
• Null Values in a Format String
• Enabling and Locking
• Pop-Up Forms
• Modal Forms
• Auto Center

Advanced Form Design
• Working with Bound and Unbound Object Frames
• Displaying Multiple Pages of Information on One Form
• Creating Buttons to Hide and Display Controls
• Creating Custom Templates
• Setting Default Control Properties
• Using a Template

Using the Switchboard Manager
• Using the Switchboard Manager

Creating and Using Macros
• What is a Macro?
• Power Without Programming
• Creating a Macro Using the Command Button Wizard
• Running a Macro
• Creating a New Macro
• Editing a Macro

Assigning Macros to Button and Form Events
• Macros in Forms
• Assigning a Macro to an Event or Button

Working with Macros
• Understanding Events, Properties & Objects
• Referring to Objects and Their Values
• Validating Data
• Assigning the Macro
• Setting Values
• Setting the Property of an Object Using Macros

Macros and Forms
• Synchronising Two Forms to Show Related Records
• Creating an Address Book Macro
• A Graphical Form Interface

Macros and Reports
• Using Forms and Macros to Provide Choices
• Designing an Interactive Report Based on a Form
• Linking the Report to the Form
• Using Macros with Reports

Rounding Off an Application with
• Navigation Aids
• Creating a Custom Menu Bar
• Assigning the Menu to a Form
• Key Assignments in Macros
• Using Toolbars to Provide Choices for Users
• Using Macros to Display the Toolbar

Advanced Expressions and Functions
• The IIF Function
• Useful String Functions
• Working with Dates
• The Date and Time Interval Periods

This course is for students who have a thorough understanding of the basic user features of Microsoft Access, and are interested in learning intermediate to advanced administrator skills. The course is also for the student that may be working in a web-based environment and may need to adapt Access applications to the environment. It is also designed for students pursuing the Microsoft MOS Expert Level Certification for Access 2003.

Completion of Microsoft Access 2003 Level 1 training or equivalent knowledge.