Microsoft Access 2007 Advanced (1 day)

Assumes familiarity with all Access basics and experience of creating database tables forms, queries and reports .

Exchanging data

Importing data
Exchanging data with Excel
Exchanging data with Word
Linking to external data

Setting properties
Creating command buttons
Using ActiveX controls
Pop-up forms

About replication
Setting up a replica
Security options
The User-Level Security Wizard
Synchronisation
Back up

Creating a macro
Running a macro
Using the macro builder
Conditional macros
Assigning macros to controls
Autoexec macros

Creating a chart
The Chart Wizard
Adding charts to forms
Adding charts to reports
Editing charts

What is a switchboard?
The Switchboard Manager
Creating switchboard in design view
Adding buttons