See Datasheet View
datasheets. See also QBE grid; recordsets
adding records, 85, 208??“210, 221
aliases for fields in, 137??“138
aligning data in columns, 228
alternate row colors for, 226??“228
AutoNumber fields in, 210
changing display fonts, 225??“226
changing field display width, 223??“224
changing field order, 222??“223
changing record display height, 224??“225
Clear All Sorts command, 230
Datasheet Formatting dialog box, 227
deleting characters, 217
deleting current record, 217
deleting selected records, 221??“222
described, 5, 205
displaying cell gridlines, 226??“228
Dynasets, 135
editing existing values, 217
editing techniques, 218
empty, 208??“209
entering data, 208??“210
Filter by Form, 233
Filter by Selection, 230??“232
finding specific values, 215??“217
freezing and unfreezing columns, 229
hiding and unhiding columns, 228??“229
hiding rows, 225
inserting characters, 217
line styles for, 227??“228
linked tables in, 544
moving between records, 214
navigating, 206, 214??“217
opening, 208
overview, 8, 203??“204
printing records, 233??“235
properties??™ effect on data entry, 212??“214
for queries, 134??“135
record pointers, 210
replacing values, 217, 220??“221
saving layout changes, 229
saving records, 210, 229
specifying form view as, 282
tables permanently changed by updates, 9
viewing for queries, 125
viewing table contents in, 205
Date data type (VBA), 396
Date() function, 459
date interval groups in reports, 654??“655
Date Picker, 276??“277
DateAdd() function, 456, 460
DateDiff() function, 459??“460
DatePart() function, 460
Date/Time data type or field
built-in formats, 59
converting, 54
custom formats, 59??“60
data entry in forms, 276??“277
Date Picker for, 276??“277
described, 44, 46
Format property for, 59??“60
import errors for, 576
importing text files with, 566, 568??“569
input masks for, 65
overview, 49, 1260
properties??™ effect on data entry, 212
selection criteria for queries, 143??“144
SQL Server equivalents, 1261
storage requirements, 46
Text data type versus, 48
Validation Rule property for, 66??“67
date/time functions, 456, 459??“460
date/time values
in expressions, 448, 449, 450
miscalculated, logical errors from, 501, 802
DAvg() function, 465
Day() function, 459
.
Pages:
2344
2345
2346
2347
2348
2349
2350
2351
2352
2353
2354
2355
2356
2357
2358
2359
2360
2361
2362
2363
2364
2365
2366
2367
2368