F

fast saves, 593

faxes

MAPI used with, 655

receiving, 637, 643

sending, 643

 Fearless logo.png sample file, 1171, 1173

field codes in headers and footers, 227

field lists, 974, 983–984

Field Properties dialog box, 197

Field Settings dialog box, 500–501

fields

adding Description properties for table, 856

attachment, 889

captions for, 910–911, 933–934

concatenating in expressions, 918

data types for, 857–861

database limitations for, 901

defining

Access table, 856–857

index on single, 888–889

for linking table, 882

report groups with, 1024–1025, 1054–1055

designing table, 866–867, 894

dragging and dropping on form, 988–989

Groove system, 196

naming, 859, 918

Null, 866

PivotTable

applying multiple summary functions to, 506

dragging in, 495

filtering, 502–505

labels for, 497

rearranging in, 493–495

renaming, 498

placing in floating frames, 266

properties on Access General Tab, 861–865

renaming table template, 854

resizing report, 1046–1047, 1059–1062

selecting

in Form Wizard, 1003–1004

multiple form, 989–990

in Report Wizard, 1040

setting query’s properties for, 909–911

specifying

in queries, 907–909, 933–934

selection criteria for query, 911–912

sorting criteria in Report Wizard, 1042, 1043

unable to create subtotaled item in, 511

validation rules

defining, 868–870, 877

errors with missing validation text, 865

properties for, 863

testing changes to, 937–938

file formats. See also Open XML Formats

.accdb, 841

.aiff, 573

.asf, 1149, 1165

.au, 573

.avi, 575

default database, 894–895

.dotm, 214

.dotx, 214

macro-enabled, 11

macro-free .docx files, 1152

.mdb, 861

.midi, 573

.mp3, 573

.mpeg, 575

.ost, 652

PDF, 530–532

.potx, 584

PowerPoint, 527–532, 543

.pptx, 528, 529

saved Web page background elements, 259

selecting default database, 894–895

sound formats compatible with PowerPoint, 573

viewing all, 1149

.wma, 111

.wmv, 111

“x” added to new XML, 11

.xlsm, 428

.xlsx, 11, 428, 1156

XPS, 11, 530–532

.zip appended to existing file name, 1149, 1165

File menu. See Microsoft Office Button

File New Database dialog box

creating database from, 847–848, 896

saving

database from, 844–845, 846

template for database, 896–897

File Versions feature, 338

files, 1150–1152.

See also attachments;

.docx files;

Open XML Formats

adding

to Groove Files tool, 158

to SharePoint via e-mail, 757

default location of sample Access, 765

displaying Outlook paths to, 652

downloading in shared Groove workspaces, 172–176

editing SharePoint files in Outlook, 754–755

embedding references to in notebook, 108

finding Outlook’s data storage, 652–653

formats

.accdb, 841

.aiff, 573

.asf, 1149, 1165

.au, 573

.avi, 575

compatible PowerPoint sound, 573

default database, 894–895

.docx, 11

.dotm, 214

.dotx, 214

.gif, 575

macro-enabled, 11

.mdb, 861

.midi, 573

.mp3, 573

.mpeg, 575

.ost, 652

PDF, 530–532

.potx, 584

PowerPoint, 527–532, 543

.pptx, 528, 529, 1157

saved Web page background elements, 259

selecting default database, 894–895

viewing all, 1149

.wma, 111

.wmv, 111

“x” added to new XML, 11

.xlsm, 428

.xlsx, 11, 428, 1156

XPS, 11, 530–532

.zip appended to file name, 1149, 1165

packaging presentation for CD, 574

printing to OneNote, 105–106

.rels, 1151

removing SharePoint, 756

restricting permissions to PowerPoint, 590–592

saving

database, 844–845, 846

earlier PowerPoint, 529

size of presentation, 566

Files tool, 157–158

file-sharing workspaces, 85–88.

See also shared workspaces

creating, 86–87, 167–170

downloading files in, 172–176

Groove, 78, 85–86

inviting others to join, 87–88, 171

setting folder permissions for, 176

fill handle

dragging cell, 427

extending structure reference formulas with, 426–427

turning on, 342

Fill/Back Color button, 998

Filter button (Datasheet view), 941

Filter window (Access), 964–966

filtering

by form, 966–967

data fields before adding to PivotTable, 490

Filter window options for, 964–966

junk e-mail, 15, 73, 637

messages by color category, 683–684

PivotTable fields, 502–505

PivotTables categories, 488–489

query data, 961–968

by selection, 963–964

rows, 966–967

saving and reusing criteria, 968

sequence for tables saved in Datasheet view, 878

subdatasheets, 963

Final Showing Markup view, 326

Find & Select menu (Excel), 347

Find And Replace dialog box, 306, 307, 950, 962

Find button (Datasheet view), 941

FIND function, 469, 475

finding

Access database objects, 820–824

comments

by highlighting color, 307

presentation, 595

constants in Object Browser, 1099

database objects with Search Bar, 820–824

differences in cells, 351–352

hidden data and removing, 62–64, 613

highlighted items, 306

Insert, File command, 265

measurements in document parts, 1164

missing properties or methods, 1102–1103

Office commands, 23

OneNote information, 119–120

Outlook files, 652–653

and replacing

slide text, 548–549

subdatasheet data, 950

tracked changes and removing, 62, 64–65

URLs for CRL, 713–714

XML syntax errors, 1163

 First Recording.docx file, 1078

flagging messages

about, 678–679

changing flag status, 683

indicating received and sent mail, 678–680

marking contacts for follow up, 681–683

setting-up to-do item for outgoing messages, 680–681

floating frames

changing text box to, 266

converting to text boxes, 267

identifying, 274

switching between text boxes and, 274

FLOOR function, 465

flowing text.

See also text boxes

about, 262

between text boxes, 270–271

Folder List (Outlook), 675–676, 677

folders

Categorized Mail, 676, 677

docProps, 1152

Document Themes, 537

Excel sheets, 1156

grouping messages with customized views, 683

names of linked Outlook/SharePoint Services, 737–738

Notes, 649

Open XML Formats as compressed, 1147

Outlook

data storage, 649–650

managed, 637

Notes, 649

personal, 650–651

removing SharePoint, 757

search, 675–678

permissions for file-sharing workspaces, 176

ppt, 1157

_rels, 1151, 1152

search, 675–678

changing criteria of, 677

creating, 677–678

customizing, 676–677

defined, 675

illustrated, 676

managing e-mail in, 684

using, 675–676

slideLayouts, 1157

slideMasters, 1157

specifying as shared workspace, 170–171

Startup, 666

structure for .docx file, 1157

synchronizing

Groove shared, 168–169, 173–175

Outlook, 651–652

theme, 1152, 1157

types of project, 1084

Font group buttons (Access), 992

fonts.

See also special characters

adjusting report label control, 1031

configuring for comment balloon, 315

customizing PowerPoint theme, 550–551

entering symbols, 359–360

finding measurements in document parts, 1164

form control, 992–993

formatting options for PowerPoint text, 547

selecting for headers and footers, 557

using large font in Presenter view, 619

Footer Gallery, 225

footers

adding to forms, 975

creating, 223, 224–227

deleting, 228–229

field codes in, 227

font selection for, 557

manually adding or editing Word, 227

page numbers in, 223–224

presentation, 556–558

report

adding Access, 1029–1030

adjusting, 1034

turning on/off slide, 541

views in which visible, 223

Word delete loops leaving objects in, 1110

footnotes, 266–267

For...Next loops

selecting Do loops vs., 1108–1110

using, 1106–1107

For Each…Next loops, 1106–1107

form controls

attaching new label to, 991

building combo boxes, 1011–1015

fonts for, 992–993

formatting, 993

label properties for, 995–996

moving and sizing, 990–991

selecting with ruler, 998

toggle buttons, check boxes, and option buttons, 1015–1017

Form Design Tools tab, 977–982

Controls group buttons on, 978–982

illustrated, 978

using buttons on, 977

Form window

Detail section, 974–977

opening in Layout view, 973–974

Form Wizard, 1003–1007

finishing and modifying forms, 1005–1007

picking form style, 1004, 1005

polishing look of forms from, 1008–1011

selecting fields in, 1003–1004

Format Horizontal Line dialog box, 294

Format Picture dialog box, 296

formatting

charts, 581–582

clearing all PowerPoint, 547

control borders, 993–994

formulas, 420

four-digit date/time, 891–892

horizontal lines, 293–294

HTML vs. XML code, 1145

PivotTables, 496, 497–498

presentations, 532–533

removing and showing outline, 245–246

reports

applying AutoFormats in Layout view, 1069–1071

created with Report Command, 1039

manually-created, 1031–1036

modifying Report Wizard reports, 1046–1052

previewing before printing, 1036, 1045–1046

slide text fonts and paragraphs, 546–548

specifying for tracked changes, 328

storing input mask formatting characters with data, 872–873

text

note, 102–103

in text boxes, 265

from ZIP package, 1167–1170

text boxes and AutoShapes, 267–270

users’ principles for, 37

forms, 969–1017.

See also form controls;

Forms tool

adjusting navigation keys for, 948–949

building input, 988–997

changing text box properties, 994–995

conceptual architecture of, 970–971

creating query for property, 986–988

custom colors for, 997–999

defining Groove views, 200–202

design terms for, 976

designing

with Form Design Tools tab, 977–982

with Groove Forms tool, 196–200

modifying design in Allow Layout view, 999

displaying properties on Format tab, 996–997

dragging and dropping fields on, 988–989

field list, 974, 983–984

Form Wizard

modifying, 1005–1007

picking style, 1004, 1005

polishing, 1008–1011

selecting fields in, 1003–1004

Groove, 132, 194, 195

label properties, 995–996

locking control buttons, 983

matching closest Access entries when typing, 1015

object-oriented programming of, 969–972

property sheet, 984–988

quick create commands for, 1000–1003

reports vs., 1023

simplifying data input with, 1011–1017

subforms, 970

testing and publishing Groove, 202–203

units of measure in, 976

using in presentations, 604

width and height of, 975

Forms Server, 16

Forms tool, 194–203

designing form, 196–200

defining views, 200–202

design options, 203

examples of forms built with, 194, 195

testing and publishing forms, 202–203

Formula AutoComplete

assistance for functions, 406–407, 456

building structured references with, 425

formula bar, 353

formulas, 393–451.

See also arrays;

cell references;

functions

array operations in, 434–439

avoiding error values as results of, 475

building conditional sum, 446–449

calculating part of, 429–430

cell references in, 394–401

circular references in, 430–432

conditional functions as, 474

conditional tests for, 444–451

creating

automatic lookup, 476

with INDEX and MATCH functions, 449–451

editing, 401–403

name references, 410

entering

in array constant, 438–439

cell references, 395

error values, 403–404

Formula AutoComplete, 406–407

formula-bar formatting, 420

incorrect calculations of, 356

linking workbooks, 439–443

names

cells and cell range, 407–419

creating semiautomatically, 412–413

defining and managing cell, 409

3-D, 414–415

using in, 408–409, 415–416

workbook-wide vs. worksheet-only, 411–412

natural-language, 422

numeric text in, 402

operator precedence in, 393–394

reference changes with insertions in SUM, 401, 462

relative references in named, 414

rules for naming, 411

selecting cell precedents and dependents for, 351

streamlining with SUMIF function, 472

structured references in, 420–423

text values, 402–403

3-D, 419–420

workbooks containing dependent, 440–441

Formulas command (Excel), 348

Formulas tab (Excel)

Function Library group on, 460

launching Excel add-ins from, 445

Lookup & Reference button, 476

Math & Trig button, 462

Text button on, 466

forward slash (/)

division operator, 393, 921, 923

fractions in Excel, 355

fractions in Excel, 355

freezing panes, 368–370

From Text setting (Line Numbers dialog box), 233

Full Screen button, 382–383

full-screen mode for movies, 575–576

fully qualified field names, 928

fully qualified paths, 652

Function Arguments dialog box

collapse dialog button in, 455

getting function assistance in, 455

selecting arguments in, 459

function keys, 31

Function Library group on Formulas tab, 460

functions, 453–484.

See also arguments;

SUM functions;

text functions

about, 404, 453

arguments

functions without, 457

selecting for, 459–460

using in, 404, 456–458

AVERAGE vs. AVG, 466

case, 469

COMBIN, 463–464

concatenated date becomes serial number, 471

date and time, 932

DateDiff, 921–922, 931

defined, 404

EVEN and ODD, 465

FIND and SEARCH, 469

FLOOR and CEILING, 465

Formula AutoComplete used with, 406–407, 456

Function Arguments dialog box, 455

getting assistance for, 453–456

Help references for, 453–454

INDEX and MATCH, 449–451

information, 474–476

Insert Function dialog box, 454

inserting, 406, 458–461

INT, 465–466

logical, 471–474

lookup and reference, 476–484

MOD, 463

MROUND, 465

nested IF, 473

OneNote, 114

PRODUCT, 462

RAND, 464

RANDBETWEEN, 464

ROUND, 464–465

ScreenTips for, 455–456

streamlining formulas with SUMIF, 472

SUM, 405–406, 461–462

summary

applying multiple, 506

changing, 505–506

SUMPRODUCT, 462

syntax of, 456–457

text, 466–471

TRUNC, 466

fx button, 458