Title: Microsoft Access, Level 2: Office 2007
Date: Friday, February 6, 2009
Presenter: James Crowley, Crowley Computers
Time: Sign-in, 9:00-9:30 a.m.; Class, 9:30 a.m. - 3:30 p.m.
Location: Northern New York Library Network, Potsdam
Fee: $15.00 for library staff, $59.95 for all others (Includes lunch), "Blue Line" Library Staff: No Charge
Description: Students who have used this popular database program in a limited way, or students who participated in the Beginner’s Level class previously offered by the NNYLN, will find this Level 2 class helpful in learning to fully utilize the powerful features of Microsoft Access. Access can be much more than the basic database program, and this class can help students realize that potential.
For those using a previous version of Access, the class can be very useful. The concepts remain the same, but users of previous versions will see the screens will look different.
The class will cover:
a. Database basics review
b. Fields
     i. Advanced options: formats, input masks, defaults, validation
     ii. Lookup Wizard: basic and linking tables
c. Linking tables
     i. Simple connections
     ii. Via simple and complex queries
     iii. Queries
       1. Creating fields with formulas
       2. Importance of primary keys
d. Normalization for accuracy and simplification
e. Forms
     i. Modifying
     ii. Using calculated fields
     iii. Subforms use and creation
f. Reports
     i. Labels and custom report sizes
     ii. Modifying
     iii. Using calculated fields
Useful tools: compact, replication and splitting
Sign up for this class.

© Copyright Northern New York Library Network   All Rights Reserved
This site developed by Seaway Web Design