Microsoft Access for Libraries

$200.00

Credits: 1.5 CEUs or 15 PDHs

This course will introduce the basic functions of databases for libraries. Microsoft Access is part of many MS Office accounts and has powerful features for libraries – from handling Excel data to transforming SharePoint data, Access can help you leverage your data and save you from repetitive tasks. You will learn how to create a simple database by creating tables, designing forms, building reports, and packaging it all together. Exercises will draw from library examples such as building a Reference Desk tracking system, merging disparate ILS reports, creating a year-end spending report, and preparing a report on a vendor title package against LC/DCC classification schemes.

Clear
Category:
Instructor:
Topic Areas: ,

Course Information

Session

Credits

1.5 CEUs or 15 PDHs

Registration dates

We accept registrations through the first week of classes, unless enrollment is full, and unless the class was canceled before it started due to low enrollment.

Course Description

This course will introduce the basic functions of databases for libraries. Microsoft Access is part of many MS Office accounts and has powerful features for libraries – from handling Excel data to transforming SharePoint data, Access can help you leverage your data and save you from repetitive tasks. You will learn how to create a simple database by creating tables, designing forms, building reports, and packaging it all together. Exercises will draw from library examples such as building a Reference Desk tracking system, merging disparate ILS reports, creating a year-end spending report, and preparing a report on a vendor title package against LC/DCC classification schemes.

  • Create tables and joins
  • Import Excel data
  • Create a data entry form
  • Query the data
  • Build a report to share your results
  • Share your database with other team members.

Trevor Smith

Trevor SmithTrevor Smith is the Monograph Collections and Metadata Librarian at Douglas College and an adjunct faculty member at UBC SLIS where he teaches Project Management for Information Professionals. He has mainly worked in Academic libraries but has also worked in Start-ups. Prior to becoming a librarian, he worked in the tourism sector where he developed a railway reporting network using SharePoint and MS Access. He often presents workshops and talks on databases and Project Management.

How to Register

To enroll yourself or other participants in a class, use the “Register” button that follows the description of each course. If the “Register” button does not show up, try loading the page in a different web browser. Contact us if you have technical difficulties using our shopping cart system or would like to pay for an enrollment using another method. On the payment page in the shopping cart system, there is a place to add notes, such as the names and email addresses of participants you wish to enroll. We will contact you to request this information in response to your processed payment if you do not include it in the “notes” field. Prior to the start of the workshop, we will send participants their login instructions.

Payment Info

Our shopping cart system allows you to pay with a credit card or with PayPal.

Alternatively, if it is an institutional payment, we can arrange to invoice you. Contact us by email, and we can make arrangements to suit your institution's business processes.

Special Session

Please contact us to arrange a special session of this class for a group of seven or more, with a negotiable discount, or to be notified when it is next scheduled.

Reviews

There are no reviews yet.

Be the first to review “Microsoft Access for Libraries”

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.