Microsoft Access 2007
Advanced Level Training Course

FORMS

• Linking a form to a table
• Placing controls on the form
• Lining controls on a form
• Sizing to fit controls on a form
• Special effects
• Setting tab order
• Bound controls
• Check boxes
• Command buttons
• Group boxes
• Combo boxes
• List boxes

TYPES OF FORMS

• Popup forms
• Model forms
• Split forms

LIMITING USER ACCESS

• Limit user from adding new records, deleting existing records & editing a records

EXPORTING FORM TO XML

• Exporting to XML

CUSTOMISING REPORTS

• Creating a report
• Creating an Auto format template
• Applying an Auto format to a report
• Conditional formatting
• Sub reports
• Formatting reports

ACCESS SWITCHBOARDS

• Switchboards

USING THE SWITCHBOARD MANAGER

• Creating a switchboard
• Adding a switchboard
• Deleting a switchboard
• Editing a switchboard
• Adding an Items in the Switchboards
• Deleting an Items in the Switchboards
• Editing an Items in the Switchboards
• Customizing Items in the Switchboards
• Making a Switchboards as a default switchboard
• Displaying a Switchboards automatically upon opening database

CUSTOMISING OPTIONS

• Access options
• Current Database options
• Datasheet options
• Object Designers options
• Proofing options
• Customize options
• Add-ins options

BASICS OF VISUAL BASIC

• Visual basic environment
• What is VBA

VBA EDITOR

• VBA editor
• Accessing VBA editor
• Option Compare Database
• Option Explicit
• Events
• Declaring variables
• Adding code to an object event
• Adding comments to your code
• Using message box
• Error message
• Zoom box
• If condition
• While condition

WHAT IS A MODULE

• Creating a module
• Adding code in the module
• Calling a function in the module

A SAMPLE APPLICATION | ADDRESS BOOK

• Creating the table & a form
• Creating the close button
• Creating a combo box for gender
• Creating the input mask for the DOB control
• Creating the navigation menu
• Creating the Add New button
• Creating a list box
• Customising the Address book