search our courses:
Quick Navigation
Microsoft Access 2007 Advanced course
Download PDF version of Access 2007 Advanced course outline
Overview
This course enables delegates to customise and manage their relational databases more efficiently. This is done through the use of advanced reports, queries and basic macros.
Audience
Delegates who wish to expand their Access product knowledge in order to be able to do more complex tasks.
Course Objectives
At the end of this course, delegates will be able to use advanced techniques such as forms, queries, expressions, macros and customisation to enhance and control their databases.
Prerequisites
Delegates should have attended or be familiar with the content of the Access Introduction course.
Course Contents (2 days)
- Advanced Form Design
- Master Detail form
- Design View
- Bound and Unbound Objects
- Combo & List Boxes
- Calculated Text boxes
- Option Group
- Automatic/Customised Tab Orders
- Header/Footer
- Working with SubForms/SubReports
- Create/Delete
- Datasheet View
- SubForm Total
- Header/Footer
- Action Queries
- Make-Table Query
- Update/Append/Delete Query
- Advanced Query Wizards
- Crosstab Query Wizard
- Duplicates Query Wizard
- Unmatched Query Wizard
- Multiple conditions in a query
- Parameter query
- Query to generate summary data
- Export Data
- Export Access Data to Excel Workbook
- Drag n’ Drop Data into Excel
- Create Excel Workbook – Office Links
- Create Word Document – Office Links
- Advanced Report Design
- Design View
- Setting Report properties
- Calculated Control
- Grouping Reports
- Reports from multiple tables
- Adding a sub-report
- Group Header
- Cover sheets
- Running Sum
- Date or Time & Page Breaks
- Margins
- Label Wizard
- Macros
- Create a New Macro
- Assign Actions to a Macro
- Assign Arguments to Actions
- Save a Macro
- Use Step Mode
- Run a Macro/Tools Menu
- Edit a Macro
- Autoexec Macro
- Properties
- Assign a Macro to a Control
- Create a Command Button
- Use the Command Button Wizard
- Add a Condition to a Macro
- Create a Group Macro
- Using Custom Controls
- Register/Insert/Attach Custom Controls
- Switchboards
- Open & Use
- Create a Switchboard Form
- Add Controls to a Switchboard
- Set Startup Options
- Custom ToolBars
- Custom ToolBar
- Built-In Menu
- Custom Menus
- Access Edit Mode
- Indent Commands
- Assign Actions to Menus
- Link a Menu
- Delete/Insert Menu Command
- Add a Separator Bar
- Duplicate a Menu
- Create a Shortcut Menu
- Buttons