Workshops Committee Programs Management Training Series Library Leadership Ohio
 
Microsoft Access 2000 Basic
Tuesday, March 22, 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, March 15, 2005
Limit: 18
Registered Now: 3
Contact Hours: 6

**Notes:
Fee includes materials only. Lunch on your own.

This TWO DAY class teaches the fundamentals of a relational database. Students will create tables with an understanding of normalization rules, field properties, and record editing. This includes data validation, streamlining database size , and proper indexing to maximize performance. Participants will to create relational tables and use them in relational queries. Other query topics include sorting, filtering, manual vs automatic table linking, and calculated fields. Students will also be taught form creation for data entry and basic report creation.

This 2 day workshop is March 22 and March 23

Prerequisite: Microsoft Windows

Course Content

    GETTING STARTED
  • What is a database
  • Integration
  • How Access Works
    WORKING WITH DATABASE FILES
  • Screen Elements
  • Navigating Between Records
  • Editing & Sorting
    DATABASE TABLES
  • Purpose & Design of Tables
  • Field Properties & size
  • Input Masks & Default Values
    QUERIES
  • Purpose of Queries
  • Query Criteria
  • Criteria Operators
    FORMS & REPORTS
  • Form Area & Elements
  • Formatting
  • Designing & Previewing Reports
  • Functions & Expressions
    RELATIONAL DATABASE DESIGN
  • Relationship Types
  • Relational Join Lines & Queries
  • Enforcing Referential Integrity
Audience: Individuals with a solid working knowledge of Windows 95. 98 or 2000
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: