OUTLINE FOR ACCESS2000
FOR Windows 98 LEVEL III
Introduction
Advanced table
design techniques
- validating field entries
- creating a custom input mask
Advanced form
techniques
- creating a master
-detail form, adding a picture to a form
- displaying the current date on a form, modifying
form properties
Advanced filter and
query techniques
- creating an advanced filter
- including multiple conditions in a query
- creating a parameter query- creating
an action query
Advanced report
techniques
- creating a master
-detail report, completing the report
- adding a cover sheet to a report, modifying report
properties
Working with macros
and modules
- what is a macro?
creating a macro
- running a macro
- creating a command button
- writing an event procedure
Using tools menu
options
- setting database startup options
- setting a database password
- encoding and decoding a database
- compacting and repairing a database
- using the database splitter wizard and the linked
table manager
- creating a replica of a database
Additional advanced
Access features
- creating a many-to-many relationship between
tables
- creating a switchboard
- exporting Access data to an XML document/importing
an XML document into Access
- saving an Access database in an MDE file
- creating an Access workgroup
- macro security
Final case study
Conclusion
Duration: 1 day
© Copyright 2000 MicroByte
Computer Center, Inc.
1410 Colonial Life Boulevard
Columbia, SC 29210
(803) 750 -7500
(803) 750 - 0174 (Fax)
| Back to
Training Catalog | Training schedule | Register for Course | Contact Us | |
