Wiley Office 2010 Visual Quick Tips 978-0-470-57775-2 Manuale Utente

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

17_577752-bindex.indd   354

17_577752-bindex.indd   354

5/17/10   1:11 PM

5/17/10   1:11 PM