Intro to Access Databases, Part 3 (for library/literacy staff/volunteers)
Learn to use Access 2007 or 2010 to create and use database files. In a database, you may store client or customer contact information, inventory, movies and other resources, or other large sets of data. You can use Access to input data and then work with it by extracting specific records and sorting the results to get useful reports.
Part 1 topics include getting familiar with the Access environment and working with the principal objects - tables, queries, forms, and reports - to achieve a comfort level with the purpose of each object. In addition, part 1 will cover creating a database file, creating tables, adding and editing records, and creating simple queries. Access is a four-part course.
Part 2 will cover setting properties in tables, creating complex criteria in queries, setting table relationships, and using related tables.
Part 3 will cover creating and using data entry forms and subforms, crosstab and parameter queries, and importing, exporting, and linking external data.
Part 4 includes creating reports, creating macros, and database management.
Carolyn Bibles, a computer software instructor and Access consultant, will teach the class. There is no prerequisite for this class. Students need to enroll in all 4 parts or go on a paper waiting list with Melanie Price Melanie.Price@libraries.ok.gov .
If your library or literacy organization is 60 miles or more from ODL, a travel stipend of up to $92/night for overnight stay may be available. (Stipend will be based on lodging receipt. If lodging charges are less than $92, the contract will be written for the actual amount, not $92.) Mileage also may be reimbursed at 30 cents/mile if you are paying for your own gas & cannot collect from your library/literacy organization. Stipend contracts will be made out to the library/literacy organization. It will be your responsibility to collect your reimbursement from such organization. No travel stipend contracts will be written until the class has been attended and photocopied proof of overnight stay (if applicable) has been submitted to the Office of Library Development.