W

W3C (World Wide Web Consortium), 1128

warning messages

alerts for reserved words or function names, 159

data conversion errors, 232

InfoPath form, 335–336

macro actions displaying, A115

possible data truncation, 230

security, 24, 25

when deleting field definitions, 225

waste in single table design, A17-A19

Watch window

deleting watched item after finishing, 960

examining variables for errors in, 956–959

Web applications, 1127–1163

creating in HTML, 1128–1135

development tools required for, 1127–1128

difficulties working with OLE objects, 1069

dynamic Web pages, 1158–1161

delivering dynamic query results, 1158–1160

processing live data with HTML forms, 1160

using ASP for fetching data on, 1158

sharing data with SharePoint Services, 1161–1163

static HTML documents

customizing appearance of, 1143–1148

designing and using HTML templates, 1148–1151

generating HTML page from Access report, 1151–1154

static Web pages

understanding, 1137–1139

viewing, 1139–1140

XML for, 1135–1137

Web browsers.

See also Internet Explorer

allowing scripts to run on, 1245

configuring file to open after export in, 1185

connecting to Web servers using TCP/IP, 1137–1138

cross-browser issues, 1131

displaying HTML behind Web page, 1128

opening HTML files after export complete, 1147

viewing columns of custom SharePoint list in, 1205

Web protocols used by, 1138

web packages (.htm), 1237, 1243–1245

Web pages.

See also Web sites

applying tags to complex HTML, 1133–1134

browsers’ rendering of HTML tags, 1131

dynamic, 1158–1161

delivering dynamic query results, 1158–1160

processing live data with HTML forms, 1160

using ASP for fetching data on, 1158

generating from Access report, 1151–1154

HTML, editing, 1134–1135

missing graphic or background on, 1150

opening from hyperlink, 398–399

refreshing static, 1140

static

understanding, 1137–1139

viewing, 1139–1140

structure of HTML, 1128

using color names and codes on, A93

Web Parts, 1162, 1165–1166

Web sites

Microsoft Office Live, 1161–1162, 1166

Windows SharePoint Services

about sample, 1167–1168

gaining access to, 1166

illustrated, 1167

relinking list to new, 1197

well-formed XML

about, 1236–1237

building for custom Ribbon form, 1270–1271

WHERE clause

HAVING clause vs., A45

overview, A70-A71

uses of, 464

While...Wend statement, 1025

width

adjusting report field’s, 802, 804

choosing form, 565

Navigation Pane’s, 47, 103

wildcards

characters for LIKE predicate, A48-A49

searching data using, 406

used with LIKE comparison operator, 169

windows.

See also Immediate window

changing font size for Query, 467

closing without Close button, 675

Filter By Form, 555

Form, 114–121

inserting new rows in Index, 190

Layout view for Report, 125–127

Macro, 890–893

Maximize/Minimize buttons for, 108, 109, 675

moving between parts of Design view, 222

PivotTable design, 474

pop-up forms, 523–524

preventing use of controls for, 675

previewing Report, 124–125

Relationships, 187–188

Report view for Report, 127–128

Table, 107–109

undocking Visual Basic Editor, 946

Visual Basic Editor, 945

Watch, 956–959, 960

Windows Internet Explorer. See Internet Explorer

Windows SharePoint Services (version 3), 1161–1163, 1165–1233

about, 1161–1162, 1165–1166

adding columns to lists, 1175–1179

creating SharePoint list from within Access, 1198–1207

adding record to table, 1200–1201

creating custom list, 1203–1207

using existing list template, 1199–1203

creating views, 1172–1175, 1191

DAPs vs., 14

editing data in lists, 1168–1172

exporting Access data to, 1182–1186

gaining access to sites using, 1166

illustrated, 1167

importing list to Access from, 1186–1191

indicator for linked tables, 1193

linking list to Access, 1191–1195

lists in, 216

Microsoft Office integration with, 1162–1163

migrating database to SharePoint site, 1207–1233

about, 1207–1208

opening database from SharePoint, 1223–1226

steps to move database, 1212–1219

synchronizing changes after working offline, 1230–1233

ways SharePoint handles migrated data, 1218–1219

working offline, 1226–1229

publishing database to SharePoint site, 1208–1211

moving vs., 1207

publishing changes to migrated database, 1217

RecycleBin, 1179–1182, 1197

referential integrity not enforced by, 1195

republishing after changing database, 1207, 1219–1222

sample database using, 1166

sharing with, 13

user interface for, 1167–1168

using options for linked lists, 1196–1198

viewing hidden columns in SharePoint lists, 1206, 1219

Web Parts, 1162, 1165–1166

Windows SharePoint Services Web sites

about sample, 1167–1168

gaining access to, 1166

illustrated, 1167

relinking list to new, 1197

Windows Vista

Clipboard in, 395

disabling User Account Control and saving database in template folder, 197

errors authenticating SQL Server 2005 Express Edition with, 258

as event-driven operating system, 867–868

MSDE unsupported in, 1494

With…End statement, 1025–1026

WITHOWNERACCESSOPTION clauses, A34, A60

Word mail merge documents, A81-A82

word processors

exporting data to mail merge document, A81-A82

reasons to transfer data to Access from, 15–17

Work Offline button, 1227, 1228

Work Online button, 1230, 1231

workflow for SharePoint Services, 1197

working offline with SharePoint database, 1226–1229

illustrated, 1228

pencil icon displayed next to changed records, 1229

synchronizing changes in data after, 1230–1233

worksheets

application design

subjects, A14, A15, A16

tasks, A9, A10, A12

World Wide Web.

See also Web applications;

Web browsers;

Web pages

about, 1127

development tools required for, 1127–1128

protocols and, 1138

World Wide Web Consortium (W3C), 1128, 1236

WriteHTML function, 1154–1156