C

calculations, in Access 2007

queries for performing, 328-31

in tables, 116-24

calculations, in Excel 2007, 179-202

conditional formulas for summarizing data, 191-94

error detection and correction, 195-202

formulas for values calculation, 184-90

naming data groups, 180-83

overview, 179-80

Calendar Details Style print format, Outlook 2007, 600

Calendar folder, Outlook, 486

calendar item windows

appointment window, 568-74

types of, 568

calendar management, Outlook 2007, 589-615

adding and removing local holidays, 595-96

defining available time (work week), 596-99

delegating control, 613-15

displaying views, 592-94

key points, 615

linking calendar entries to OneNote, 611

linking to Internet calendar, 608-10

multiple calendars, 611-15

multiple calendars next to each other, 611-13

overview of, 589-90

printing calendar, 600-604

saving calendar information as Web page, 607-08

sending information in e-mail, 604-06

types of views, 590-91

Calendar module, Outlook, 485

Calibri font, 70, 522

capitalization, Word text, 75

Caption properties, Access forms, 266

case formats

PowerPoint 2007, 413, 420-21

Word 2007, 75, 77

Categorized Mail folder, Outlook 2007, 552

CategoryID text box, Access forms, 291

Category view, Outlook calendar, 591

Cc box, sending courtesy copies of e-mail messages, 504

CDs, creating presentation package on, 455-58

cell addresses, Word, 117

cell range, Excel 2007, 161

cells, Excel 2007

auto fill features for, 156-60

data calculations in, 179

in Excel workbooks, 141-45

formats, 206-11

formulas for data calculation in, 184-90

moving data in, 160-63

naming groups of data in, 180-83

relative, 189

Cell Styles gallery, Excel 2007, 212-16

cells, Word 2007

defined, 104-05

deleting, 106

inserting, 106

merging, 106, 108-09

selecting, 106

splitting, 107

Certificate Import Wizard, 473

certificates, setting up e-mail accounts and, 473

character formats, Word 2007, 70-77

bolding, 71-72, 75

capitalization, 75

font colors, 74-75

font size, setting, 72

overview, 70-71

painting formatting, 72

spacing, 73-74

Stencil, 72

underlining, 71

characters, Input Mask property, 341

character spacing

e-mail, 522

Word 2007, 70

Character styles, Word 2007, 68

Click and Type feature, Word 2007, 79

color

e-mail message options, 521

filling Excel cells with, 208, 210

of fonts, in Excel, 207

of fonts, in PowerPoint, 417-21

organizing Inbox messages with, 553-57

schemes, in PowerPoint, 431-36

selecting ink color for electronic pen, 459-61

Color Builder, Access 2007, 265

column breaks, Word tables, 98

columns, Access 2007, 252-55

columns, Excel 2007

in Excel workbooks, 141-45

relative, 189

columns, Word 2007.

See also tables, Word 2007

deleting, 106

flowing text into, 99-102

inserting, 106, 107-08

overview, 97-98

selecting, 106

sizing, 106

combo boxes, options for controlling data entry into databases, 349

command buttons, 258

commands

implementing using this book, 576

on Outlook Advanced toolbar, 491-92

Compact and Repair Database, Access utilities, 365-67

comparison operators, 306

Compatibility Checker, 62

compatibility issues, Windows XP, 4

compatibility issues, Word 2007

with earlier versions of Word, 17

with Windows XP, 36

concatenation operator (&), 306

conditional formats, in Excel, 226-33

conditional formulas for summarizing data, in Excel 2007, 191-94

constants, in expressions, 306

Contacts folder, Outlook

overview of, 486

sending information from, 513

Contacts module, Outlook, 485

control properties, in expressions, 306

controls, for forms

adding, 273-78

defined, 262

deselecting, 266

positioning, 271

control source, Access forms, 262

Control Source properties, 266

Convert Text to Table dialog box, 110-11

copying, Excel workbooks, 138-39

corrections

data in Excel, 168-72

spelling and grammar errors in Word, 53

text in PowerPoint, 405-08

Count, aggregate functions, 329

COUNTIFS function, 192-94

courtesy copies, of e-mail messages, 504

crosstab query, 314

currency

conversion function, 321

data type, 337

regional settings for, 337

customers, Business Contact Manager for organizing, 479

custom filters, 304