Microsoft Access 2000 Advanced
|
Tuesday, May 10,
9:00:00 AM - 4:30:00 PM
Location:
Cuyahoga County Public Library--Administration Building
Electronic Classroom
2111 Snow Road Parma, Ohio
Map
Cost:
$140 CAMLS Members
$170 Affiliate Members
$280 Non-members
Free for guests/speakers
Deadline: Tuesday, May 03,
Limit: 18
Registered Now: 0
Contact Hours: 6
**Notes:
Fee includes materials only. Lunch on your own.
|
|
This TWO DAY class follows the Access Basic course. After a review of basic concepts, students will learn the remaining tools necessary to create a fully functioning relational database management system. Using specialized queries, students will learn how to update multiple tables simultaneously, create interactive criteria that filters data based upon user defined data, and total query data. Participants will make better use of forms through the creation of relational sub forms, and the inclusion of property codes and formula expressions. Using intergration techniques, the class will learn to analyze Access data using Excel. Finally, students will set up a database for use across a networked platform using a "Front-end/Back-end" application.
This 2 day workshop is May 10 and May 11
Prequisite:Microsoft Access Basic
Course Content
RELATIONAL REVIEW
- Relationship Types
- Rules For Table Relations
- The Relationship Builder
WORKING WITH TABLES
- Automatic Creation
- Manual Creation
- Table Filters
ADVANCED QUERIES
- Action Queries
- Make Table Queries
- Delete Queries
- Parameter Queries
INTEGRATION
- Access Integration
- Linking & Exporting
- Mail Merge
APPLICATION DESIGN
- Form Filtering
- Main Form/Sub Form Creation
- Specialized Controls
ACCESS UTILITIES
- Database Splitter
- Sharing Data Across Networks
- Linked Table Manager
|
