SmartSuite 97 for Windows for Dummies Book

Introduction

About This Book

How This Book Is Organized

Part I: A Suite Deal

Part II: Take a Letter, Word Processor

Part III: Spreadsheets As Easy As, Well -- 1-2-3!

Part IV: Caution -- Database Approaching

Part V: Freelance's Presentation Power

Part VI: Organize Your Life

Part VII: The Part of Tens

A Word About Teamwork and Passing Notes

Foolish Assumptions

Read More Dummies Books

Conventions Used in the Book

Icons Used in This Book

Where to Go from Here

Part I: A Suite Deal

Chapter 1: Boot Camp for SmartSuite

How Suite It Is: The SmartSuite Family

It's All in the Family

Get smart -- icons, that is

Checking your status (bar)

Keeping tabs on dialog boxes

Use Fast Format to make quick work of copying styles

InfoBox -- the super dialog box

Impress your mom -- spell it right

Save your stuff

A quick trip to the printer

Go team!

Caught Up in the Net

Chapter 2: Taking Control: Working with SmartCenter

What Is SmartCenter?

Opening Drawers and Folders

SmartSuite programs and documents

Internet

Addresses and mail

Calendar

Reminders

Reference

Suite Help

Customizing SmartCenter

Redecorating SmartCenter

Adding drawers and folders

What can I put in a SmartCenter drawer?

SuiteStart: A Tray Full of SmartSuite Programs

Chapter 3: Moving On

Help! What Do I Do Now?

Taking a tour

Hey! How about some help over here?

Casting the Net

What Program Do I Use -- and When?

Part II: Take a Letter, Word Processor

Chapter 4: Boot Camp for Word Pro

What's a Word Pro?

Starting Word Pro

Welcome to Word Pro

Making Friends with Word Pro's Screen

Entering Text

What's Your Mode?

Getting from Here to There on the Word Pro Screen (Wherever "There" Is)

Keyboard kapers and shortkuts

Stupid mouse tricks

Being Selective

Moving and Copying Text

I Didn't Mean to Do It -- So Now What?

What can Undo undo?

What can't Undo undo?

Making Undo do its thing

Saving Stuff

We're Off to See the Printer

Chapter 5: Format with Style

Formatting Basics

Doing Stuff to Text

Making text bold, italic, or underlined

Changing the type style or size

Getting rid of text formatting

Adding Tabs and Indents

Setting tabs

Changing indents

Lining Up Text

Spacing Out

Changing the Page Layout

Selecting pages

Setting page size and margins

Adding lines

Inserting a page layout

Creating Headers and Footers

Inserting the Date or Time

Understanding Paragraph Styles

Understanding SmartMasters

Starting a new document based on a SmartMaster

Working with styles in a SmartMaster

Chapter 6: Polishing Up Your Word Pro Document

It's a Frame-Up!

Creating a frame

Doing stuff to frames

Putting stuff in frames

Tabular, Dude!

Finding and Replacing Stuff

SmartCorrect Takes Shorthand

Spelling Words Right

Using Thesaurus for the Perfect Phrase

Fix Picky Details by Using Format Check and Grammar Check

Keeping Track of Revisions

Marking edits

Reviewing marked edits

Chapter 7: Word Pro Final Touches and Shortcuts

Hey, Babe, Wanna Merge?

Creating a form letter from scratch

Creating a form letter by using an Approach database

Automating Word Pro

Recording a script

Playing a script

Fill in the blanks with Click Here blocks

Getting Info about Documents

Part III: Spreadsheets As Easy As, Well -- 1-2-3!

Chapter 8: Boot Camp for 1-2-3 (a.k.a. Basic Training by the Numbers)

Hey, Mr. Wizard, What's a Spreadsheet?

Starting 1-2-3

Getting Around

Correctly addressing 1-2-3

Beam me up -- or over

Entering Labels and Values

Makin' Copies

Doing the Math -- the Formula for Calculating in 1-2-3

Copying formulas

Doing the math II -- functional literacy

That's SUM function

Naming Ranges

Printing Your Worksheet

Chapter 9: I Feel Pretty (Adding Style to Your Worksheet)

Formatting Numbers

Formatting automatically -- sometimes

Changing number formats

Line 'em Up -- Aligning Your Cell Entries

Using Fonts to Spruce Things Up

Changing Column Widths and Row Heights

Adding Lines, Borders, and Frames

Pictures at an Exhibition -- Using Gallery Styles

Chapter 10: Charting Your Course

Chart Chat

Creating Charts, Quick and Dirty

Editing Charts

Printing Charts

Choosing the Chart Type That Makes Your Point

Chapter 11: Final Touches and Shortcuts for 1-2-3

Enhancing Worksheets and Charts by Using the 1-2-3 Drawing Tools

Moving and resizing objects

Changing an object's attributes

So why draw?

Using Spell-Check

Automating Tasks by Using Scripts

Run, Script, Run!

Part IV: Caution -- Database Approaching

Chapter 12: Boot Camp for Approach

Getting to First Base -- Databases Defined

Planning Your Database

Starting Approach

Loading an existing database

Creating a new database with a SmartMaster

Entering Data

Entering data in Form view

Entering data in Worksheet view

Printing Your Database

Designing Your Own Database

How do you want to save your data?

Making sure that you get the right data

Making your own fields of dreams

Chapter 13: Designing Database Forms That Work

Creating a New Form

Editing a Form's Design

Changing the form's name

Changing the border and background color

Changing the Form Layout

Moving and resizing a database field

Changing the font, color, and border of a database field

Adding and Removing Fields

Using the Tools Palette

Typing text and drawing circles, lines, and squares

Adding radio buttons and check boxes

Adding a field from the Tools palette

Saving Your Forms

Chapter 14: Finding Needles in Database Haystacks

Creating a Find

Finding Records That Match a Single Criterion

Finding text

Finding numbers

Finding data in radio buttons and check boxes

Finding blank (or nonblank) fields

Finding Records That Match Multiple Criteria

"Hooked on Phonics" -- Finding Sound-Alike Data

Sending the Find Assistant on a Search

Saving a Find

Chapter 15: Don't Be Out of Sorts Sorting Your Database

Sorting Explained

Changing the Sort Order by Using One Field

Multifield Sorting

Saving a Sort

Get Back -- Returning the Database to Its Original Sort Order

Chapter 16: Putting Your Database on Report

Standard versus Columnar -- Choosing a Report Type

Adding Totals

Making Your Reports Look Great

Adding and modifying a title page

Adding and modifying headers and footers

Changing line settings and colors of database fields

Moving and resizing database fields

Finishing up -- Adding Summaries and Printing Reports

Printing Reports

Chapter 17: Playing Matchmaker -- Joining Databases

What's the Deal with Joining?

Getting Ready to Join

How to join databases

Using joined databases in forms and worksheets

Setting your options for joining

Unjoining Database Files

Chapter 18: Final (Approach) Touches and Shortcuts

Turning Database Numbers into Charts

Creating bar, line, or area charts

Creating pie charts

Automating Data Entry

Verifying Data

Part V: Freelance's Presentation Power

Chapter 19: Boot Camp for Freelance Graphics

Presenting Freelance Graphics

Getting the Show on the Road

You've got the look

Getting a head start with a Content Topic

Picking a layout

Add text (and stir)

Adding clip art

Inserting a New Page

Saving Your Presentation

Chapter 20: Presenting (Ta Daaah!) Tables and Charts

Adding Tables

Entering table text

Entering table attributes

Adding Charts

Chapter 21: Final Touches and Shortcuts à la Freelance

Changing Views

Sorting presentation pages

Outliner view

Freelance Drawing

Roll Camera: Creating a Screen Show

Part VI: Organize Your Life

Chapter 22: Organizer Boot Camp (and Beyond . . .)

Organizer: The Big Picture

Organizer at a glance

Come on in, the water's fine!

The Calendar -- Up Close and Personal

Setting appointments

Ladies and gentlemen, choose a category

Could you repeat that, please?

What's the secret code?

An alarming situation!

Editing in the Calendar section

Moving around in the Calendar

Delete and undelete

Tie a String Around Your Finger -- or Create a To Do List

View options

How To Do an edit -- get it?

Copying To Do tasks

Chapter 23: Putting All the Little Black Books in One Place

Addressing the Issues

View -- a la mode

Searching for Mr. Goodboy

Feeling out of sorts

Number, Please

When I'm calling you

Incoming calls and dialing shortcuts

Editing calls

A call with a view

Planning with a Purpose

Planning to alarm you

Entering events directly

Chapter 24: Organizer -- Final Touches and Shortcuts

You Say It's Your Birthday

Keeping Notes -- Plus a Whole Lot More

Adding a File from Another Application

Almanac -- A Desk Reference at Your Fingertips

Tying Up the Loose Ends

Filtering out the noise

Just a link in the chain

Part VII: The Part of Tens

Chapter 25: Ten Best Tips and Shortcuts (That Work Anywhere)

Create Your Own User Dictionary

Use the SuiteStart icons to Switch Applications

Open Files in a Flash

Make a Bold (Or Italic or Underlined) Statement

Help Is Just a Bubble Away

A File Saved Is a File You Don't Need to Do Over

Check Your Status

Use the Status Bar

Use the Shift+Click Trick

Cut and Paste without Clicking

Chapter 26: Ten Best Tips and Shortcuts for the SmartSuite 97 Programs

Get out of Word Pro Jams by Using Reset to Style

Click to Select in Word Pro

Have 1-2-3 Adjust Your Column Widths for You

Get There Fast in 1-2-3 by Using F5

Modify an Approach Database Template

Automate and Verify Approach Data Entry

Move Freelance Graphics Objects as a Group

Shuffle the Freelance Graphics Deck

Don't Type Repeating Organizer Address Fields -- Duplicate!

Make a Long Leap with the Click of a Mouse

Appendix: Doing the Install Thing

Index

Reader Response Card