See also specific data sources
for multiuser applications, 688??“689
ODBC, for SQL Server connection, 1227??“1236
ODBC, linking to, 533, 536, 549
ODBC, performance reduced with, 688
ODBC, transactions for, 688??“689
SharePoint as, 1192
data structures (user-defined types), 957
data types (Access). See also specific data types
action query errors, 615
assigning to fields, 44??“45, 46??“51
automatic validation for, 211
changing for fields, 54??“55
converting, 54??“55
converting from dBASE, 575
converting from Paradox, 575
in Grouping intervals list box, 304
grouping variable declarations by, 503??“504
import errors for, 576??“577
for indexing fields, 47
1304
Index C
join condition for, 146
list of, 44
performance impacts of, 844??“846
properties, 6, 41, 55??“70
property variable, 1058
reflecting field data, 47
report considerations, 48
rules for choosing, 47??“48
SharePoint Lists as, 754
for sorting fields, 47, 48
SQL Server data types compared to, 1239, 1259??“1262,
1263
storage requirements, 46, 47
table summarizing, 46, 1260??“1261
VBA data types compared to, 397
data types (API)
data structures (user-defined types), 957
declaring for function return value, 961
in function documentation, 955??“956
prefixes for function arguments, 956
VBA data types compared to, 954??“955
data types (SQL Server), 1239, 1259??“1262, 1263
data types (VBA)
Access data types compared to, 397
C (API) data types compared to, 954??“955
conversion functions for, 456, 457??“459
default for variables, 397??“398
for function return values, 358
overview, 395??“397
table summarizing, 396
data types (XML), 1179
data validation
automatic for data types, 211
business rules for, 121??“122
designing data-entry rules, 45
in effect in datasheets, 134
OOP benefits for, 1039
for user input, 894
Validation Rule property, 56, 66??“67, 71
Validation Text property, 56, 66, 67
Database Documenter, 81??“82
database objects.
Pages:
2341
2342
2343
2344
2345
2346
2347
2348
2349
2350
2351
2352
2353
2354
2355
2356
2357
2358
2359
2360
2361
2362
2363
2364
2365