Online Traning Solutions - Quick Course in Microsoft Office XP

T

tab order in forms, setting 248

tab scrolling buttons 100

table relationships

adding 254

creating 249, 250

deleting 255

editing 252, 255

one-to-many 249

referential integrity 249, 252 “53

saving 252

Table Wizard 215, 224

tables 89

adding to queries 261

aligning 92

borders 94

borders, adding 95

calculations in 92

cells . See cells, table

columns . See columns, table

converting, into data access pages 275

copying 268

copying records between 243

copying structure of 242

copying, to create new tables 268

creating 89, 90

creating, with Insert Table button 90

creating, with specific column widths 91

creating, with Table Wizard 214

deleting 92

displaying, in Design view 242

drawing 91

drawing lines in 94

editing 242

editing related data in 254

entering data 91

entering records in 218

exporting to Excel 352

fields, deleting 242, 268

fields, finding specific 258

formatting 91, 93

functions 92

gridlines, turning on/off 94

inserting 90

lines, formatting 94

lines, removing 91

moving 92

moving in 91

navigating 91

pasting structure of 242

query datasheets 258

records, finding specific 260

records, finding with multiple criteria 264

restructuring 227

rows. See rows, table

running queries on multiple 265

sample 216

saving 243

saving as Excel documents 352

selecting 93, 94

structure 224

styles, applying 91

titles, entering 90

updating, with queries 267

width/height, changing 90

wrapping text in 92

Word, graphing 354

task list

adding tasks to 331

detailed, displaying 338

editing tasks in 334

opening 331

sharing 334

sorting 337

viewing 334

Task panes, Slide Layout 190

task requests

creating 340

responding to 342

taskbar

activating windows from 20, 70

auto-hiding 3

document buttons on 20

turning on/off 3

TaskPad 311, 331

tasks 330

accepting/declining 341

adding to task list 331

assigning 340

assigning to categories 337

completed, deleting 336

completing 335

creating 331

creating, from appointments 331

creating, from e-mail messages 331

delegating 340

deleted, recovering 336

deleting 336

details, viewing 332

due dates, assigning 332, 334

editing 334

list. See task list

marking as complete 335

organizing 336

ownership 341

priority 332, 334

reassigning 342

recurring, creating 333

reminders, setting 333

requests. See task requests

sorting 337, 339

start time, changing 333

status reports , requesting 341

switching views 331

TaskPad. See TaskPad

tracking others 342

tracking progress 335

views for 339

templates 66, 163

applying 66

creating 66

creating documents from 66

creating presentations

with 163

customizing 66

design 163

filling in 68

installing on demand 68

Normal. See Normal template

previewing 66

switching 178

testing referential integrity in tables 253

text

adding to graphs 200

aligning, with Click and Type 32

bold 15

centering 26, 72

completing automatically. See AutoComplete

converting into lists 79

copying 22

copying between documents 70

copying, in slide view 174

copying, with drag-and-drop 44

correcting, automatically. See AutoCorrect

cutting and pasting 22, 23

deleting 21, 42, 69

demoting 170

editing 21, 42, 168

effects. See text effects

entering 5. See also entering text

entering in templates 68

entering numbers as, in worksheets 103

finding 53

finding, options 57

font. See font

formatting 70

formatting as columns. See columns

greeked 165

hidden. See nonprinting characters

highlighting. See selecting justifying 26

left-aligning 26

moving 22, 44

moving, in slide view 174

moving, with drag-and-drop 44

overtyping 43

pasting 70

promoting 170

replacing 21, 42, 43, 53, 56

replacing, automatically. See AutoCorrect

right-aligning 25

selected, copying 46

selecting 6

selecting all 23

storing. See AutoText

underlining. See underlining

wrapping 5. See also word wrapping

wrapping in tables 92

text areas 166

Text Box button 200

text effects 203

small caps 73

themes, applying to Web pages 363

thesaurus 61

thumbnails 167, 175, 176

tiling windows 134

time management. See Calendar (Outlook)

times, entering, in worksheets 104

title area 168 “69

title slides 162

titles

adding to slides 165

breaking, manually 73

formatting 72

graph, adding 197

repositioning 166

of Web pages, changing 362

toggle buttons 15

toggle commands 10

toolbar buttons 11, 13

adding/removing 32

hidden, displaying 15

vs. menu options 13

Toolbar Options button 13

toolbars 11

buttons. See toolbar buttons

customizing 11

customizing, for Office shortcut bar 349

docking 14, 245

Drawing 182

expanding 32

floating. See floating toolbars

hiding, on Office shortcut bar 349

move handles. See move handles

moving 14

on Office shortcut bar, adding folders to 349

on Office shortcut bar,

removing buttons from 350

restoring to original settings 32

right-clicking 12

ScreenTips. See ScreenTips

Slide Sorter 176

turning on/off 10, 12, 151

Toolbox toolbar 248

totaling table values 93

totaling values with SUM function 119

tracking

Outlook contacts 307

task progress 335

tasks, assigned to others 342

transitions. See also special effects

turning off

AutoCorrect 42

default saving of sent e-mail messages 294

Office shortcut bar 350

Outlook preview pane 290

signatures 284

worksheet outlines 144

turning on/off

AutoFormat As You Type 78

drag-and-drop editing 44, 45

Extend Selection mode 45

gridlines in tables 94

Overtype mode 43, 44

smart cut and paste 45

type of graph, changing 194