Microsoft Access 2007 Advanced

Table Design Factors and Tools

• Concepts of Normalisation
• Using the Table Analyser
• The Performance Analyser
• Adding Security Encryption
• Compacting a Database
• Using Name AutoCorrect
• Backing Up a Database

Transferring Data

• Importing & Exporting Access Objects
• Linking Table Data
• Using the Linked Table Manager

Advanced Queries

• Joining Tables in a Query
• Join Types
• Crosstab Queries
• Finding Duplicates
• Unmatched Record Queries

Creating Relationships

• Creating Relationships between Tables
• Setting Referential Integrity
• Cascade Options
• Viewing Subdatasheets
• Deleting a Join Line

Using Advanced Form Design

• Using Forms in Design View
• Setting the Tab Order Manually &
  Automatically
• Adding a Form Header & Footer
• Creating PivotTable and PivotCharts
• Control Wizards
• Adding a Command Button to a Form
• Creating a Combo Box, List Box & an
  Option Group
• Adding an ActiveX Control to a form

Using SubForms/SubReports

• Creating & Using SubForms

Advanced Report Design

• Adding Report Sections in Design View
• Creating a Calculated Control
• Grouping Data in a report
• Creating Group Headers & Footers
• Creating a Running Summary
• Inserting a Date/Time Control & Page Breaks
• Changing the Report Margins
• Using the Label Wizard
• Creating a Report without using the Wizard

Using Charts

• Creating a Chart in a Form
• Modifying and Formatting Charts

Creating Macros

• Creating Macros in the Design Window
• Stepping a Macro
• Macro Actions & Arguments
• Assigning a Macro to a Command Button

Using Macros

• Creating Conditional & Group Macros

Event Properties

• Using Event Properties
• Validating Data with Macros

Using Switchboards

• Creating & Using a Switchboard

Customising the Quick Access Toolbar

• Creating Custom Toolbars, Menus & Shortcut
  Menu

Appendices: Time Permitting

• Create a Hyperlink Field
• Saving Access Objects as HTML
• Advanced Security

• Report Writing
• Writing Effective Letters and Emails

• Excel 2007: Level 3
• Word 2007: Level 3

The next course in this series is:

• Access 2007: Programming with VBA

Relevant accreditations include:

• Microsoft^® Certified Application Specialist:
  Using Microsoft^® Office Access 2007