Microsoft Access 2007 Advanced

Form Customisation In Access 2007

- 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 In Access 2007

- Popup forms
- Modal forms
- Split forms

Limiting User Access In 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

Reports In Access 2003

- 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 Switchboards In Access 2007

- 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

Customising Access In Access 2007

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