Microsoft Access 2007 Advanced Training Materials
Advanced Level Training Course
Training Course Outline
ACCESS 2007 FORM CUSTOMIZATION
- Linking a form to a table
- Placing controls on the form
- Aligning controls on a form
- Sizing to fit controls on a form
- Special effects
- Setting tab order
- Placing a bound control on the form
- Placing a check box on the form
- Placing a command button on the form
- Placing a group box on the form
- Placing a combo box on the form
- Placing a list box on the form
TYPES OF FORMS INACCESS 2007
- Popup forms
- Modal forms
- Split forms
LIMITING USER ACCESS WITHIN ACCESS 2007
- Limiting users from adding new records
- Limiting users from deleting existing records
- Limiting users from editing a records
EXPORTING FORM TO XML IN ACCESS 2007
- Exporting to XML
ACCESS 2007 REPORTS
- Creating a report
- Creating an AutoFormat template
- Applying an AutoFormat to a report using the Report Wizard
- Applying an AutoFormat to an existing report
- Conditional formatting
- Subreports
- Formatting reports
ACCESS 2007 SWITCHBOARDS
- What is a switchboard?
- Creating a Switchboard
- Adding a switchboard
- Deleting a switchboard
- Adding items to a Switchboard
- Editing a Switchboard
- Deleting items within a Switchboard
- Editing items within a Switchboard
- Making a Switchboard the default Switchboard
- Displaying Switchboards automatically when opening a database
CUSTOMIZING ACCESS 2007
- Customization options
- Current Database options
- Datasheet options
- Object Designers options
- Proofing options
- Customize options
- Add-ins options