Amazon no longer offers textbook rentals. We do!

Integrated Business Projects Complete Course

by: Olinzock, Anthony A.; Arney, Janna; Skean, Wylma

Integrated Business Projects Complete Course

by: Olinzock, Anthony A.; Arney, Janna; Skean, Wylma

ISBN 13:
9780538721523
ISBN 10:
0538721529
Edition: 1st
Format: Spiral Bound
Copyright: 08/24/1999
Publisher: South-Western Educational Pub
Newer Edition

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

Integrated Business Projects is a fun, applications-oriented text that reinforces the major office applications found in suite software--word processing, electronic presentations, spreadsheets, and databases. The users are asked to participate in various common office careers that use these applications to show the real-world significance of learning the software.

MODULE 1 Sales and Marketing

Sales Conference Documents

(23)

Prepare Welcome Lette and Email

(2)

Key/Compose Letters

(3)

Key Equipment List

(1)

Key Introductions for Speakers

(1)

Create Cover Page

(1)

Create Email or Memo with Distribution List

(4)

Create Facilitator Table

(1)

Develop Agenda

(1)

Prepare Conference Schedule

(3)

Create Fax with Table

(1)

Format Reading List

(3)

Create Conference Signs

(1)

Compose Email/Memo with Hyperlinks

(1)

Sales Documents

(18)

Create Table

(1)

Design Enhanced Tables

(3)

Design Thank-You Note

(1)

Prepare Sales Manual

(4)

Create Petty Cash Form

(2)

Design Customer Forms

(2)

Finish Sales Manual

(4)

Create Cover Page

(1)

Mass Mailings

(16)

Merge Letter to Vendors

(4)

Update and Sort Data File; Create Labels

(3)

Create Personalized Stationery and Notepads

(2)

Prepare Certificates

(2)

Create Calendar of Events

(2)

Key Brochure and Fax

(2)

Create Directory of Representatives' Addresses

(1)

Presentations

(20)

Create Welcome Slides

(3)

Create Presentation

(3)

Edit Presentation

(3)

Create Presentation Charts

(4)

Create Unique Templates

(2)

Create Speaker's Notes

(2)

Create Automatic Slide Shows

(3)

Integrated Assignments

(23)

Create Brochure

(5)

Prepare Company Newsletter with Graphics

(6)

Add Chart to Newsletter

(1)

Create Presentation

(8)

Merge/Database

(3)

MODULE 2 Financial Services

Inventory Worksheet

102

(10)

Build the Inventory Worksheet

102

(4)

Format Columns and Rows

106

(2)

Add Records and Sort

108

(2)

Hyperlink to Vendor Worksheet

110

(2)

Employee Records Worksheet

112

(10)

Build Employee Records Worksheet

112

(3)

Add and Delete Records

115

(2)

Enter Values, Formulas, and VLOOKUP Function

117

(2)

Add Column and Use SUM and AVG Functions

119

(2)

Prepare Email/Report with Worksheet

121

(1)

Departmental Sales Workbook

122

(15)

Create Workbook with Multiple Worksheets

122

(4)

Link Data on Multiple Worksheets

126

(3)

Create Template of Sales Workbook

129

(3)

Update Sales Workbook

132

(1)

Create Profit Ratio Chart

133

(2)

Create Memo to Department Chairpersons

135

(2)

Sales Forecasting

137

(16)

Create a Worksheet from a Table

137

(3)

Apply Logical Functions

140

(2)

Create Pie Chart

142

(3)

Forecast Sales Using What If Analysis

145

(1)

Forecast Expenses Using What If Analyses

146

(2)

Apply Automated Formatting

148

(1)

Embed Worksheet in Document

149

(1)

Embed Worksheets in Memo

150

(3)

Petty Cash Fund Worksheet

153

(10)

Build Petty Cash Worksheet

153

(3)

Enter Comments and Functions

156

(3)

Record a Macro and Create a Button

159

(2)

Copy a Spreadsheet into a Memo

161

(1)

Enter Transactions and Complete Cash Vouchers

162

(1)

Build Book Inventory Worksheet with Hyperlink to Internet

163

(10)

Build the Book Inventory and Insert Hyperlink

163

(2)

Use Hyperlink and Search a Web Site

165

(3)

Find Records on a Worksheet

168

(2)

Use an Applet to Create a Hyperlink

170

(2)

Research Web Site and Create Email

172

(1)

Product Line Workbook

173

(11)

Add Formulas and Sort Data

173

(3)

Filter Records

176

(1)

Compose Memo and Embed Worksheet

176

(2)

Deleting Records

178

(1)

Filter Records and Compose Memo

178

(1)

Link Worksheet to Memos

179

(3)

Update Links

182

(1)

Update Linked Workbook and Print Memos

183

(1)

Monthly Installment Calculations

184

(10)

Build Worksheet with PMT Function and Callouts

184

(3)

Add Conditions, Macros, and Comments

187

(3)

Test the Monthly Installment Worksheet

190

(1)

Locating and Financing a Used Car

191

(3)

MODULE 3 Purchasing and Operations

Working with the Purchasing Database

194

(15)

Review Vendor and Customer Table

194

(4)

Create and Enter Data for Inventory Table

198

(4)

Edit Fields and Sort Records

202

(3)

Run Queries and Print Reports

205

(4)

Maintaining the Purchasing Database

209

(16)

Query the Inventory Table

209

(4)

Edit Data Field Definitions

213

(4)

Update Data Records

217

(4)

Add Data Validation Rules

221

(4)

Customizing the Purchasing Database

225

(13)

Query the Purchasing Database

225

(5)

Create Queries with Calculations and Summary Operators

230

(4)

Create Reports

234

(2)

Create a Grouped Report from a Query

236

(2)

Simplifying the Purchasing Database

238

(8)

Modify a Simple Form

238

(3)

Create a Custom Form

241

(1)

Create Mailing Labels

242

(2)

Create Graphs

244

(2)

MODULE 4 Administrative Services

Financial Reports and Stockholder's Report

246

(13)

Build the Income Statement Worksheet

246

(3)

Build the Balance Sheet Worksheet

249

(4)

Create Chart Comparing Operating Efficiency

253

(1)

Prepare Agenda and Email

254

(1)

Create Stockholder's Report

255

(2)

Create a Customer Mailing

257

(2)

Web Site

259

(2)

Prepare the Home Page

261

(1)

Prepare the Sale Merchandise Page

262

(1)

Prepare Product and Customer Information Page

263

(2)

Add Bookmarks and Hyperlinks to Navigate Pages

265

(1)

Test the Web Site

266

Reference Guide

(1)

Index

Amazon no longer offers textbook rentals. We do!

Integrated Business Projects Complete Course

Integrated Business Projects Complete Course

9780538721523

0538721529

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Integrated Business Projects Complete Course

Integrated Business Projects Complete Course

9780538721523

0538721529

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products