Overview

Our Advanced Access course includes such topics as the creation of interactive forms, replication, security and the creation of macros.

Course Outline

Exchanging data

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

Form controls

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

Replication

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

Macros

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

Charts

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

Switchboards

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