L

labels

adjusting Form Wizard, 599–600

creating shadowed effect behind, 650

deleting and attaching control, 581

highlighting against dark background, 587–588

lining up custom form, 619–622

mailing

Avery label formats, 754, 1117

printing with data from multiple tables, 463–468

setting up multiple-column reports as, 753–754

using partial page of, 1115–1118

PivotChart display, 482–483

printing company and contact, 754

report column, 770–771

sizing to fit form content, 612–616

landscape orientation for reports, 751, 752, 755

Last function, 437

layout

justified formats for forms, 597

modifying in SharePoint Datasheet view, 1178

selecting choices for data in Form Wizard, 697

selecting Report Wizard report, 781–782

Layout view

aligning and positioning controls in, 623–642

adding control padding, 638–640

advantages in, 623, 642

completing form design, 640–642

control anchoring, 624–625

dragging and dropping field, 623–624

dragging selected controls to new column, 634–635

formatting column of controls, 630–631

incorrect field positioning on form grid, 627

lining up controls, 625–626

moving controls within control layout, 626–630

placing controls into control layout, 635–638

removing control layout, 632–635, 640–642

resizing controls, 631–632, 640

building reports in

adding grouping and sorting, 792–796

adjusting width of contact field, 802

applying AutoFormat, 807–809

positioning fields with vertical I-bar, 802–803

resizing text box controls, 797–798

selecting record source, 791–792

starting with blank report, 790–792

totals added to records, 804–807

usefulness of, 797

working with control layouts, 797–804

disabling, 1304

events unavailable in, 873

forms

horizontal ruler unavailable for form grid, 633

polishing subform design, 698–700

preventing users from opening in, 671

working with desktop database, 118–119

modifying Report Wizard reports in, 784–790

accenting detail with background color, 788–789

changing control properties, 787, 788

resizing columns and fields, 784–785, 786

resizing and repositioning controls, 785–787

opening Form window in, 563

project forms and reports unsupported in, 1552

viewing desktop database reports in, 125–127

left arrow button (<), 593

Left Arrow key, 392

left joins, 1502

LEFT [OUTER] JOIN statement, A42

legends for PivotCharts, 480–481

less than or equal to sign (<=)

comparing values with, 168, 169

returning query results with, 1503, A42

less than sign (<)

comparing values with, 168, 169

indicating lowercase characters, 655

returning query results with, 1503, A42

licensing agreements for SQL Server 2005 Express Edition, 1350

LIKE operator, 169, 360–361

LIKE predicate, A48–A49

Line tool, 642, 644

lines

adding to custom forms, 642–643

ensuring straight, 643

formatting control’s border, 583–584

inserting in report, 771, 773

Link Child Fields property, 705, 706

Link Master Fields property, 705, 706

Link Tables dialog box, 297

Linked Table Manager, 303–304, 1323

linked tables

designing, A28

for desktop database, 1320–1328

splitting tables with Database Splitter wizard, 1320–1323

verifying and correcting linked table connections, 1323–1328

fields of

defining, 181–183

one-to-many relationships with, 184

indicator for SharePoint Services, 1193

linking

with other Access databases, 295–298

SQL tables to Access databases, 301–302

modifying, 302–303

unlinking, 303

linking data, 1098–1104.

See also linked tables

about, 292

button for, 1098–1099, 1109–1114

Connect property when, 297

dBASE and Paradox files, 298–299

default record locking settings for, 294, 295

disconnecting from SharePoint Services when working offline, 1227–1228

errors with, 301

icon for linked data source, 260

importing vs., 259–260

linking

forms with filter, 1098–1099

to report with filter, 1099–1101

performance considerations for, 293–295

PivotChart to form, 733–734

reasons for, 253

security information when, 293

SharePoint lists

to Access, 1191–1195

maintaining link to User Information List, 1194

options for, 1196–1198

subforms

automatic, 706

setting data relationships for, 705

synchronizing two forms with class event, 1101–1104

text or spreadsheet files, 300–301

unable to connect to database with multiple data sources, 302

List Box button, 569

list boxes

about, 527–528

combo boxes vs., 528

formatting properties for data display, 651–661

illustrated, 528

keyboard shortcuts for, 543

multiple-selection, 1082–1086

Size To Fit command unavailable for, 614

List Options submenu for Windows SharePoint Services, 1196–1198

List Width lookup property, 244

lists in SharePoint, 216

adding columns to, 1175–1179

built-in views for, 1173

creating from within Access, 1198–1207

creating custom list, 1203–1207

using existing list template, 1199–1203

defined, 1168

deleting, 1198

editing data in, 1168–1172

importing to Access from SharePoint Services, 1186–1191

linking to Access, 1191–1195

missing records in imported, 1191

modifying design of, 1196

password protection for linked, 1198

permissions for, 1197

relinking to new site, 1197

restoring items to, 1181–1182

similarity between Access tables and, 1169

using options for linked lists, 1196–1198

LoadCustomUI method, 1285–1286, 1287

loading.

See also randomly loading data

frmProductAdd form, 1061

images into custom Ribbon controls, 1299–1300

Ribbon into Access data projects, 1286

times for form and report modules, 944

USysRibbons table during startup, 1267–1268

XML for custom Ribbon, 1284–1287

Locals window (VBE)

about, 946

examining variable and object values in, 955

illustrated, 945

Location dialog box, 1214

Locked property for controls, 584–585, 662

locked record errors, 512

locking

button on form, 573

controls, 584–585, 662

query records, 462

log in as system administrator, 1452

logic functions, A88

Lookup properties, 240–245

cautions using for fields, 242

defining query, 353

number values and sorting of, 381

overview of, 243–244

lookup values

avoiding data collection fields defined as, 324

eliminating duplicate, 238

including in HTML form, 324–325

unable to specify for SQL Server 7.0 tables, 1470

Lookup Wizard, 158, 245

loops

Change events contributing to endless, 873

defining multiple executions with Do...Loop statement, 1017–1018

executing code within For Each, 1020

Lotus 1–2–3. See spreadsheets

lowercase characters (<), 655