Data Clean-Up and Management

14

Access – combining data

Abstract:

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.

Key words

Access

combine

de-dup

unique

crosstab

PivotTable

function

Combining data from one or moredata sources

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 ...