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

13

Data clean-up in Access

Abstract:

Common scenarios for dirty data in Microsoft Access are presented, with possible solutions. Emphasis is on cleaning data before it is loaded into Access. Input masks on specific fields are another solution.

Key words

clean-up

sort

error

subscript out of range

type conversion failure

input mask

For librarians, clean-up issues in Access usually mean dirty data from an Excel spreadsheet was loaded into Access. Sometimes, no matter how much time was put in, or how many ways one looked at the data, errors requiring clean-up creep in. With the sheer volume of data passing through a library, dirty data is bound to get in.

Prevention is the best cure

We’ve spent much time going over the data, but dirty data ...

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