See also AutoNumber data type
or field; Currency data type or field;
Date/Time data type or field
built-in formats, 57??“58
changing field size, 54
converting, 54??“55
custom formats, 58??“59
Decimal Places property, 56
Default Value property for, 56
described, 44, 46
Field Size property, 49
format examples, 58
Format property for, 57??“59
leading zeros not stored for, 47
overview, 49, 1260
properties??™ effect on data entry, 212
query criteria for, 188??“189
reflecting field data, 47
selection criteria for queries, 143??“144
SQL Server equivalents, 1261
storage requirements, 46
numbered lists in reports, 655??“658
NZ() function, 465
O
Object data type (VBA), 396
object libraries
described, 724
early binding an object, 724??“725, 727
late binding an object, 725??“727
required for Automation examples, 725
object-oriented programming. See OOP
objects. See also identifiers or object names; OOP (objectoriented
programming); specific types
basics, 1039??“1040
benefits of, 1038??“1039
bound versus unbound, 770??“771
class modules as definitions of, 1041
creating multiple instances, 1040
defined, 1039
embedding, 772??“780
exporting to other Access databases, 577??“578
forms as, 1076
1329
Index O
objects (continued)
importance of design process, 10
importing all into new database, 858
importing (other than tables), 571
local, in replica sets, 988??“989, 999??“1000, 1014??“1017
methods of, 1042
names stored in MSysObjects table, 672, 673
naming conventions, 36??“37
not related to a table, viewing, 32
properties of, 1041??“1042
referencing in library databases, 1087??“1088
related to a table, viewing, 31??“32
setting owner for, 929??“931
setting permissions for, 931??“934
specialized, for client/server architecture, 1214
storable in OLE fields, 275
tabbed user interface for, 33??“35
top-level, 8
type values for, 673
types of, 770
using in applications, 1040
obsolete databases
enabling (opening in read-only mode), 29
opening and converting, 27??“29
ODBC (Open Database Connectivity)
connect strings and source table names with, 549
exporting using, 578
importing using, 572??“574
limitations of linked data, 533
linking to data sources, 536
performance issues, 688
record-locking refresh interval, 702
specification, 536
SQL Server connection using ODBC, 1227??“1236
ODBC Time-out query property, 590
Office Button, 25.
Pages:
2386
2387
2388
2389
2390
2391
2392
2393
2394
2395
2396
2397
2398
2399
2400
2401
2402
2403
2404
2405
2406
2407
2408
2409
2410