F

F3 key, 42-44

fields, Access

field properties, 334

Field Size property, 338-40

masks for specifying data format in a field, 340-45

Field Size property, Access fields, 334, 338-40

file name extensions, 28

files

attaching to messages, 510-14

displaying extensions, 512

fill handles, Excel tables, 156-58

FillSeries, Excel data, 156-58

Filter By Form command, Access, 307-10

filtering, Access 2007

advanced filtering options, 310-13

comparing filters, sorts, and queries, 316

exercise filtering, 303-05

information in forms, 305

overview of, 297

using forms, 307-10

wildcards, 302

find and replace function

PowerPoint 2007, 413-16

Word 2007, 52-55

finding and correcting, errors in data calculations in Excel, 195-202

finding and replacing

Excel data, 164-67

Word formats, 88

firing events, 279

floating toolbars, 489-90

flowing text, 98

folders, mailbox

AutoArchive settings for, 564-65

creating new, 558

Draft, 504-05

list of, 484-85

locating message in, 540

moving messages into, 559-60

navigating from Advanced toolbar, 491

using color categories for, 553-57

working with Search Folders, 552

Font Dialog Box Launcher, 18

fonts

changing in PowerPoint, 413-16

colors, 70, 74-75

defaults in PowerPoint, 404

defined, 70

effects, 70

e-mail, 522, 524-25

in Excel cells, 208-11

preparing PowerPoint presentations for travel and, 457

sizes, 70

styles, 70

font sizes, 70

footers, 269

footers, Access forms, 263

Format Painter

button, 72

e-mail, 525

formats

e-mail, 522-28

masks for specifying data format in a field, 340-45

text. see text formats, Word 2007

formats, Access tables, 112-16

formats, Excel

conditional formats, 226-33

numbers, 222-26

formats, Excel documents. See appearance, Excel documents

Format Text tab

appointment window, 571

message window, 502

Form Detail, Access forms, 273-78

Form Footer, Access forms, 269, 273

Form Header, Access forms, 273

forms

exercise creating form based on a query, 317-23

filtering using, 307-10

sorting information in forms, 301

forms for data entry, Access 2007, 257-95

arrangements of forms, changing, 268-72

AutoForm, using for form creation, 283-85

controls for forms, adding, 273-78

Form tool, using, 258-61

key points, 294-95

overview, 257-58

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

Form tool, Access forms, 258-61

FormulaAutoComplete, 186

formulas, Access 2007, 306

formulas, Excel 2007

for calculating values, 184-90

defined, 184

summarizing conditional data, 191-94

formulas, Word 2007, 117-24

built-in, 116-17

defined, 116

Formula Dialog box, 118-20

worksheets for, 117-18, 120-24

Freeze columns, Access 2007, 254-55

Full Screen Reading view, 17

functions

aggregate functions, 328-29

built-in, 321

currency conversion, 321

in expressions, 306