book

Microsoft® Office System Step by Step -- 2003 Edition

by Online Training Solutions Inc., Curtis Frye

September 2003

Beginner

992 pages

27h

English

Microsoft Press

Read now

Unlock full access

Microsoft® Office System: Step by Step, 2003 Edition
SPECIAL OFFER: Upgrade this ebook with O’Reilly
A Note Regarding Supplemental Files
What’s New in The Microsoft Office System 2003
Other New Features in The Microsoft Office System 2003Microsoft OneNoteMicrosoft InfoPathCollaboration with The Microsoft Office System 2003
Getting Help
Getting Help with This Book and Its CD-ROM
Getting Help with The Microsoft Office System 2003
More Information
Using the Book’s CD-ROM
What’s on the CD-ROM?
Minimum System Requirements
Installing the Practice Files

Opening the Practice Data Files in Outlook
Using the Practice Files
Uninstalling the Practice Files
Conventions and Features
About the Authors
Online Training Solutions, Inc. (OTSI)
Kristen Crupi
Perspection, Inc.
Quick Reference
Chapter 1 Working with Documents
Chapter 2 Editing and Proofreading a Document
Chapter 3 Changing the Look of Text
Chapter 4 Presenting Information in Tables and Columns
Chapter 5 Setting Up a Workbook
Chapter 6 Performing Calculations on Data
Chapter 7 Changing Document Appearance
Chapter 8 Focusing on Specific Data Using Filters
Chapter 9 Creating a New Database
Chapter 10 Simplifying Data Entry with Forms
Chapter 11 Locating Specific Information
Chapter 12 Keeping Your Information Accurate
Chapter 13 Creating Presentations
Chapter 14 Working with Slides
Chapter 15 Working with Slide Text
Chapter 16 Setting Up and Delivering Slide Shows
Chapter 17 Working with Outlook
Chapter 18 Managing E-mail Messages
Chapter 19 Finding and Organizing E-mail Messages
Chapter 20 Managing Your Calendar
Chapter 21 Scheduling and Managing Meetings
Chapter 22 Understanding How FrontPage Works
Chapter 23 Creating a Web Site to Promote Yourself or Your Company
Chapter 24 Presenting Information in Lists and Tables
Chapter 25 Enhancing Your Web Site with Graphics
Chapter 26 Creating and Printing Publications
Chapter 27 Creating Web Sites and E-mail Messages
Chapter 28 Taking Notes
Chapter 29 Working with Notes
Chapter 30 Working with InfoPath Forms
Chapter 31 Designing InfoPath Forms
Chapter 32 Working in a Document Workspace
Chapter 33 Teaming Up in a Meeting Workspace
I. Microsoft Office Word 2003
1. Working with Documents
Getting Started with Word
Creating, Saving, and Closing Documents
Opening and Viewing Existing Documents
Deciding Which View to Use When
Key Points
2. Editing and Proofreading Documents
Editing a Document
Using Text Entry Shortcuts
Finding the Best Word
Using an Outline to Rearrange Paragraphs
Finding and Replacing Text
Checking Spelling and Grammar
Key Points
3. Changing the Appearance of Text
Changing the Look of Characters
Changing the Look of Paragraphs
Creating and Modifying Lists
Formatting Text as You Type
Changing the Look of Characters and Paragraphs with Styles
Key Points
4. Presenting Information in Tables and Columns
Presenting Information in a Table
Formatting Table Information
Working with Table Data
Presenting Text in Columns
Key Points
II. Microsoft Office Excel 2003
5. Setting Up a Workbook
Making Workbooks Easier to Work With
Making Data Easier to Read
Adding a Graphic to a Document
Key Points
6. Performing Calculations on Data
Naming Groups of Data
Creating Formulas to Calculate Values
Finding and Correcting Errors in Calculations
Key Points
7. Changing Document Appearance
Changing the Appearance of Data
Applying an Existing Format to Data
Making Numbers Easier to Read
Changing Data’s Appearance Based on Its Value
Making Printouts Easier to Follow
Positioning Data on a Printout
Key Points
8. Focusing on Specific Data Using Filters
Limiting the Data That Appears on the Screen
Performing Calculations on Filtered Data
Defining a Valid Set of Values for a Range of Cells
Key Points
III. Microsoft Office Access 2003
9. Creating a New Database
Creating a Database Structure the Simple Way
Checking the Work of a Wizard
Creating Tables the Simple Way
Refining How Data Is Displayed
Manipulating Table Columns and Rows
Key Points
10. Simplifying Data Entry with Forms
Creating a Form by Using a Wizard
Refining Form Properties
Refining Form Layout
Adding Controls to a Form
Using Visual Basic for Applications to Enter Data in a Form
Creating a Form by Using an AutoForm
Adding a Subform to a Form
Key Points
11. Locating Specific Information
Sorting Information
Filtering Information in a Table
Filtering By Form
Locating Information That Matches Multiple Criteria
Creating a Query in Design View
Creating a Query with a Wizard
Performing Calculations in a Query
Key Points
12. Keeping Your Information Accurate
Using Data Type Settings to Restrict Data
Using Field Size Properties to Restrict Data
Using Input Masks to Restrict Data
Using Validation Rules to Restrict Data
Using Lookup Lists to Restrict Data
Updating Information in a Table
Deleting Information from a Table
Key Points
IV. Microsoft Office PowerPoint 2003
13. Creating Presentations
Getting Started with PowerPoint
Opening, Saving, and Closing a Presentation
Viewing a Presentation
Creating a Presentation Based on Content
Creating a Presentation Based on Design
Creating a New Blank Presentation
Key Points
14. Working with Slides
Creating Slides and Entering Text
Changing the Layout of a Slide
Inserting Slides from Another Presentation
Rearranging a Presentation
Entering Speaker Notes
Key Points
15. Working with Slide Text
Adding and Manipulating Text
Changing Size, Alignment, and Spacing
Finding and Replacing Text and Fonts
Correcting Text While Typing
Checking Spelling and Presentation Styles
Choosing the Best Word
Key Points
16. Setting Up and Delivering Slide Shows
Taking a Presentation on the Road
Delivering a Slide Show
Customizing a Slide Show
Adding Slide Timings
Using Microsoft Producer to Set Up an Online Broadcast
Key Points
V. Microsoft Office Outlook 2003
17. Working with Outlook
Starting Outlook for the First Time
Reading Messages and Opening Attachments
Responding to Messages
Creating New Messages
Using Address Books
Attaching Files to Messages
Sending and Receiving Messages
Printing Messages
Creating and Sending Instant Messages
Key Points
18. Managing E-Mail Messages
Formatting Messages
Changing Message Settings and Delivery Options
Customizing How You View Messages
Managing Messages with Color
Adding Signatures to Messages
Flagging Messages for Follow-Up
Key Points
19. Finding and Organizing E-Mail Messages
Finding and Categorizing Messages
Using Search Folders
Filtering Messages
Managing Messages through Rules
Organizing Messages in Folders
Sharing Folders with Others
Saving Messages in Other Formats
Archiving Messages
Key Points
20. Managing Your Calendar
Looking at Calendars in Different Ways
Scheduling Appointments and Events
Managing and Organizing Appointments
Working with Multiple Calendars
Defining Your Available Time
Labeling Appointments with Color
Printing Calendars
Key Points
21. Scheduling and Managing Meetings
Scheduling Meetings
Responding to Meeting Requests
Updating and Canceling Meetings
Viewing Other Users’ Calendars
Saving a Calendar as a Web Page
Key Points
VI. Microsoft Office FrontPage 2003
22. Understanding How FrontPage Works
Looking Around in FrontPage
Exploring an Existing Web Site
Looking at a Web Site in Various Ways
Exploring an Existing Web Page
Understanding FrontPage Web Site Concepts
Key Points
23. Creating a Web Site to Promote Yourself or Your Company
Creating a New Web Site by Using a Template
Creating a New Web Site by Using a Wizard
Inserting and Editing Text
Reusing Existing Text
Formatting Text
Inserting Hyperlinks
Seeing Your Web Site as Visitors Will
Deleting a Web Site
Key Points
24. Presenting Information in Lists and Tables
Creating Bulleted and Numbered Lists
Creating Tables
Entering Information in a Table
Editing the Structure of a Table
Formatting a Table
Splitting a Table into Separate Tables
Key Points
25. Enhancing Your Web Site with Graphics
Adding Pictures to a Web Page
Editing and Formatting Pictures
Creating and Displaying Thumbnails
Adding a Line, Shape, or Drawing to a Web Page
Creating a Photo Gallery
Adding Fancy Text to a Web Page
Key Points
VII. Microsoft Office Publisher 2003
26. Creating and Printing Publications
Creating a Publication for the First Time
Creating a Print Publication by Using a Design Set
Creating a Publication from a Blank Page
Creating and Using a Template
Printing a Publication
Preparing a Document for a Commercial Printing Service
Key Points
27. Creating Web Sites and E-mail Messages
Creating an E-mail Message by Using a Wizard
Sending a Publication as an E-mail Message
Creating a Web Site from Scratch
Publishing a Web Site
Creating a Web Site from an Existing Publication
Updating a Web Site
Converting a Web Publication to a Print Publication
Key Points
VIII. Microsoft Office OneNote 2003
28. Taking Notes
Using OneNote for the First Time
Adding Drawings and Images
Finding and Inserting Web Clippings
Adding Pages and Sub Pages
Moving Notes on Pages
Organizing Notes into Sections and Folders
Key Points
29. Working with Notes
Using Quick Notes
Marking Notes with Note Flags
Searching Notes
Sending Notes in E-mail
Creating Outlook Tasks from Notes
Key Points
IX. Microsoft Office InfoPath 2003
30. Working with InfoPath Forms
Completing InfoPath Forms
Updating Form Data
Viewing and Sorting Form Data
Importing and Exporting Form Data
Sharing and Publishing Forms
Key Points
31. Designing InfoPath Forms
Modifying an Existing Form
Designing a New Form
Creating Form Views
Validating Form Data
Key Points
X. Collaborating with The Microsoft Office System
32. Working in a Document Workspace
Creating a Document Workspace and Managing Workspace Members
Creating and Assigning Document Tasks
Updating a Document in a Workspace
Receiving Alerts When Information in a Workspace Changes
Starting a Discussion in a Workspace
Customizing a Document Workspace
Key Points
33. Teaming Up in a Meeting Workspace
Creating a Meeting Workspace
Documenting Meeting Objectives and Agenda Items in a Workspace
Posting Meeting Materials to a Workspace
Creating and Assigning Meeting Tasks
Customizing a Meeting Workspace
Key Points
Glossary
Index
SPECIAL OFFER: Upgrade this ebook with O’Reilly

Content preview from Microsoft® Office System Step by Step -- 2003 Edition

Chapter 9. Creating a New Database

Chapter 9 at a Glance

In this chapter you will learn to:
✓	Creating a Database Structure the Simple Way.
✓	Checking the Work of a Wizard.
✓	Creating Tables the Simple Way.
✓	Refining How Data Is Displayed.
✓	Manipulating Table Columns and Rows.

Creating the structure for a database is easy. But an empty database is no more useful than an empty Microsoft Office Word document or an empty Microsoft Office Excel worksheet. It is only when you fill, or populate, a database with data in tables that it starts to serve a purpose. As you add queries, forms, and reports, it becomes easier to use. If you customize it with a switchboard ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

2007 Microsoft® Office System Step by Step

Publisher Resources

ISBN: 0735615209Catalog Page Errata

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Microsoft® Office System Step by Step -- 2003 Edition

by Online Training Solutions Inc., Curtis Frye

Chapter 9. Creating a New Database

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

More than 5,000 organizations count on O’Reilly

Julian F.

Addison B.

Amir M.

Mark W.

You might also like

2007 Microsoft® Office System Step by Step

Microsoft® Office Word 2003 Step by Step

Microsoft® Office Outlook® 2003 Step by Step

Microsoft Office 2016 Step by Step

Publisher Resources