<< . .

. 3
( : 51)



. . >>

Setting default object permissions .................................................................... 542
Setting database permissions ............................................................................. 542
Securing your database for distribution: A basic approach .............................. 542
Using the Access Security Wizard .......................................................................................... 544
Encrypting a Database ............................................................................................................ 551
Decrypting a Database ............................................................................................................ 553
Protecting Visual Basic Code ................................................................................................. 553
Preventing Virus Infections .................................................................................................... 554
Enabling sandbox mode ................................................................................................... 555
Chapter 23: Adding FrontPage Web Components .................................... 559
Adding FrontPage Web Components ..................................................................................... 559
Defining and using components ...................................................................................... 559
Web components are programs ........................................................................................ 560
Many Web components require FrontPage server extensions ........................................ 561
Many components don™t require FrontPage extensions .................................................. 562
Some components require SharePoint servers ................................................................ 563
The SharePoint server files (called SharePoint Team Services) .............................. 563
Inserting Components ............................................................................................................. 564
Using Components that Aren™t “Components” ...................................................................... 565
Using Date and Time ....................................................................................................... 565
Adding comments ............................................................................................................ 567
Exploring Web Components ................................................................................................... 568
xxiii
Contents


Dynamic effects ............................................................................................................... 568
Interactive buttons .................................................................................................... 569
Scrolling marquees ................................................................................................... 570
Web search ....................................................................................................................... 571
Search form properties ............................................................................................. 572
Displaying search results .......................................................................................... 573
Spreadsheets and charts ................................................................................................... 574
Hit counters ...................................................................................................................... 574
Photo Gallery ................................................................................................................... 577
Included content ............................................................................................................... 577
Creating Substitutions .............................................................................................. 577
Including pages ......................................................................................................... 578
Embedding a page based on schedule or a picture based on schedule .................... 579
Including a page banner ........................................................................................... 580
Link bars .......................................................................................................................... 580
Inserting a table of contents ............................................................................................. 580
Assigning categories ................................................................................................. 581
Table of contents options .......................................................................................... 582
Using the Table of Contents template ...................................................................... 582
Top 10 lists ....................................................................................................................... 583
List view and document library components .................................................................. 585
Commercial and additional components ......................................................................... 585
Creating a page with Web components .................................................................... 585
Advanced Controls .......................................................................................................... 586
Summary ................................................................................................................................. 587
Chapter 24: Advanced Publisher Techniques .......................................... 589
Adding Special Effects ........................................................................................................... 589
BorderArt ......................................................................................................................... 589
Drop caps ......................................................................................................................... 591
WordArt ........................................................................................................................... 594
Using Linked and Embedded Objects .................................................................................... 596
Embedding a new object .................................................................................................. 597
Embedding an existing object ......................................................................................... 599
Mail and Catalog Merging in Publisher ................................................................................. 600
Using an existing list or Outlook contacts ...................................................................... 601
Creating a new list ........................................................................................................... 602
Create the publication ...................................................................................................... 603
Preview your publication ................................................................................................. 604
Merging ............................................................................................................................ 604
Merging a Catalog ........................................................................................................... 605
Designing Web Sites with Publisher ....................................................................................... 606
Creating a hotspot ............................................................................................................ 608
Inserting hyperlinks ......................................................................................................... 609
Adding a form control ..................................................................................................... 610
Inserting an HTML code fragment .................................................................................. 611
xxiv Contents


Previewing your Web page .............................................................................................. 611
Using the Design Gallery ........................................................................................................ 611
Saving and Printing ................................................................................................................. 613
Using the Design Checker ............................................................................................... 613
Printing ............................................................................................................................. 613
Preparing for Outside Printing ......................................................................................... 614
Summary ................................................................................................................................. 614
P A R T




I
Getting
Functional . . . .



with Microsoft In This Part

Chapter 1

Office 2003
Introduction to the
Microsoft Super Bible
eBook

Chapter 2
Paragraph Formatting
in Word



T
Chapter 3
his part is comprised of chapters that cover the first useful
Configuring Outlook
“getting started” functions in each of the Office 2003 suite
2003
of applications, including Publisher. You will also find an
introduction to the Super Bible eBook itself, offering insight as to
Chapter 4
where the chapters originally came from and the concept behind
Essential Excel
generating this bonus free eBook as extra value for you.
Spreadsheet
Operations

Chapter 5
Your PowerPoint
Action Plan

Chapter 6
Introducing Microsoft
Publisher

Chapter 7
Building FrontPage
Web Sites

Chapter 8
Understanding and
Creating Access
Reports

. . . .
1
CHAPTER



Introduction to
the Microsoft
Office 2003 . . . .


Super Bible In This Chapter


eBook Who Should Read
this Book

How this Book is
Organized

Of Special Note for
the eBook

W elcome to the Microsoft Office 2003 Super Bible. As part of
Conventions Used in
the Wiley Bible series, this book emphasizes “handiness”
this Book
by giving you bonus material in an easy-to-use format. In this
book, you find all the information that you need to successfully and
. . . .
efficiently function within Office 2003 suite of applications both
with other coworkers and other applications. To make it as easy as
possible to find, understand, and implement information, throughout
the text the major tasks are clearly delineated. This guide is de-
signed to facilitate your access to various functions within Office
2003 System and get you quickly on your way to getting the most
out of this truly exciting and powerful new product.


Who Should Read This Book
This Super Bible eBook is intended for anybody who has used
Microsoft Office products in the past, and wants to increase their
knowledge of Office 2003. Wiley carefully selected some of the
most useful chapters from each of their Office 2003 Bibles to
enable you to get the most out of all of Office 2003 products. The
material was chosen based on it™s ability to bring you up to speed
on some of the features that make Office 2003 a superior office
system, most notably the way the applications integrate well
together and allow you to collaborate with your coworkers or
project partners, whatever your project may be.
Part I ¦ Getting Functional with Office 2003
4


How This Book Is Organized
This book is organized to accomplish two things: First, to introduce you to the key “must-
know” features of each of the Office applications, and then to make it as easy as possible
for you to integrate the application you most often use with other Office applications, while
collaborating with your coworkers. Finally, you will find material intended to make you
comfortable with some of the advanced or most useful features in each of the Office 2003
applications.

Part I: Getting Functional with Office 2003
Part I is comprised of chapters that cover the first useful “getting started” functions in each
of the Office 2003 suite of applications, including Publisher.

Part II: Collaborating and Integrating with Office 2003
Part II is comprised of chapters that enable users of one particular Office 2003 application
to more effectively collaborate and integrate their efforts with coworkers and/or other
applications.

Part III: Beyond Mastery: Initiative within Office
Part III is comprised of chapters that are the special “extras” that many people know about,
but might not be quite as familiar with as some of the other day-to-day functions. Once
you™ve read a sampling of the meat and potatoes functions in each application, and then
how to more efficiently work with your coworkers and other applications, these chapters
should enable you to take the initiative and go that next step.


Of Special Note for the eBook
Many of these chapters were culled from their original publications and adapted slightly for
the purposes of the eBook. The idea was not only to give you valuable, free content, but
also to whet your appetite for some of the other applications that Microsoft Office 2003
System offers. If you find that you have interest in learning more about any of the topics
you read about in this eBook, please visit www.wiley.com/compbooks/
officebibles2003. This Web site allows you to preview our other products with
detailed TOCs as well as other valuable information.

Every attempt was made to keep this material as consistent as possible with what you
will see in the final product. Please be aware that depending on the OS system you are
Note
currently using and the system that the screenshots were taken on, as well as the per-
sonal settings of each, some of the images may not match exactly.
Chapter 1 ¦ Introduction 5


Using the companion Web site
Be sure to visit the companion Web site at: www.wiley.com/compbooks/
officebibles2003/. Here™s what you™ll find on the Web site:
. Links to all the software found on the CDs of Wiley™s Office 2003 Bibles.
. Complete, detailed tables of contents for all the Wiley Office 2003 Bibles: Access
2003 Bible, Excel 2003 Bible, FrontPage 2003 Bible, Office 2003 Bible, Outlook
2003 Bible, PowerPoint 2003 Bible, and Word 2003 Bible
. Links to other Wiley Microsoft Office titles


Conventions Used in This Book
To make this book as easy as possible, icons in the margins alert you to special or
important information. Look for the following icons:

Caution Marks a warning about a particular procedure to which you should pay
particular attention.


Note Marks a special point or supplementary information about a feature or task.



Tip
Marks a tip that saves you time and helps you work more efficiently.

To further assist you in reading and learning the material in this book, the following
formatting conventions are used throughout:
. Text you are asked to type appears in bold.
. New words and phrases that may require definition and explanation appear in italics.
Text that carries emphasis and single characters that may be easy to lose in the text
also appear in italics.
. Menu commands are indicated in chronological order by using the command arrow:
File_Open.
. Keyboard shortcut keys look like this: Alt+Tab.
. When instructed to click an item, press the left mouse button unless otherwise
specified. When you should use the right mouse button instead, you are asked to
right-click. Of course, this will be different for left-handed users.
. . .
2
CHAPTER



Paragraph
Formatting
in Word . . . .

In This Chapter

Aligning paragraphs


P
Adjusting line and
aragraphs ” the basic building blocks of any document ”
paragraph spacing
have a special meaning in Microsoft Word. Paragraphs can
include any amount of text and graphics, or any other item,
Setting tabs and indents
followed by a paragraph mark or break. Paragraph marks store the
formatting applied to each paragraph. In this chapter, you learn the
Enhancing paragraphs
fundamentals of paragraph formatting in Word.
using lines, borders,
Each time you press the Enter key, Word begins a new paragraph. and shading
Click the Show/Hide button on the Standard toolbar or press
Ctrl+Shift+* to display the paragraph marks. Press the Enter key
Creating bulleted,
several times, and you™ll see Word insert strange little backward P
numbered, and outline
icons, with the semicircle at the top of the P filled in. These are the
numbered lists
paragraph marks, and they store the information about the paragraph.
Hyphenating your
The paragraph ends at the paragraph mark. Thus formatting for a documents
paragraph is held in the paragraph mark at the end of the text; delete
Note
that mark and the formatting for the preceding text is removed and . . . .
replaced with the formatting held in the next paragraph mark.


Applying Paragraph Formatting
This chapter looks at how to apply paragraph formatting directly.
In order to apply formatting to a paragraph, place the cursor
inside the paragraph you want to modify. Make sure you have
not selected any text within the paragraph, though, but that the
cursor is merely sitting in the paragraph. (In some cases if
you™ve selected a few characters or words and you apply some
kind of format, you™ll be modifying just the selected text, not the
entire paragraph.) You can also select an entire paragraph, or
multiple paragraphs, and then apply formatting.
Part I ¦ Getting Functional with Office 2003
8

When you press Enter to start a new paragraph, that new paragraph will, in general, contain
exactly the same formatting as the previous paragraph. There are some cases when this
won™t happen, though. Some styles may be set up such that when you press Enter a new
style, with different formatting, is used for the next paragraph. For instance, a heading style
may be set up to automatically begin working with a body-text style when you press Enter.
You can apply paragraph formatting using buttons on the Formatting toolbar (see Figure
2-1), settings in the Paragraph dialog box (see Figure 2-2), or shortcut keys. By changing
the formatting of a paragraph, you can change the alignment and spacing of the lines
within that paragraph.



Figure 2-1: The Formatting toolbar.




Figure 2-2: The Paragraph dialog box.


Checking paragraph formats
The formats applied to the current paragraph appear in the settings on the Formatting
toolbar, the horizontal ruler, and in the Paragraph dialog box. If you select several
paragraphs with different formats, the dialog box settings may appear blank or dimmed.
Word cannot indicate different formats at the same time. On the ruler, dimmed indent and
tab markers show the settings for the first paragraph in the selection.
With Word, you can display information about any paragraph formats that are applied to a
given paragraph. To check the formatting of a paragraph, choose Format_Reveal
Formatting, or press Shift+F1 and the Reveal Formatting task pane opens (see Figure 2-3).
You can now click in a paragraph to see what formatting has been applied to the paragraph.
Chapter 2 ¦ Paragraph Formatting in Word 9




Figure 2-3: Paragraph formatting information


Duplicating paragraph formats
The easiest way to duplicate paragraph formatting is to carry that formatting forward by
pressing Enter. The current paragraph ends and a new one begins with the same formatting as
the preceding one. If the formatting that you want to copy is in another part of your document
or even a different document, use the Format Painter, with which you can duplicate all of the
formatting in the selected text. To use the Format Painter, select the text with the formatting
that you want to copy. Make sure that you select the entire paragraph, including the paragraph
mark at the end. Click the Format Painter button (see Figure 2-4) on the Standard toolbar, and
select the block of text to which you want to apply the formatting. Again, if you want to make
sure that you transfer all the paragraph formatting, be sure to select the entire paragraph,
including the end paragraph mark. Or, you can select several paragraphs at the same time.



Figure 2-4: The Format Painter button.

If you want to copy formats and apply them to multiple non-contiguous paragraphs, select
the paragraph with the formatting that you want to copy, double-click the Format Painter
button, and then select, one at a time, the paragraphs that you want to change. Click the
Format Painter button or press Esc to end the formatting.
Part I ¦ Getting Functional with Office 2003
10

You can also apply a formatting change to different paragraphs. Apply it once; then click
the next paragraph and select Edit_Repeat, press Ctrl+Y, or press F4. Remember that these
commands duplicate only the last action. So if you want to apply multiple formats at the
same time, such as both bold and strikethrough, use the Format Font dialog box rather than
keyboard shortcuts before using Edit_Repeat.
Because formats are stored in the paragraph mark, you can copy and paste the paragraph
mark itself to create new paragraphs with the same formatting. Use the Show/Hide button
to display the paragraph marks, select the paragraph mark of the paragraph that you want to
change, copy that mark, and then paste the copied paragraph mark immediately after the
last character of the paragraph to which you wish to apply formatting.

Removing paragraph formats
You can use a shortcut to remove any paragraph™s formats that have been applied,
converting the format back to that which is used by the paragraph™s style. We™d better
clarify that: Every paragraph in your document has a style applied to it. For instance, most
text will probably use the Normal style. The style defines how much space appears before
and after the paragraph, how much space between lines, and so on. But you can apply
formatting directly to the paragraph. For instance, say you used the Paragraph dialog box to
specify that a block of text is double-spaced, here™s a blank line after every line. That
paragraph format has been, in effect, laid over the Normal style™s settings.

<< . .

. 3
( : 51)



. . >>