OUTLINE FOR ACCESS2000
FOR Windows 98 LEVEL II
Introduction
Modifying the design of a table
-
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
- displaying multiple tables on the
Access desktop
- resizing and repositioning the table
window
Relating tables
- creating a relationship between two
tables in a database
- displaying and using a subdatasheet
Working with a
custom form
- designing a custom form
- adding a header and footer to a form
- using a custom form to enter data
Intermediate query
techniques
- creating a query to extract
information from multiple tables
- creating a query to generate summary
information
- creating a crosstab query
- creating a query to find unmatched
records in a table
- creating a query to find duplicate
records in a table
Intermediate report
techniques
- creating a report of information in
multiple tables
- adding a calculated control to a
report
Working with a data
Access page
- what is a data Access page?
- creating a data Access page
- adding a pivottable to a data Access
page
- adding a pivotchart to a data Access
page
Additional
intermediate Access features
- adding a lookup field to a table
- defining an input mask for a field
- viewing object dependencies
- exporting an Access datasheet to
Microsoft Office Excel
- using the database wizard
Final
case study
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 | |
