Notes
Slide Show
Outline
1
MS Access for Library Data
  • Why a Database?


  • Structure for Function


  • Learning Curve


  • Will This Work with Bibliostat and FSCS?


  • What Happens When I Leave?
2
Why a Database?
  • Spreadsheet – Pros/Cons


  • Power of Relations


  • Reports, Forms and Queries


  • Types of Relational Databases


  • Starship Enterprise
3
Structure for Function
  • Reporting Needs Before db Design


  • Active or Archive?


  • Multi Year Needed?


  • Directory Issues
4
Learning Curve
  • Courses


  • Books


  • Journals


  • Web Resources
5
MS Access, Bibliostat and FSCS
  • Import/Export to/from Bibliostat


  • FSCS File Structure


  • Looking Forward


  • MS Access Versions
6
Leaving Your Database Legacy
  • Document, Document, Document


  • Anticipate Training Needs


  • Simplify


  • Consult in Retirement!
7
"Ira Bray"
  •      Ira Bray
  •      Library Development Services
  •      California State Library


  •      ibray@library.ca.gov
  •      (916) 653-0171