Alan Manifold Library Automation Consulting
For libraries with large well-trained automation staffs,
getting the most from your Voyager system is difficult
and takes lots of time. For libraries with no dedicated
automation staff, the very prospect of striking out on
your own to exploit the resources available to you is,
by itself, enough to scare you away.
I can help. I have over twenty-five years of experience in
library automation (see my resume),
having done it all:
- Translated an entire library system to a new programming language
- Wrote an entire library system from scratch
- Managed a complex, mainframe-based system
- Developed many stand-alone add-ons for library automation
- Directed the selection of a client/server system
- Implemented and managed a Voyager system
- Created a custom federated search site
How I can help you
It is not terribly hard to develop a few ad hoc queries against
your Voyager database using Microsoft Access. However, many
sites do not have the technical expertise readily
available to support all of the things that would help them get
the most from this set-up. Training courses available from
Alan Manifold Library Automation Consulting can help guide you
through this difficult arena.
"Using Microsoft Access to Create Reports from Voyager" is the
most popular workshop offered by Alan Manifold Library Automation
Consulting. A general outline for this two-day workshop is as follows:
-
Background
-
Relational Database Tables
-
A Sample Query
-
Normal Forms
-
Marc Records in Voyager
-
Entity-Relationship Diagrams
-
Microsoft Access Overview
-
Tables and Views
-
Queries
-
Parts of a Query
-
Adding Tables
-
Linking Tables
-
Adding Fields
-
Applying Criteria
-
Core Relationships
-
Circulation Tables
-
Acquisitions Tables
-
Advanced Queries
-
Data Type Conversions
-
Voyager Locations
-
Using Dates as Criteria
-
Monetary Values
-
Sorting Query Results
-
Prompting For Criteria
-
Access Query Types
-
Query Polishing
-
Duplicate Results
-
Missing Results
-
Aggregate Functions
-
The BLOB
-
The Problem
-
BLOB Functions
-
Reports
-
Creating A Report
-
Report Design View
-
Changing Report Design
-
Sharing Access Objects
-
Copying Objects between Databases
-
Sharing Queries with Others
-
Stepwise Development
-
Subqueries
-
Make Table Queries
-
Development Tools
-
Entity-Relationship Diagrams
-
The Whole Process
-
Modifying Reporter Output
-
Report Design Modifications
-
Adding New Fields to Reports
-
Prepackaged Reports
-
Preparation
-
Analyzing
-
Customizing
This workshop, in many variations, has been presented by Alan
Manifold Library Automation Consulting many times,
to staff from more than 500 Voyager sites.
In addition to the basic workshop, Alan Manifold has created a
number of variations of a workshop entitled "The ART (Advanced
Reporting Techniques) of Voyager Access" and has presented it
to institutions around the world. If you believe you already
know the basics, but still could use some help, requesting your
own customized version of this workship might be for you.
If you would like more information about the training or other
services of Alan Manifold Library Automation Consulting, please
contact us:
Alan Manifold
2825 Covington Street
West Lafayette, Indiana 47906
(765) 497-8223
Send me e-mail (alan@mashiyyat.net)
Last update 27 October 2006