|
ACC-300
Access 2003 Advanced
Course Length:
1 day
*Prerequisite*
Intermediate Access
Introduction to Windows or equivalent working knowledge
General knowledge of other MS Office applications (i.e. Word, Outlook, Excel)
What past students had
to say about this class:
I have never rated a course
with all of the sections marked at their highest. The instructor and
this course were absolutely fantastic. I could not have asked fro a
better class. I learned so much and had so much fun! Thanks. ~H.R.
\Legoland Awesome,
motivated instructor, articulate and knowledgeable. ~P.P. \USMC
Very informative class. Great
teacher. Hope to take more classes. ~J.T.\ USMC
Course Contents
Introduction
Advanced table design techniques
Advanced form techniques
-
Creating a master-detail form
-
Adding a picture
to a form
-
Displaying the current date on a form
-
Modifying form
properties
Using tools menu options
-
Setting database
startup options
-
Setting a
database password
-
Encrypting and
decrypting 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
Working with macros and Modules
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
Final case study
|
