Microsoft Access is extremely useful for combining data. Using queries that perform mathematical, aggregate or text functions, looking for unique values in tables, using PivotTables or Crosstab tables, one can create complex combinations of data, or clean-up data.
Often, the questions that libraries need to answer with their data require combining data from one or more data sources. Or, if a system is difficult to extract usable data from, it may require sequencing data downloaded from the system. For example, recently a library was asked by the consortium for a list of locally subscribed print ...