Online Traning Solutions - Quick Course in Microsoft Office XP

D

data

excluding from graphs 193

specifying kind of 232, 234

data access pages 275

converting tables into 275

creating, from scratch 275

creating, in Design view 275

fields, adding 275

filtering in 278

formatting 275

previewing 275

protecting fields on 277

publishing to web servers 277

saving 277

sorting in 278

viewing in Internet Explorer 277

data consolidation in Microsoft

Excel 143 “45

data markers in graphs 151

data types 224 “26

database design, referential integrity. See referential integrity

databases 212

mailing labels, creating 274

opening 242

Datasheet command (Graph) 193

Datasheet view 218

datasheets

column width, adjusting 194

excluding data from 193

query 258

query, editing 263

selecting cells 192

date. date fields

date and time, setting 311

date fields 68

freezing 68

inserting 68

reformatting 68

Date Navigator 310, 315

dates

arithmetic with, in worksheets 104

entering, in worksheets 104

formatting 68

formatting, in worksheets 105, 113

declining task requests 341

Decrease Indent button 170

default

font, changing 32

save folder, changing 32

values 228

Default Value property 228

defining

range names 121

styles 85

delegating tasks 340

Delete key, deleting slides with 171

Delete Record button 224

Deleted Items folder (Outlook) 294

deleting

address cards 302

appointments 322

autoformats 114

AutoNumber fields 224

AutoText/AutoCorrect entries 41

bulleted items 170

categories 304

cells, in worksheets 112

comments, in worksheets 110

e-mail messages 293, 294

events 322

fields, from queries 261

fields, in tables 242, 268

forms, custom 306

graphs 155

headings 51

holidays, from Outlook Calendar 312

lines, in tables 91

meetings, from calendar 329

Office shortcut bar items 350

Outlook contacts 302

paragraph marks 69

records 224

section breaks 76

slides 171

table cell contents 92

table columns /rows 92

table relationships 255

tables 92

tasks 336

text 21, 42, 69

words 22, 42

worksheet columns/rows 112

worksheets 137

Demote button (Outlining toolbar 170

Demote button (Outlining toolbar) 51

Demote to Body Text button (Outlining toolbar) 51

demoting

headings 50

items 170

text 170

description of field, entering 226

deselecting ranges 106

design templates. See templates

Design view 225

designing forms, for Outlook contacts 306

dialog boxes, help with 30

dictionaries 62 “63

digital signatures, attaching to e-mail messages 285

display, customizing 9

displaying

address cards, in detailed view 305

Deleted Items folder (Outlook) 294

formulas 118

Office shortcut bar 346

Office shortcut bar, after minimizing 347

Outlook Calendar 310

Outlook Outbox 286

Outlook Today 312

sent e-mail messages 293

subdatasheets 255

tables, in Design view 242

task list, detailed 338

workbooks, multiple 134

distribution lists, setting up 300

docking toolbars 14, 245

document, moving to end of 23

Document Map 49

documents. See also files

browsing 54

closing 21, 33

combining 71

converting, into Web pages 361

copying between 70

creating 18

creating, based on templates 66

creating new from existing 17

editing 42

embedded/linked, making changes to 357

fields. See fields

finding 32

hyphenating 86

inserting 71

jumping to specific location 55

justifying 86

managing in dialog boxes 32

merging 71

moving to beginning of 25

moving to end 70

multiple pages in 79

naming 17

opening 19, 69

outlining 46

password protecting 32

previewing, as Web pages 360

previewing, for printing 27

print layout, viewing. See Print

Layout view printing 27, 29

publishing, as Web pages 360

saving 16, 22, 37

saving, as templates 66

saving, as Web pages 361

saving, with new name 17, 71

spell-checking 59

viewing multiple 20

viewing, with Document Map 49

double-clicking 2

drafts of e-mail messages, saving 285

drag-and-drop editing 44

copying formulas with 140

copying text with 44

copying worksheet entries with 109

turning on/off 44, 45

Draw button 188

Draw Table button (Tables and Borders toolbar) 91

drawing

lines 74

lines, in forms 248

shapes 184

on slides 207

tables 91

Drawing toolbar 182

due dates, task 332, 334

sorting by 337

duplicating formatting. See Format Painter