Title: Microsoft Access, Beginning Level: Office 2007 (This class is full. Contact the NNYLN to be placed on a waiting list.)
Date: Tuesday, September 30, 2008
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: Microsoft Access is the most widely used database program in use today. With the introduction of Microsoft Office 2007 many of the familiar toolbars and screen designs changed dramatically, along with the introduction of the "ribbon," Microsoft’s new navigational tool. This class will facilitate using this new version of Access.
For those using a previous version of Access, the class will be very useful. The concepts remain the same, but users of previous versions should realize the screens will look different.
The class will cover:
a. Database basics: understanding the pieces, Access versions and alternatives
b. Databases from templates
c. Tables
     i. Exploring with Northwind
     ii. Creating tables with wizards
     iii. Field names, types, basic options
     iv. Necessity of primary keys
     v. Design and datasheet view
     vi. Add, edit and delete records
     vii. Sorting, finding and viewing
d. Queries: sorting and filtering records
e. Forms: creation via wizards, basic design modifications
f. Reports: creation via wizards, getting totals, basic design modifications

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