|
|
|
Microsoft Access 2007 Courseware
Advanced Level |
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
CUSTOMIZING REPORTS
- Creating a report
- Creating an Auto format template
- Applying an Auto format to a report
- Conditional formatting
- Sub reports
- Formatting reports
ACCESS 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
CUSTOMIZING ACCESS OPTIONS
- Access options
- Current Database options
- Datasheet options
- Object Designers options
- Proofing options
- Customize options
- Add-ins options
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
MODULES
- 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
- Customizing the Address book
|
|
|