Integrated Business Projects Complete Course

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

• ISBN13: 9780538721523
• ISBN10: 0538721529
• Edition: 1st
• Format: Spiral Bound
• Copyright: 1999-08-24
• Publisher: South-Western Educational Pub

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.

Table of Contents

MODULE 1 Sales and Marketing
Sales Conference Documents	2	(23)
Prepare Welcome Lette and Email	2	(2)
Key/Compose Letters	4	(3)
Key Equipment List	7	(1)
Key Introductions for Speakers	8	(1)
Create Cover Page	9	(1)
Create Email or Memo with Distribution List	10	(4)
Create Facilitator Table	14	(1)
Develop Agenda	15	(1)
Prepare Conference Schedule	16	(3)
Create Fax with Table	19	(1)
Format Reading List	20	(3)
Create Conference Signs	23	(1)
Compose Email/Memo with Hyperlinks	24	(1)
Sales Documents	25	(18)
Create Table	25	(1)
Design Enhanced Tables	26	(3)
Design Thank-You Note	29	(1)
Prepare Sales Manual	30	(4)
Create Petty Cash Form	34	(2)
Design Customer Forms	36	(2)
Finish Sales Manual	38	(4)
Create Cover Page	42	(1)
Mass Mailings	43	(16)
Merge Letter to Vendors	43	(4)
Update and Sort Data File; Create Labels	47	(3)
Create Personalized Stationery and Notepads	50	(2)
Prepare Certificates	52	(2)
Create Calendar of Events	54	(2)
Key Brochure and Fax	56	(2)
Create Directory of Representatives' Addresses	58	(1)
Presentations	59	(20)
Create Welcome Slides	59	(3)
Create Presentation	62	(3)
Edit Presentation	65	(3)
Create Presentation Charts	68	(4)
Create Unique Templates	72	(2)
Create Speaker's Notes	74	(2)
Create Automatic Slide Shows	76	(3)
Integrated Assignments	79	(23)
Create Brochure	79	(5)
Prepare Company Newsletter with Graphics	84	(6)
Add Chart to Newsletter	90	(1)
Create Presentation	91	(8)
Merge/Database	99	(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	(1)
Index	1