Microsoft Access XP-2003 Advanced

Objectives
On completion of this course delegates will be able to:

Design & create well structured databases
Enhance existing databases
Perform advanced queries
Manipulate properties within forms & reports to control formatting & content
Create sub forms & sub reports
Automate a completed database using macros, switchboards & custom toolbars
Course Content

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