1341
Index
viewing data. See datasheets; forms; reports.
views
description, 1189
SQL Server, 1217–1219
switching, 219
Views group
Access 2010 ribbon, 36
Datasheet ribbon, 219
Form ribbon, 291–292
virtual memory, troubleshooting, 920
visibility, toggling on/off. See hiding/showing.
Visible property, 682, 684
Visual Basic for Applications (VBA). See VBA (Visual Basic for
Applications).
Visual Basic.NET, 379
Visual Web Developer, customizing the ribbon, 1042–1044
volume information, getting, 958–959W
w:, formatting day of the week, 63
watches
conditional, 547–548
setting, 545–547
Watches window
conditional watches, 547–548
description, 545
docking, 547
editing watched expressions, 548
floating, 547
maximum number of watches, 548
setting watches, 545–547
Web hosting. See Access Services; SharePoint.
Web publishing
new features, 1258
SharePoint deployment, 1156–1157, 1164–1173
Web servers versus application servers, 1190–1192
Week property, 362
WHERE clauses, 475, 484
Where Condition argument, 1061
Where options, 656
While clause, 404–405
white space, inserting in reports, 731–733
Whole Group option, 363
Width property, 307, 683
wikis, creating, 1112–1115Dim keyword, 421, 425–426
lifetime, 434–435
naming conventions, 394, 422–423
spaces in names, 423
storing expression results, 421
string, maximum size, 429
values, displaying, 412
variants, 423–424, 428, 430
VBA variables, data types
Boolean, 428
corresponding Access data types, 428
Currency, 428
Date, 428
Decimal, 428
default, 426, 430
Double, 428
Integer, 428
Long, 428
Object, 428
Single, 428
specifying, 422
String, 428
supported by VBA, 428
Variant, 428, 430
VBA variables, declaring
declarations section, 394, 427
explicitly, 424, 430
forcing explicit declaration, 394, 411, 431
implicitly, 423, 430
importance of, 424
overview, 421–425
VBA variables, scope
definition, 432
global, 426
local, 426
private, 427, 432–434
Private keyword, 427
public, 426, 432–434
Public keyword, 426
verifying data. See data validation rules.
verifying forms, 466–468
versioning, SharePoint, 1138
vertical lines between report columns, 729–730
video, data type. See OLE Object data type.
View argument, 1060
ViewChange event, 46452_475348-bindex.indd 134152_475348-bindex.indd 1341 4/1/10 2:02 PM4/1/10 2:02 PM