See also action queries
creating, 611??“612
described, 609
viewing results of, 610
viewing set of data for, 610
Updated event, 427
UpdateRecords() function, 688??“689
updating
calculated fields, 486??“490
cascading updates, 120
fields in a record using ADO, 481??“486
multi-table queries, 150??“151
primary keys, 151
progress meters, 852??“853, 855
queries, rules for, 150
records returned by DISTINCT query not updateable,
476
table data using forms, 480??“481
update anomalies, 94??“95, 97
update queries for, 609, 610, 611??“612
upsizing Access databases to SQL Server
comparison of Access and SQL Server data types,
1259??“1262, 1263
conversion issues, 1262??“1263
downloading SQL Server Express, 1223, 1224, 1249
naming constraints for fields, 1262
need for, 1250??“1251
preparing for, 1251
1352
Index U
tables, situations preventing upsizing, 1263
Upsizing Wizard for, 1249??“1257
working with Access ADP files, 1257??“1259
Upsizing Wizard
ADP file created by, 1249
linking to SQL Server data versus, 1249??“1250
preparing to use, 1251
report snapshot, 1256??“1257
running, 1252??“1256
usage logs, maintaining, 894??“895
Use Default Paper Size form property, 290
Use Transaction query property, 591
user accounts
adding, 922??“923
creating or changing passwords, 923??“924
deleting, 923
object owner, 929
replication issues, 998??“999
user interface (Access).
Pages:
2425
2426
2427
2428
2429
2430
2431
2432
2433
2434
2435
2436
2437
2438
2439
2440
2441
2442
2443
2444
2445
2446
2447
2448
2449