Mastering Access 2000: Level 1
Date & Time
Tuesday, December 12, 2000 & December 13, 2000
9:00 AM-4:30 PM
Cuyahoga County Public Library--Administration Building
Electronic Classroom
2111 Snow Road Parma, Ohio
$80 CAMLS Members
$96 Affiliate libraries
$294 Non-members

Deadline: Tuesday, December 05, 2000
Limit: 18
Formerly called Access Advanced, this two-day course has been restructured to include several new topics as well as modifying existing topics. “Many to many” relationships are examined more in depth than before, and students are given a project to create a database utilizing a many to many relationship. Create great looking reports. Reporting features have been greatly expanded upon. Learn to sort and group reports on common sets of data, perform sectional formatting, and control page numbering. You will also create subreports to display relational sets of data, modify the report header, and add graphics. More functional forms. This course will teach you to make better use of forms by using property codes and formula expressions. Learn how to create and apply hidden fields and object controls to forms for relational data entry and printing. You will also learn to recognize query snapshots and dynasets, create AutoLookup queries, and use macros to control the flow of information on forms. You will also use VBA controls to create data lookups, drop down boxes, and list boxes.
Intended Audience
People who want to learn how to create a fully functioning database application utilizing advanced data entry forms, advanced queries, and reports. Prerequisite: Microsoft Access Basic
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.