Back Color property, 647
Back Up Database command, 205
background color for reports, 788–789
Background Compile check box (Options dialog box), 949, 950
background missing on Web page, 1150
backing up
application data, 1315
before running delete queries, 510
data before using update queries, 489
databases, 205
tables, 206–207
text queries, 1526
backslash (\)
operator precedence for, 367
rounding numeric expressions with, 365
used to display character immediately following, 653, 655
backward compatibility with .mdb format, 979
BeforeUpdate events, 931, 937
BEGIN/END statements, 1531, 1532
BETWEEN operator, 169, 360–361
BETWEEN predicate, A35
bigint data type, 1461
Bitmap Image Object submenu, 534
bitmap objects, 535
Blank Database button
about, 21
connecting to existing SQL Server database from, 1453
creating new project from, 1448, 1449
illustrated, 22
Blank Database icon, 148
Blank Form button, 609
Blank Report button, 790–791
blank reports, 760
Blank.accdb database template
creating, 196–197
saving in appropriate template folder, 197–199
blocking harmful content, 35–36
Boolean operators
as selection criteria, 356
truth tables for, A56
using in query designer, A55
Border Style property, 675–676
borders
drawing on report, 1118–1121
setting control, 583–584
setting style properties for form, 675–676
bound combo box properties, 604–605
bound controls, 566
bound forms
editing data on, 884
server filters with forms bound to in-line functions, 1558
bound object frame, 534
brackets ({})
added to SELECT statements in earlier Access versions, A61
defining list of comparison characters in, A49
delimiting names for SQL Server, 1460, A36
displaying text in color specified, 654, 656
enclosing object names in, 372, 919
including query parameters in, 449
inserted automatically in form control reference, 901
placing around field names, 362
putting object names in, 372
when to enclose names in, 989–990
Break In Class Module check box (Options dialog box), 949
Break On All Errors check box (Options dialog box), 949
Break When Value Changes check box (Add Watch dialog box), 957
Break When Value Is True check box (Add Watch dialog box), 957
breaking design rules, A28-A31
capturing point-in-time data, A29-A31
creating report snapshot data, A31
improving performance of critical tasks, A29
breakpoints.
See also debugging
cautions using, 957
inserting in code, 951–952
output statements in Immediate window, 954–956
preventing debugging, 1312
browsers. See Web browsers
bugs
error message when saving in-line function, 1516
incorrect positioning of fields on form grid, 627
mailto:
protocol prefix, 1062
missing background images in Form Wizard, 595, 690
opening properties affecting color from Custom Properties dialog box, 729
Build button, 172, 729
building simple input forms.
See also Form Wizard
with design tools, 563–589
adding new query for property, 576–578
creating and setting form dimensions, 563–567
customizing colors and reviewing design, 587–589
dragging fields to form, 578–580
font options for, 582–583
label properties for, 585–586
moving and sizing controls, 580–581
setting and displaying properties of, 586–587
setting object properties, 574–578
setting text box properties, 584–585
specifying record source, 566–567
text box properties for, 584–585
Form Wizard, 593–597
creating basic form, 593–597
modifying basic form, 598–601
quick create commands for, 590–593
built-in views for Windows SharePoint Services, 1173
business rules
ensuring in queries for data integrity, 417–419
verifying prerequisite data to satisfy, 1075–1077
Button Face color, 642
buttons
Add Generated Key, 237
Advanced Filter, 385, 402
Ascending, 385, 402, 409
assigning macros custom images, 30, 31
associating macro with, 923–924
AutoCalc, 475
AutoFilter, 475
AutoFormat, 807–808
Blank Database, 1448, 1449, 1453
Blank Form, 609
Build, 172, 729
Clear All Sorts, 402
Close, 675
Collapse Field/Expand Field, 476
Combo Box, 569
command, 517, 535–536
Controls group, 568–572, 583–584
Datasheet Formatting Dialog Box Launcher, 1145
Datasheet view of, 385
Debug toolbar, 956
defining several at a time from Controls group, 714
Descending, 402, 409
Dialog Box Launcher, 395
disabling
Module and Class Module, 1330
unused, 1283–1284
Discard My Changes, 1232
Export To Excel, 476
Field List, 476
Filter, 385, 402
Font group, 582–583
Form view, 120
Formulas, 475
Group, 642–643
Group By, 1505
Hide Details, 476, 477
InsertSQL, 1530
Install Now, 1346
linking to related task with, 1098–1099, 1109–1114
List Box, 569
Microsoft Office, 24
Minimize/Maximize, 108, 109, 675
More Pages, 124
Move To SharePoint, 1212
New Object, 890
Print Preview Zoom, 124
Property Sheet, 176, 476
Query Design, 348, 415
Query Wizard, 348, 1524
Refresh Pivot, 476
Remove, 633
Retry All My Changes, 1232
Save, 151
Set Control Defaults, 680–681
Set Maximum Record Count, 1548, 1549, 1568
Set Unique Identifier, 237
SharePoint List, 1183, 1184, 1187, 1203, 1204
Show As, 476
Show Details, 476
Show Top/Bottom, 475
Shutter Bar Open/Close, 47
Sort Descending, 385
Special Effect, 583, 645–646
Stop Refresh, 1548, 1568
Subtotal, 475
switching views with Maximize/Minimize, 109
Table Design, 155, 1458
Tabular, 800–801
To Grid, 618
Toggle Filter, 402
Totals, 435
Two Pages, 124, 125
Use Control Wizards, 602
Views, 110
Visual Basic Editor window, 945
Work Online, 1230, 1231
XMLFile, 1246
Zoom, 737, 738