T

Tab key, 242

table borders, 297–298

table of contents for notebook, 98

Table Design command, 855

table styles for presentations, 539

table templates, 851–855

about, 851–852

creating and modifying, 853–854

types of, 852–853

Table Tools tab (Word), 25

Table Wizard, 853

tables

borders for, 297–298

building OneNote, 117–118

building queries from, 905–907

creating in Design view, 855–856

database limitations for, 901

designing database, 842, 891–895

entering data in, 849–851

fields

choosing for reports from multiple queries or, 1040

defining for, 856–857

designing for, 866–867, 894

naming, 859

indexes, 888–891

joining on zero-length strings, 866

linking, 881

opening in Relationships window in Design view, 888

placing in floating frames, 266

presentations

adding to, 537

copying Word or Excel tables to, 538

drawing in, 537–538

using Access tables, 604

using Excel tables, 602–603

primary keys assigned automatically, 851

printing definitions of, 899–900

relationships between queries and, 885–886

saving new, 851

shading for, 298–300

showing revisions in, 329

sorted by primary key in Datasheet view, 957

structured references to, 421

subdatasheets in, 879

templates for, 851–855

validation rules for, 875–878, 938–940

Tables And Related Views category (Access), 791–793, 794, 799, 803

Tablet PC

handwriting notes on OneNote page, 116

using text mode for Groove chats, 146

voice and handwritten comments, 302, 314

tabs.

See also Ribbon;

and specific tabs

about, 7, 24, 28–30

Borders And Shading dialog box, 278

defined, 630

displaying Access documents, 827–828

groups on Access, 784–787

inserting with Tab key, 242

making Text Box Tools active, 267

Ribbon

adding group to built-in, 1180–1182

custom, 1176–1180

minimizing from, 787

scrolling through, 783

setting up UserForm tab order, 1137–1138

tabular control layouts, 1059, 1062–1063

Tabular Form for PivotTables, 496

tags, note, 103–105

Target property (Outlook), 668, 674

task lists, 81

task panes, 27

tasks

adding reminders to received messages, 679

Daily Task List, 634

managing in Outlook, 647–648

to-do items for outgoing messages, 680–681

templates

Access online, 763, 764, 843–844, 845

adding OneNote page, 99–100

backing up customized, 215

Client notebook, 92

creating PowerPoint, 583–585

database, 842–847

default database, 895–899

defined, 583

downloading diagram, 580

notebook page, 100

from Office Online, 17

.potx file extension for, 584

predefined custom categories in Access, 796

saving

Groove workspaces as, 204

PowerPoint chart, 581

Word page setup defaults to, 213–214

slide master, 534–535

table templates in Access, 851–855

validating authenticity of downloaded, 845, 846

workspaces based on, 86–87

testing

and debugging VBA macros, 1123–1124

Groove forms, 202–203

query validation rule changes, 937–940

VBA syntax in Immediate window, 1131

text.

See also special characters;

text boxes

annotating notebook images with, 116

configuring comment balloon, 315

converting bulleted lists to graphics, 553–556

copying outline headings without, 244

creating long values in Excel, 357

deleting

linked text boxes without losing, 273–274

in Reviewing pane, 314

editing and formatting XML, 1165–1167

effects in WordArt, 552–553

emphasizing with shading, 298–300

entering

in Excel, 354

Groove, 160–161

flowing, 262, 270–271

formatting in text boxes, 265

grammar checking, 266, 558

highlighting, 305

including with Excel numeric entries, 358–359

inserting

into text boxes and shapes, 264–266

as watermark, 260

Mini toolbar appears when selected, 38

notes, 100–103

numeric text in formulas, 402

PowerPoint

character spacing for, 547, 550

finding and replacing, 548–549

headers and footers for, 556–558

placing pictures before or behind, 564–565

proofing tools for, 558–559

styling, 547

WordArt formatting for presentations, 551–553

writing on slides during presentation, 556

tracking changes in, 325–327, 329

text box controls

inserting in reports, 1034

resizing in Layout view, 1059

Text Box Tools tab

linking text boxes when missing, 274

making active tab, 267

text boxes

adding

to Groove sketch, 165

to slide, 545–548

borders for, 263, 274

breaking links between, 273

changing

manually to combo box, 1012

shapes of, 269

text orientation within, 268, 269

controlling

space around AutoShapes and, 268

text in, 268

copying or moving linked, 272–273

creating, 263–264

deleting linked boxes without losing text, 273–274

flowing text between, 262, 270–271

formatting, 267–270

identifying, 274

illustrated, 263

inserting text into, 264–266

items unusable in, 265–266

linking when Text Box Tool tab missing, 274

maximum linked in document, 270

modifying properties for form, 994–995

moving

between linked, 271–272

and sizing controls in, 990–991

resizing automatically to show content, 269–270

selecting for copying, 272

spelling and grammar checking in, 266

switching between floating frames and, 266, 267, 274

using, 262–263

word count statistics for, 271

Text button, 466

text containers.

See also AutoShapes;

text boxes

defined, 262

floating frames, 266

Text data type, 858–859

 Text editing.docx sample file, 1165

text expressions, 918–919

Text Fill menu, 552

TEXT function, 467

text functions, 466–471

CHAR and CODE, 468

CONCATENATE, 471

defined, 466

DOLLAR, 467

EXACT, 468

LEN, 467

MID, 470

REPLACE and SUBSTITUTE, 470

RIGHT and LEFT, 470

TEXT, 467

TRIM and CLEAN, 466,468

UPPER, LOWER, and PROPER, 466, 469

text pane

appears next to SmartArt graphic, 554

indenting lines in SmartArt, 555

unable to find for SmartArt graphic, 569

text value arguments, 457

text values, 402–403

text wrapping

adding breaks in Word, 217, 218

cell, 357

text-alignment prefix characters, 358–359

Thawte, 690, 708

Theme Colors section (color palette), 283

theme folder, 1152,1157

theme fonts

applying in Word VBA, 1105

creating PowerPoint, 550–551

themes

compatibility with earlier PowerPoint versions, 600

PowerPoint’s use of, 14, 535–536

saving document, 536–537

3-D formulas, 419–420

3-D names, 414–415

3-D references, 419, 420

three-dimensional arrays, 436

thumbnails, 619

time

Access functions for, 932

comparing values with Between, 917

four-digit year formatting for, 891–892

grouping PivotTable items by, 513–515

separators for input masks, 871

using as query selection criterion, 912–913

timestamping macros, 56

timing of slides, 613–614

titles

adding to report in Report Wizard, 1044–1045

including in Access report headers, 1028–1029

turning on/off, 541

To-Do Bar (Office), 14, 632

toggle buttons, 981, 1015–1016

toggle commands in VBA macros, 1102

toggling between UserForm and code, 1139

toolbars

adding digital signature button on, 699

Mini, 38–39, 549, 554

tools.

See also add-in tools

Chat, 145–146

Discussion, 153–155

document markup, 302–304

Files, 157–158

Forms, 194–203

Groove

adding to workspace, 150–151

alerts for, 186

Calendar, 151–153

opening, 153

Highlight, 304

Issue Tracking, 158–160, 194, 195

markup, 303–304

Meetings, 155–157

OneNote writing, 116

outline, 241

Pictures, 162–163

PowerPoint proofing, 558–559

SharePoint Files, 158

Sketchpad, 163–165

Word markup, 302–304

Top 10 Filter dialog box, 504–505

totals

adding to report records in Layout view, 1066–1069

configuring Access, 1028

PivotTable, 498–499

report, 1023–1031, 1042–1043

Track Options dialog box, 310–311

tracking

changes, 323–334

accepting and rejecting edits, 330–334

appearance of changes, 327–330

comparing documents, 334–335

display options when, 323–324

finding and removing changes, 62, 64–65

limiting edits to tracked changes, 327

mark up saved as Web page, 334

moved text and inline shapes, 329

optimizing readability of changes, 311

printing marked-up documents, 333–334

privacy options for, 60

saving before resolving edits, 331

showing revisions in tables, 329

version history of file, 338

viewing properties for resolving edits, 331–332

while editing, 325–327

events

Notes folder for Outlook, 649

Outlook journal for, 648–649

issues in Groove, 158–160

slide changes, 586

Tracking Changes Options dialog box, 316–317

TRANSPOSE function, 484

TRIM function, 466, 468

troubleshooting

borders

print incorrectly, 292

too little contrast in double line, 282

can’t find Insert, File command, 265

can’t find SmartArt text pane for graphic, 569

can’t open workbooks, 390

changes to worksheet-level names, 411

circular references in Excel, 430–432

Compatibility Checker warning messages, 601

concatenated date becoming serial number, 471

content copied from Access unreadable in PowerPoint, 604

errors

in  customUI.xml file, 1182

returned for some VBA properties, 1090

Excel table copies only as picture, 603

forgotten document passwords, 313

headings don’t show up in Outline view, 239

incorrect formula calculations, 356

incorrect input masks, 874

increasing roaming profile logon time, 653

length of recorded macros, 1081–1082

linking text boxes when Text Box Tool tab missing, 274

missing object properties or methods in VBA, 1102–1103

multiple-monitor support for Presenter view, 620

#NAME? error, 460

objects left in Word header/footer with loops, 1110

page breaks

too many in outline, 251

unwanted, 219

PowerPoint sound effect or movie disappeared, 574

problems exporting private keys, 696

publishing to Slide Library, 542–543

results of IS functions, 475

rounded values in calculations, 433

running Microsoft Office Diagnostics, 1198–1199

sound or movie not playing correctly, 573

Theme fonts and colors in Word VBA, 1105

variable type doesn’t work, 1096

Word File Versions feature unavailable, 338

workspace options not visible, 82

XML syntax errors, 1148

ZIP package won’t open in Word, Excel, or PowerPoint, 1162

TRUE function, 457

TRUNC function, 466

Trust Center

Access’ use of, 776

ActiveX control security settings, 56–57

allowing downloading of updates, 1199

configuring content blocking in, 688

illustrated, 47

managing connections to external content, 47

opening, 778–779

PowerPoint security options in, 527

preventing macro viruses, 661

privacy options in, 58–60

reviewing digital signature validity, 50–51

setting up e-mail security, 699–700, 701, 703

Store Random Number To Improve Combine Accuracy feature, 1146

trusted locations

creating and managing, 51–53, 606–608, 781–782

running documents from, 51

Trust Center category

Access Options dialog box, 837–838

PowerPoint Options dialog box, 527

trust relationships, 706–707

Trust tab (View Certificate dialog box), 706–707

trusted locations

about, 606, 779–780

adding, 52

creating PowerPoint, 606–608

defined, 51

defining Access, 781–782

modifying, 53, 608

removing, 53, 607–608

running documents from, 51

trusted publishers

about, 779

defined, 48

setting up PowerPoint, 609

trusted sites

configuring alerts on Outlook for, 744

permitting downloads from, 689

SharePoint verified as, 737

Trustworthy Computing, 776

turning on/off

automatic recalculation, 429

enabling detection of spoofed Web sites, 60

fill handle, 342

Function ScreenTips, 456

Groove message alerts, 138, 185

linked data, 440

links to sections when deleting headers/footers, 229

multiple-monitor support for Presenter view, 620

Navigate Together option, 144

slide titles and footers, 541

structured reference creation, 421

Track Changes, 326

untrusted databases, 777–778

Version History, 734

twip, 1164

two pages per sheet setting, 222

two-dimensional arrays, 436

TYPE function, 474