Microsoft Access XP-2003 Advanced

Advanced Queries

• Joining Tables in a Query & Join Types
• Creating Parameter Queries
• Creating Concatenation in a Query
• Using Built-In Functions

Creating Relationships

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

Using Advanced Form Design

• Using Forms in Design View
• Creating Combo Box, List Box & an Option Group
• Adding Logic Control
• Setting the Tab Order Manually & Automatically
• Adding a Form Header & Footer
• Creating a Blank Form

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 SubForms/SubReports

• Creating & Using SubForms

Other Form Techniques

• Changing Control Properties
• Saving a Form as a Report
• Creating a Pivot Table or Pivot Chart

Using Control Wizards

• Creating Command Buttons to perform Actions

Using ActiveX Controls

Working with Indexes

Creating Macros

• Creating Macros in the Design Window
• Macro Actions & Arguments

Using Macros

• Using Conditional Macros & Macro Groups

Event Properties

• Using Event Properties

Using Switchboards

• Creating & using a Switchboard

Creating Custom Toolbars

• Creating Custom Toolbars, Menus & Shortcut Menu

Time Permitting Topics (Appendices):

• Table Analyser
• Database Utility Tools
• Using Name AutoCorrect
• Importing Data
• Linking Data to an Access Table
• Exporting Data
• Using Advanced Query Wizards
• Charts
• Create a Hyperlink Field
• Create Data Access Pages
• Security & Passwords
• Replicating Databases
• Introduction to VBA Modules

• Report Writing
• Writing Effective Letters & Emails

• Excel XP-2003: Level 3
• Word XP-2003: Level 3

The next course in this series is:

• Access XP-2003: Programming with VBA

Relevant accreditations include:

• Microsoft Office Specialist: Core