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

Get Data Clean-Up and Management now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.