Access 2003 Level 2

Cost: $880.00   Duration: 2 days

Prerequisite
Attendance at Level 1 course or equivalent experience.

Objective
To provide a thorough understanding of higher level Access functionality that will enable the participant to effectively use Access.

Methodology
Group and individual instruction, hands on practical exercises, visual aids, comprehensive course documentation.

At Drake Training, we've made it easier for students to complete their Microsoft applications training by combining
all versions into one single session.

Users of the various Microsoft 2000, XP and 2003 applications will find that our courses prepare them to use all three products, which also means that our courses run more frequently since individual versions are not run in isolation. Our Office courses are also aligned to Microsoft Office Specialist certifications.

Content:

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