Microsoft Access 2007 Courseware Materials
Advanced Level Training Course

Courseware Training Manual

ACCESS 2007 - 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
• Popup forms
• Model forms
• Split forms
• Limit user from adding new records, deleting existing records & editing a records
• Exporting to XML

ACCESS 2007 - CUSTOMISING REPORTS

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

ACCESS 2007 - SWITCHBOARDS

• 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 ACCESS 2007 OPTIONS

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

ACCESS 2007 - VISUAL BASIC

• Visual basic environment
• What is VBA

ACCESS 2007 - 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

ACCESS 2007 - MODULES

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

ACCESS 2007 - 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

Microsoft Office 2007 courseware materials

• Microsoft Access 2007 foundation courseware materials
• Microsoft Access 2007 intermediate courseware materials
• Microsoft Access 2007 advanced courseware materials
• Microsoft Excel 2007 foundation courseware materials
• Microsoft Excel 2007 intermediate courseware materials
• Microsoft Excel 2007 advanced courseware materials
• Microsoft Outlook 2007 advanced courseware materials
• Microsoft PowerPoint 2007 foundation courseware materials
• Microsoft PowerPoint 2007 intermediate courseware materials
• Microsoft PowerPoint 2007 advanced courseware materials
• Microsoft Word 2007 foundation courseware materials
• Microsoft Word 2007 intermediate courseware materials
• Microsoft Word 2007 advanced courseware materials
• Microsoft Project 2007 foundation courseware materials
• Microsoft Publisher 2007 foundation courseware materials
• Microsoft Visio Web 2007 foundation courseware materials
• Microsoft Expression Web 1 foundation courseware materials

       Home | Download Computer Courseware Samples | IT Course Outlines | ECDL / ICDL Courseware Outlines | Site Map | FAQs 
       What's New | Download Sample ECDL / ICDL Training Materials | Newsletter | Contact Cheltenham Courseware | 

           
       © 1995-2008 Cheltenham Courseware Pty. Ltd. All trademarks acknowledged.  Terms & Conditions
       Offices in Europe (UK), USA & Australia (Perth, WA) - Call us    (Course content subject to change without notice.)