B


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




Microsoft Office Access 2007 Inside Out
MicrosoftВ® Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out)
ISBN: 0735623252
EAN: 2147483647
Year: 2007
Pages: 234

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net