1312
Index
Navigation Options button/dialog box, 1089–1090
Navigation Pane. See also Datasheet window, navigating.
All Access Objects option, 36
alternate displays, 34
Created Date option, 35
custom groups, 34
Custom option, 34
displaying, 1089
Filter By Group option, 35–36
Forms option, 36
hiding, 913–914
Modified Date option, 35
new features, 1256–1258
Object Type option, 34
options, displaying, 1089–1090
overview, 33
Queries option, 36
Reports option, 36
Tables and Related Views option, 34–35
Tables option, 36
needs analysis, 14
network applications. See also locking issues; SharePoint.
all files on server, 753
all files on the client, 754
client-centric applications, 754–756
data sources, 754–756
distributed installation, 753
file location, 753–754
opening a database, 756–758
performance, 752
SQL pass-through, 755
transactions, 755–756
network applications, splitting databases
benefits of, 759–761
Database Splitter wizard, 762–764
definition, 753
placing objects, 761–762
network applications, unbound forms
versus bound forms, 780–781
combo boxes, 785
creating, 781
editing data, 786–788
navigating through records, 783–788
navigation buttons, 783–785
opening, 782–783
overview, 780–781
populating, 782–783
specifying a recordset for, 782naming conventions (continued)
forms, 256
importance of, 39–40
macros, 1052
prefixes, 40
property procedures, 990
report controls, 285–286, 749
spaces in names, 40
SQL Server, 1211
naming conventions, VBA
collections, 407
overview, 432
parameters, 442
prefixes, 432
procedures, 435–436
spaces in names, 423
subroutines, 435–436
tags, 432
variables, 394, 422–423
natural primary keys, 77, 118–119
navigating
among fields, 294
among records, 294
datasheets, 599
recordsets, 495
unbound forms, network applications, 783–788
navigating, Datasheet window. See also Navigation Pane.
within a datasheet, 218
finding specific values, 228–229
keystrokes for, 218
Navigation buttons, 218–219
overview, 227
between records, 227–228
Navigation buttons, 218–219, 704
navigation buttons, on forms
captioning, 309
displaying, 306
unbound forms, 783–785
Navigation Buttons property, 306
Navigation Caption property, 309
Navigation form, SharePoint deployment, 1170–1171
Navigation Form command, 252
Navigation forms, 257–260. See also Form view, navigating.
Navigation options
Display Navigation Pane check box, 1089
Navigation Options button/dialog box, 1089–1090
Navigation Pane, displaying, 1089
Navigation Pane options, displaying, 1089–1090
system objects, hiding, 109052_475348-bindex.indd 131252_475348-bindex.indd 1312 4/1/10 2:02 PM4/1/10 2:02 PM