Daily Style print format, Outlook 2007, 600, 601-02
database application, 241
Database Documenter, Access utilities, 365, 368-70
databases (Access 2007), creating, 241-55
columns, manipulating in tables, 252-55
key points, 255
manually, 245-50
overview, 241-42
rows, manipulating in tables, 252-55
tables, creating with templates, 250-52
from templates, 242-45
databases (Access 2007), forms for data entry, 257-95
arrangements of forms, changing, 268-72
AutoForm, using for form creation, 283-85
controls for forms, adding, 273-78
Form tool, using, 258-61
key points, 294-95
locating information in, 297
overview, 257-58
properties of forms, refining, 262-68
subforms and forms, creating simultaneously, 292-94
subforms to forms, adding, 285-92
VBA, using for form creation, 278-83
databases (Access 2007), information accuracy, 333-71
back ups, 365-66
Compact and Repair Database, 366-67
Database Documenter, 368-70
data type settings, 334-38
deleting information from a table, 360-64
Field Size property, 338-40
key points, 371
masks for specifying data format in a field, 340-45
multi-column lookup lists, 352-56
options for controlling data entry into databases, 349
overview of, 333-34
Performance Analyzer, 367-68
preventing problems, 364-65
simple lookup lists, 348-52
updating information in a table, 356-59
validation rules, 345-48
databases (Access 2007), sorting and filtering, 268-72, 297-331
advanced filtering options, 310-13
comparing filters, sorts, and queries, 316
exercise creating form based on a query, 317-23
Expression Builder, 324
expressions, 306
filtering table information, 302-05
filtering using forms, 307-10
how Access sorts, 299
key points, 331
queries created manually in Design view, 315-16
queries created with a wizard, 324-28
queries for performing calculations, 328-31
query types, 314-15
sorting table information, 298-301
data entry using forms. See forms for data entry, Access 2007
data, Excel 2007.
See also calculations, in Excel 2007
correcting, 168-72
defining tables for, 172-75
entering, 156-60
expanding, 168-72
finding and replacing, 164-67
moving within workbooks, 160-63
overview, 155
performing calculations on. see calculations, in Excel 2007
replacing, 164-67
revising, 156-60
data lists, in Excel 2003, 173
data types, 334-38
date, inserting into text, 45
Date Navigator
creating and sending meeting request, 580-81
displaying different calendar views, 591-94
scheduling appointments, 575
scheduling recurring appointments, 578
date, regional settings for, 337
Day/Week/Month view, Outlook 2007, 590-94
delegating control, of calendar, 613-15
Delete, action query, 315
Deleted Items, Outlook mailbox folders, 485
deleting
cell formatting in Excel, 207
Excel worksheets, 139
demoting headings, Word documents, 49-51
dependents, Excel calculations, 196
design templates, for PowerPoint presentations, 380-83
Design view, Access
advanced filtering options, 310-13
queries created manually in, 315-16
desktop publishing features, 3
destination files, Excel 2007, 125
Detail, Access forms, 273-78
Dialog Box Launcher, 6
digital certificates, 473
digital signatures, 65
direction of text, 401
displaying documents
customizing Print Layout View for, 19-25
View tab, 18
View toolbar, 18
view types, 17-18
displays, using two monitors for presentations, 462-63
divide (/), arithmetic operator, 306
Document Inspector, Word 2007, 62-65
Document Map, 18, 21-25
documents, Excel 2007. See appearance, Excel documents
documents, Word 2007
closing, 16
creating, 25-26
displaying, 17-25
editing overview, 35-36
editing text, 36-42
finalizing, 61-65
finding and replacing text, 51-55
grammar error correction, 56-61
inserting saved text, 42-45
moving around in, 13-16
opening, 12-13
outlining, 48-51
previewing, 29-33
printing, 29-33
proofreading overview, 35-36
replacing text, 51-55
saving, 26-29
spelling error correction, 56-61
statistics of, 61
word usage, improving, 45-48
document window, 6
Does Not Equal command, filtering with, 305
Drafts folder, Outlook, 486
drafts, Outlook, 504-05
Draft view, Word, 18
duplicate query, 314
DVDs, creating presentation package on, 457