O'Reilly logo

Data Clean-Up and Management by Kenneth Furuta, Margaret Hogarth

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required