|
Training materials for::
Windows Vista
Windows 2000 / XP
Microsoft Word
Microsoft Excel
PowerPoint
Microsoft Access
Internet
Explorer
Outlook
Microsoft Project
Microsoft Publisher
Microsoft FrontPage
Microsoft Visio
 Expression
Web
Computer
Concepts
ECDL / ICDL
Downloads
PLUS MANY MORE ...
|
Microsoft Access 2007 Courseware
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
Other Microsoft Office 2007 Courseware materials
|
