Workshops Committee Programs Management Training Series Library Leadership Ohio
 
Microsoft Access 2000 Advanced
Tuesday, May 10, 2005
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, 2005
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
Audience: Designed for those who have completed the Access Basic course and want to create fully functional Access databases.
Presenter:
John Paul is the President and owner of Winsoft, a software training firm. He has been a professional speaker for over eight years. He routinely conducts computer seminars nationwide and is an expert in the Microsoft Office product line.

More on this topic: