Index_D

D

DAO (Data Access Objects), 207

data

address data, concatenating and splitting, 335

denormalizing, 351–355

electronic, 4

exporting from Access to Outlook items, 434–437

gathering, 4–5

name data

concatenating and splitting, 335

fields, adding additional, client-requested changes, 274–277

FirstNameFirst variable, 67

LastNameFirst variable, 67

redundant, eliminating, 31–32

repeating, eliminating, 31

sorting, in datasheets, 400

tabular, TypeText method, 375

Word data, importing into Access, 413–417

writing to text files, 555–556

Data Access Objects (DAO), 207

data entry forms, 40

Data Entry property, 232

data source queries, 156–157

data types

date/time, 23–24

mismatched errors, 130

primary, 16–18

variables and, 288

Variant, 404

database tag (dbs), 293

Database toolbar, 365

Database Window button (PivotChart toolbar), 172

databases. See also tables

data, gathering, 4–5

entities, determining, 5–7

flat-file, 31

objects

copying, 340

identifying, 5

ODBC (Open DataBase Connectivity), 147

procedures, reviewing, 5

data-definition queries, 19

datasheet forms

columns, resizing, 64

mail merge documents, 399–403

overview, 40

DataWindow button (PivotTable toolbar), 166

date

current date, displaying, 409

date range code, main menu, 226–227

date/time data type, 16, 23–24

date/time tag, 292

FromDate function, 227

ToDate function, 227

DateAdd function, 226

DateTimePicker control, ActiveX, 117

dBASE file, linked tables, 10

dbl tag (double), 292–293

DblClick event procedure, 241–242

dbs tag (database), 293

DDE (Dynamic Data Exchange), 531, 543

DDL (Dynamic Data Language), 149

Debug toolbar, 216

Debug.Print statements, 215, 438

declaring variables, 443

DefaultItemType property, 460

Delete button (PivotChart toolbar), 172

delete queries, 146–147

deleting

colons, from labels, 58

fields, from tables, 150

indexes, 151

records, from tables, 340

tables, 151

denormalizing data, 351–355

dependencies, objects, 250

descending sort order, 122, 165, 172

design principles, reports, 175–176

Design Schemes add-in, 44–45

Design view

New Query dialog box, 333

New Table dialog box, 8–9

dialog boxes

Access Page Setup, 190

Add Reference, 258

Add-In Manager

Add New button, 44–45

Change Menu Picture option, 206

Create Main Menu option, 206

discussed, 44

Refresh Lookup Tables option, 206

Append, 138, 333

Choose Builder, 51, 301

Choose Database, 296

Conditional Formatting, 198–199

Custom Paper Size, 190

Customize, 365

Dynamic Contact Search, 237

Edit and Send Fax, 539

Edit Relations, 35–36

Email Access Report, 471–472

Export Contacts to Outlook, 557

Export to Word, 94, 382

Expression Builder, 68–69

Fax Access Report (DDE) dialog box, 543, 545

Field Chooser, 429

Format WordArt, 203

Forms to Rename, 299

Import, 330, 488

Import from Excel, 526–528

Import from Outlook, 483

Import from Word, 413–414, 419

Insert Picture, 110

Join Type, 352

Link, 529

Lock Wizard, 48–49, 74

Menu Sidebar Picture Picker, 208–209

Microsoft Outlook, 439

New Form, 45

New Query

Design view, 333

discussed, 134

Find Unmatched Query Wizard option, 338–339

New Object button, 140

New Report, 176

New Table

Datasheet View, 8–9

Design view, 8–9

Import Table option, 9, 329–330

LinkTable option, 9–10

Table Wizard, 9

Options

Advanced tab, 252

discussed, 24

File Locations tab, 421

Page Setup, 191

Paste Table As, 352

Queries to Rename, 299

References

accessing, 255

Browse button, 258–259

discussed, 207, 365

SafeOutlook Library option, 493

WinFax Automation Server option, 550

Save PDF File As, 544

Show Table, 35

Sorting and Grouping, 327

Tables to Rename, 297

dialog forms

discussed, 41

sending faxes, 538

displayed system objects (zs tag), 290

displays, forms, 43–44

distortion, images, 208

Do Until...Loop statement, 219

Do While...Loop statement, 218–219

doc properties (document properties), 374

DocsDir function, 424

Document option (Word object model), 367

documents

creating, 377–380

merging, 224

Word

doc properties (document properties), 374

list of, 363–364

Documents path, mail merge documents, 382

double tag (dbl), 292–293

Drill into button (PivotChart toolbar), 172

Drill out button (PivotChart toolbar), 172

DROP statement, 151

drop zones, PivotTables, 157

dtm tag (date/time), 292

Dynamic Contact Search dialog box, 237

Dynamic Data Exchange (DDE), 531, 543

Dynamic Data Language (DDL), 149