Wiley 978-0-470-57775-2 Datasheet

Brand: Wiley

Model: 978-0-470-57775-2

Category: Software manuals

Type: Datasheet

The Wiley 978-0-470-57775-2 is a powerful and versatile tool that can help you with a wide range of tasks. With its intuitive interface and user-friendly features, you'll be able to quickly master this device and start using it to improve your productivity. Whether you're a student, a professional, or just someone who wants to stay organized, this device has something to offer you. Some of the things you can do with this device include: Create and edit documents, spreadsheets, and presentations.

354

Access (Microsoft)

adding background reports, 256–257

applying input masks, 230–231

assigning themes to forms, 252

attaching files to records, 234–235

automating tasks with macros, 248–249

changing form tab order, 253

collecting data from Outlook, 222–225

conditional formatting, 258–259

copying previous records, 229

creating mailing labels, 246–247

default values, 226

displaying summary statistics, 240

documenting databases, 242–243

exporting reports to Word, 244–245

importing data from Excel, 218–221

inserting OLE objects, 236–237

overview, 214, 250

pictures in forms, 254–255

PivotCharts, 262–263

PivotTables, 260–261

primary key fields, 227

saving filters as queries, 238–239

setting data validation rules, 232–233

setting field captions, 228

templates, 216–217

viewing object dependencies, 241

action buttons, 170–171

archiving (e-mails), 290–293

author permissions, 36–37

AutoArchive feature (Outlook), 290–291

AutoCorrect (Word), 62–63

AutoFill feature (Excel), 102–103

AutoFilter feature (Excel), 131

AutoText (Word), 60–61

backgrounds, 256–257, 334–335

bibliographies, 82–83

blog posts, 50–51

bookmarks, 56–57

borders, 70–71, 140–141

building blocks, 14–15, 46–47

Calculator tool, 114–115

calendars, 306–309

captions, 213, 228, 344–345

CDs, copying presentations to, 184–185

cells

borders, 140–141

changing text orientation, 153

data-validation rules, 132–133

generating random numbers in, 110

joining text from separate, 113

protecting, 108–109

setting constraints, 125

Watch window, 106–107

certificates, 274

chart objects, 146–147

charts (Word), 78–79. See also PivotCharts

citations, 83

clip art, 202–203, 330–333, 342–343

color

background, 142–143

gridline, 138

color-coding, 104, 144–145

comments, inserting in formulas, 112

compressing media files, 180–181

conditional formatting, 144–145, 258–259

conversations (e-mail), 286–287

cover pages, 88–89

cross-references, 94–95

data. See also text

automating, 102–103

collecting from Outlook, 222–225

color-coding, 144–145, 258–259

importing/exporting, 218–221

printed, 154

setting validation rules, 232–233

data forms, 128–129

data-validation rules, 132–133, 232–233

Database Documenter feature (Access), 242–243

database tables, 126–127

datasheets, 260–263

definitions/synonyms, looking up, 54–55

Design Checker (Publisher), 325

digital signature, 34–35

distribution lists, 270–271

documents. See also files

adding line numbers, 96–97

assigning properties, 28–29

bookmarks, 56–57

checking compatibility, 24–25

comparing, 74–75

converting to presentations, 158–159

encrypting, 32–33, 274–275

marking as final, 38–39

PDF, 26–27

recovering unsaved, 40–41

removing sensitive information, 30–31

searching through, 52–53

drafts, 40–41

Drop Caps feature (Word), 64–65

electronic business card, 273, 298–301

e-mails. See also Outlook (Microsoft)

archiving, 290–293

electronic business cards to, 273, 298–301

Index

17_577752-bindex.indd 35417_577752-bindex.indd 354 5/17/10 1:11 PM5/17/10 1:11 PM

COPYRIGHTED MATERIAL

355

encrypting, 274–275

junk, 288–289

recalling, 276–277

rules, 282–285

sending publications as, 322–323

viewing archived, 292–293

encryption, 32–33, 274–275

endnotes, 84–85

equations, 174

errors, auditing worksheets for, 116–117

Excel (Microsoft)

adding background color/patterns/images, 142–143

applying workbook themes, 136–137

auditing worksheets for errors, 116–117

AutoFill feature, 102–103

AutoFilter feature, 131

borders, 140–141

Calculator tool, 114–115

center-aligning printed data, 154

centering text across merged cells, 155

changing cell text orientation, 153

changing default font, 17

changing gridline colors, 138

chart objects, 146–147

color-code worksheet tabs, 104

conditional formatting, 144–145

creating database tables, 126–127

creating projections, 118–119

data forms, 128–129

data-validation rules, 132–133

establishing what-if scenarios, 120–121

exporting data from Access to, 219

freezing headings, 111

generating random numbers in cells, 110

Goal Seek feature, 122–123

importing data to Access from, 218–221

inserting comments in formulas, 112

joining text from separate cells, 113

naming worksheet tabs, 105

opening workbooks, 100–101

printing gridlines, 139

protecting cells, 108–109

Solver feature, 124–125

Sort dialog box, 130

Sparklines, 150–151

trendlines, 148–149

Watch windows, 106–107

wrapping text, 152

Expression Builder (Access), 232–233

fields (Access), 227–228

file formats, 23, 25, 206

files. See also documents

Access, 234–235

assigning passwords, 33

changing default save location, 22–23

media, 180–181

Office, 26–27

text, 316

fill patterns, 142

filler text, 76

Filter Query (Access), 239

filters, saving as queries in Access, 238–239

fonts, changing default, 16–17

footer building blocks, 44–45

footnotes, 84–85

formatting, 47, 143–145, 258–259

forms, 252–255

formulas, 112

Goal Seek feature (Excel), 122–123

graphics

adding captions, 344–345

adding custom watermarks, 348–349

assigning artistic effects to pictures, 336–337

clip art, 330–331

grouping objects, 340–341

online clip art, 332–333

ordering objects, 338–339

overview, 326

Picture Manager, 352–353

removing image backgrounds, 334–335

Screenshot, 328–329

turning WordArt objects into picture files, 346–347

Ungroup command, 342–343

wrapping text around, 350–351

gridlines, 138–139

growth trends, 119

handouts, 179

header building blocks, 44–45

headings, freezing in Excel, 111

hyperlinks, 95, 172–173

hyphenation in publications, 320–321

iCalendar file format, 307

images, 142, 334–335. See also pictures

Import Spreadsheet Wizard, 218–221

indexes, 90–93

input masks, 230–231

items (Outlook), 304–305

junk e-mail, 288–289

ligatures, 17

line numbers, 96–97

line spacing, 66–67

linear trends, 118

macros, 14–15, 248–249

mailing labels, 246–247

Map It feature (Outlook), 302–303

media files, compressing, 180–181

metadata, 30

Microsoft Clip Organizer, 330–333

17_577752-bindex.indd 35517_577752-bindex.indd 355 5/17/10 1:11 PM5/17/10 1:11 PM

356

narration, recording for presentations, 168–169

Navigation pane (Word), 58–59

nonbreaking space, 77

notes, organizing with OneNote, 18–19

numbered lists (Word), 69

Object Dependencies feature (Access), 241

objects

chart, 146–147

grouping graphic, 340–341

ordering, 338–339

viewing dependencies, 241

WordArt, 346–347

Office Compatibility Checker, 24–25

OLE objects, 236–237

OneNote, 18–19

OpenType ligatures, 17

Optimize Media Compatibility feature (PowerPoint), 181

Out-of-Office reply, 278–281

Outlook (Microsoft)

adding e-mail accounts, 266–267

archiving e-mails, 290–291

categorizing items, 304–305

cleaning up folders and conversations, 286–287

collecting data from, 222–225

creating distribution lists, 270–271

creating electronic business cards, 298–301

customizing e-mail signatures, 272–273

delegating tasks, 311

encrypting messages, 274–275

filtering junk e-mail, 288–289

Map It feature, 302–303

mobile features, 303

Out-of-Office reply, 278–281

Overlay mode, 308–309

overview, 264, 296

Quick Steps feature, 268–269

recalling messages, 276–277

recording journal entries, 310

rules, 282–285

sending calendar snapshots, 306–307

subscribing to RSS feeds, 294–295

viewing archived e-mails, 292–293

Outlook Connector, 267

Overlay mode, 308–309

passwords, 33, 109

Paste Options gallery, 12–13

PDF documents, 26–27

permissions, author, 36–37

phishing, 289

photo album presentations, 212–213

PickList feature (Excel), 127

Picture Manager, 352–353

pictures. See also images

adding to presentations, 202–203

assigning artistic effects to, 336–337

organizing with Picture Manager, 352–353

removing, 353

using in forms, 254–255

PivotCharts, 262–263

PivotTables, 260–261

placeholders, 192–193

PowerPoint (Microsoft). See also presentations

adding equations, 174

adding pictures to presentations, 202–203

adding video/sound, 206–207

animating slides, 210–211

broadcasting presentations, 188–189

compressing media files, 180–181

converting Word documents to presentations, 158–159

copying presentations to CD, 184–185

creating photo album presentations, 212–213

creating self-running presentations, 175

creating speaker notes, 178

custom slide masters, 194–195

editing video, 208–209

inserting action buttons, 170–171

inserting hyperlinks, 172–173

inserting SmartArt graphics in presentations, 204–205

organizing presentation in sections, 160–161

printing handouts, 179

recording narration, 168–169

rehearsing timing, 166–167

reusing slides, 164–165

saving presentations on SkyDrive, 186–187

sending presentations to reviewers, 162–163

slide layouts, 192–193

SmartArt graphics, 204–205

speaker notes, 178

themes, 196–201

turning presentations into video, 182–183

writing on slides during presentations, 176–177

presentations. See also PowerPoint (Microsoft)

photo album, 212–213

self-running, 175

primary key fields (Access), 227

printing, 139, 179

private key, 34

projections, creating, 118–119

properties, 20, 28–29

Protect Sheet feature, 108–109

Protect Workbook feature, 108

publications. See Publisher (Microsoft)

Publisher (Microsoft)

automatically fitting text, 319

controlling hyphenation, 320–321

finding templates online, 314–315

inserting text files, 316

moving pages, 318

nudging text boxes, 317

overview, 312

saving publications for commercial printers, 324–325

sending publications as e-mails, 322–323

Index

17_577752-bindex.indd 35617_577752-bindex.indd 356 5/17/10 1:11 PM5/17/10 1:11 PM

357

queries, saving filters as, 238–239

Quick Access toolbar, 4–5, 114–115

Quick Steps, 268–269

records

adding using data forms, 128–129

attaching fields to, 234–235

copying, 229

deleting, 129

editing using data forms, 128–129

filtering, 131

sorting, 130

reports, 244–245, 256–257

Research pane (Word), 56

restricted access, 37

Review tab, 49

Ribbon, 5–11, 19

RSS feeds (Really Simple Syndication), 294–295

rules (e-mail), 282–285

screen capture, 328–329

Screenshot, 328–329

Selection and Visibility pane, 339

self-running presentations, 175

SharePoint, 189, 217

signatures (e-mail), 272–273

SkyDrive, 186–187

slide masters, 194–195

slides

animating, 210–211

creating custom layouts, 192–193

reusing, 164–165

writing on during presentations, 176–177

SmartArt graphics, 204–205

SmartTag icon, 69

Solver feature (Excel), 124–125

Sort dialog box, 130

sound, adding to presentations, 207

Sparklines, 150–151

speaker notes, 178

startup folders, 100–101

summary statistics, 240

tab order (Access), 253

table of contents (TOC), 86–87

tables, database, 126–127

tasks

automating with macros, 14–15, 248–249

delegating, 311

templates

Access, 216–217

Publisher, 314–315

text. See also data

automatically fitting, 319

centering across columns, 155

changing orientation in cells, 153

filler, 76

finding and replacing, 53

joining from separate cells, 113

translating, 48–49

wrapping, 152, 350–351

text boxes, 317

text files, 316

themes, 136–137, 196–201, 252

TOC (table of contents), 86–87

Track Changes feature (Word), 72–75

transition effects, 167

trendlines, 148–149

Tufte, Edward (inventor), 151

Ungroup command, 342–343

validation rules (Access), 232–233

video (PowerPoint), 182–183, 206, 208–209

View tab (Ribbon), 19

Watch window, 106–107

watermarks, 348–349

Web pages, saving Office files as, 27

what-if scenarios, 120–121

Windows Paint, 347

Windows Rights Management feature, 39

Word (Microsoft)

adding cross-references, 94–95

adding filler text, 76

adding header/footer building blocks, 44–45

adding line numbers to documents, 96–97

AutoCorrect, 62–63

AutoText, 60–61

bookmarks, 56–57

borders, 70–71

changing default font, 16

charts, 78–79

comparing documents, 74–75

converting documents to presentations, 158–159

creating bibliographies, 82–83

creating blog posts, 50–51

Drop Caps, 64–65

exporting reports from Access to, 244–245

generating indexes, 90–93

generating table of contents (TOC), 86–87

inserting cover pages, 88–89

inserting footnotes and endnotes, 84–85

inserting horizontal lines, 68

looking up synonyms/definitions, 54–55

Navigation pane, 58–59

nonbreaking spaces, 77

resuming numbering in lists, 69

searching documents, 52–53

setting default line spacing, 66–67

sharing building blocks, 46–47

Track Changes, 72–73

translating text, 48–49

WordArt objects, 346–347

workbooks, 100–101, 108, 136–137

17_577752-bindex.indd 35717_577752-bindex.indd 357 5/17/10 1:11 PM5/17/10 1:11 PM

358

Index

worksheets

auditing for errors, 116–117

color-coding tabs, 104

naming tabs, 105

protecting, 109

wrapping text, 152, 350–351

x extension, 25

XE field, 90–93

XLSTART folder, 100

17_577752-bindex.indd 35817_577752-bindex.indd 358 5/17/10 1:11 PM5/17/10 1:11 PM

Wiley 978-0-470-57775-2 Datasheet

Brand: Wiley

Model: 978-0-470-57775-2

Category: Software manuals

Type: Datasheet

Download PDF

report

Wiley 978-0-470-57775-2 Datasheet

Wiley 978-0-470-57775-2 Datasheet

Related papers

Other documents