|
Home
> Training
> Microsoft
Office 2003
Access 2003 Advanced
1 day
This course covers advanced features of Access, which are essential
in maintaining a database efficiently. By the end of the course,
delegates will be able to create macros to automate forms and
provide user interaction; work with external data through importing,
exporting and linking; understand how to administer Access; and
add database security.
This course is highly suitable for those
who wish to automate Access either for their own use or for
use by others.
Creating Macros to Automate Tasks
Macro basics
The macro object
Creating and editing a macro
Form events and the event order
Attaching a macro to an event in a form
Attaching a macro to a command button
Grouping macros
Conditional macros
AutoKeys and AutoExec macros
Importing & Exporting Data
Copying and moving data between tables
Importing and exporting text files
Delimited files and fixed width files
Importing and exporting using Excel
Moving imported data to an existing table
Administering Access
Compacting your database
Recovering damaged databases
The Database Documenter
The Database Splitter
Linking tables
Tuning Access for better performance
Database Security
Securing a database
Adding a database password
Workgroups
User and Group Accounts
Assigning and removing permissions
Data Access Pages
Designing and creating a Data Access Page
This course is suitable
for those who have
been using Access
regularly on a day-to-day
basis, or who have
attended our Access
2003 Introductory
and Access
2003 Intermediate
courses and need to
become familiar with advanced
Access techniques.
10:00am to 5:00pm
Comprehensive course manual included.
Refreshments and lunch are provided on all courses at the Information
Horizons Training Centre.
 Back
to the top
|
