A

Access 2007, database creation, 241-55

columns, manipulating in tables, 252-55

key points, 255

manually creating databases, 245-50

overview of database creation, 241-42

rows, manipulating in tables, 252-55

tables, creating with templates, 250-52

templates for database creation, 242-45

Access 2007, data entry with forms, 257-95

arrangements of forms, changing, 268-72

AutoForm, using for form creation, 283-85

controls for forms, adding, 273-78

forms for data entry, overview of using, 257-58

Form tool, using, 258-61

key points, 294-95

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

Access 2007, information accuracy, 333-71

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

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

Access 2007, sorting and filtering, 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

Access 2007, utilities, 365

Acrobat, Adobe, 505

action queries

creating by converting select query to, 358

database accuracy by running, 333

overview of, 315

Active Appointments view, 590

active cells, 161

add (+), arithmetic operator, 306

address books

addressing messages from, 504

sending contact information, 513

addressing e-mail messages, 503-04

Adobe Acrobat v. 6 or 7, 505

Advanced Documents Inside Out, 126

Advanced Filter/Sort command, 310

Advanced toolbar, Outlook 2007, 491-92

aggregate functions, in queries, 328

aliases, e-mail, 503

alignment of text

in PowerPoint, 416-19

Word paragraph formats, 79

All Appointments view, Outlook 2007, 590, 595-96

All Attendees list, Scheduling page, 582

Allow Zero Length property, Access fields, 334

Analyze Table, Access utilities, 365

And operator, 306

Annual Events view, Outlook 2007, 590

appearance, Excel documents, 205-37

cell formatting, 206-11

images, adding, 233-36

numbers, legibility of, 222-26

overview, 205-06

styles, defining, 212-16

table styles, applying, 218-21

values, changing data based on, 226-33

workbook themes, applying, 216-18, 220-21

appearance, Outlook workspace, 484-85

appearance, PowerPoint text, 416-21

Append, action query, 315

applications, database, 241

appointments, Outlook 2007, 567-87

in calendar item windows, 568-74

defined, 574

delegating control of calendar, 613-15

key points, 587

overview of, 567-68

recurring, 574, 577-78

reminder messages, 574

responding to requests for meetings, 584-87

scheduling, 574-78

scheduling and changing events, 578-80

scheduling recurring, 577-78

scheduling, updating and changing meetings, 580-84

Appointment tab, appointment window

overview of, 571-72

scheduling appointments, 576

scheduling recurring appointments, 577

appointment window

defined, 568

opening, 569-70

tabs, 570-74

archived messages

overview of, 561

setting default automatic options, 561-65

Archive Folders data file, 565

arguments, Excel formulas, 185

arithmetic operators, 306

asterisk (*), filtering with, 302

attachments, e-mail

locating message in Inbox, 539

sending e-mail message with, 510-14

audience, PowerPoint presentations adapted to, 442-45

auditing, in Excel, 195-201

AutoArchive, e-mail messages, 562-65

AutoComplete feature, Excel data entry, 157-59

AutoCorrect feature

paragraph formatting, 89

spelling checker, 409-13

AutoCorrect feature, in PowerPoint, 405-08

AutoCorrect feature, Word documents, 56-61

AutoFill, Excel tables, 156-58

Auto Fill Options, Excel 2007, 158

AutoFit, in PowerPoint, 405-08, 416

AutoFormatAsYou Type tab, Word documents, 95

AutoForm, form creation for Access data entry, 283-85

AutoNumber field, Access fields, 338

AVERAGEIF function, 191-94

AVERAGEIFS function, 192-94

Avg, aggregate functions, 329-30