|
ACC-200
Access 2003 Intermediate
Course Length:
1 day
Tuition:
$250
*Prerequisite*
Introduction 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 feel I have a working
understanding of Access with only 2 days of training with Systems. Mission
Accomplished! ~D.R. \ USMC
I wish I'd had this class
before, it would have saved my staff hundreds of man hours. ~ M.M. \ USMC
This is, by far, the best
experience I have had with a software training program. Kate is fun &
energetic and kept the class moving all day. I will definitely refer her and
your services in the future! Thanks! ~H.R. \ Legoland
Course Contents
Introduction
Modifying the design of a table
-
Displaying
a table in design view
-
Specifying
a required field/ defining a default field value
-
Setting
a primary key for a table
-
Adding
a memo field to a table
Working with multiple tables
Relating tables
Working with a custom form
-
Designing
a custom form
-
Adding
a header and footer to a form
-
Adding
a calculated control to a form
-
Using
a custom form to enter data
Intermediate
Query Techniques
Intermediate
report techniques
-
Creating
a report of information in multiple tables
-
Adding
a calculated control to a report
-
Adding
a cover sheet to a report
Working
with a Data Access Page
-
What
is a data access page?
-
Creating
a data access page
-
Adding
a Grouping Level to a data access page
-
Adding
a hyperlink to a data access page
Lesson
9: Additional intermediate Access features
-
Using
a database wizard
-
Adding
a lookup filed to a table
-
Defining
an input mask for a field
-
Exporting
an access datasheet into Microsoft Excel
Final case study
|
