Data Clean-Up and Management

Index

A

Above average filter, 71–2

Absolute reference, 141

Access, 8, 9, 171–2

Double spaces, 177–1

Query, 173–89

SQL, 172, 176–80, 182–3, 185–7, 189

Wildcards, 171–2

Access data clean-up

Double spaces, 177–8

Alphabetization techniques, 40

Anglo-American Cataloging Rules, 8

Argument, 114

ARL, 29

Artificial push, 66–7

ASCII characters, 108–10

ASCII Code Chart, 108

Association of Research Libraries (ARL), 29

Attribute, 19, 21, 22

AutoFill, 81

AutoSum, 72–8

Subtotals, 72

Totals, 72

B

Best practice, 93, 99

Browser problems, 36

Buy-in, 27

C

CHAR, 107–9

Character classes, 155–7

Characters, 155–6

CLEAN, 107–9

Column, 43

Column confusion, 86

Column format, 85

Columnar data, 39, 92

Combining data, 111–44

Comma delimited, 87

Comparison of Excel ...