Access.2007.VBA.Bibl..

phone numbers

code for updating in Access, 387–388

synchronizing, 353–354

PivotCharts, Access

assigning fields, 22–23

creating, 22–25

displaying legend, 24

versus Excel PivotCharts, 415, 419, 425

interactivity, 24

naming axes, 23

PivotCharts, Excel

versus Access PivotCharts, 415, 419, 425

assigning titles, 421

creating from Access queries, 415–426

creating from Excel worksheets, 417–418

creating manually, 415–423

formatting axes, 419–420

layout, 419–423

most popular types, 423

selecting style, 421–426

viewing all types, 423

PivotTables, Access

creating, 19–21

interactivity, 24

PivotTables, Excel, 415, 417–418

Polar chart type, 425

PostNet bar codes, 152–153

PrintInvoice.vbs script, 612–614

PrintReport.vbs script, 611–612

procedures

versus functions, 481

starting by declaring variables of different types,

236

Products to Reorder report, 430, 431–432

Project Explorer, 436, 463, 503, 506, 607

Properties command, Office menu, 148

property builders, 480–481

Q

qryContactIDsPhonesquery, 368

qryContactsquery, 191

qryContactsForMergequery, 144

qryNeedTimesheetsquery, 202

qryNorthwindAllquery

creating PivotCharts from, 22–25

creating PivotTables from, 19–21

creating plain datasheet report from, 11–19

as data source, 50, 51, 52

qryOrdersAndDetailsquery, 62, 63

qryThisWeeksTimesheetsquery, 202

queries, Access

calculated fields, 370–371

complex, 352

creating Excel PivotCharts from, 415–426

creating PivotCharts from, 22–25

creating PivotTables from, 19–21

creating plain datasheet report from, 11–19

as data sources, 50, 51, 52

exporting to Excel, 415–416

formatting data in Excel worksheets, 62–69

ListQueryFieldsfunction, 495–497, 511,

513–514

make-table, 109, 201, 205, 348

qryContactsquery, 191

qryNeedTimesheetsquery, 202

qryOrdersAndDetailsquery, 63

qrythisWeeksTimesheetsquery, 202

upsizing, 660–662

using as basis for exporting Access data to Excel,

191, 192

using to concatenate Access data for export,

143–144

QueryDefobject, 104–106, 109, 113, 130

QueryDefs collection, 495, 522, 544

R

read-only lock type, 118

recordsets

in ADO object model, 116–129, 130

ADO versus DAO, 92, 116, 130

creating by using Command object, 113–116

creating connections to external databases,

111–112

cursor types, 117

cursor/lock type combinations, 121–122

in DAO object model, 99–103, 130

P Index

25_047026 bindex.qxp 4/2/07 9:58 PM Page 690