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

4

Types of data issues

Abstract:

Microsoft Excel and Access have strengths in different areas when managing information. Disciplined practices make data handling safer and long-lived. Even with standards, data can be variable and/or dirty. Browsers and other applications can cause issues with data. Default settings, legacy systems and new information formats can also cause data problems.

Key words

data

issues

sharing and handling data

Excel

Access

Microsoft Excel vs Microsoft Access

Table 4.1 gives some general guidelines for when it is best to use Excel, and when Access.

Table 4.1

Comparison of Excel and Access showing application strengths

Excel Access
Mostly numeric data Large amount of data
Data requires calculations Long strings ...

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