Performing With Microsoft Office Xp Advanced Course

by Blanc,Iris (Iris Blanc)

• ISBN13: 9780619058555
• ISBN10: 0619058552
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2002-04-12
• Publisher: Cengage Learning

Summary

The Performing Series takes students to a higher level of learning through applied and project-based activities that go beyond the mechanics of the software.

Table of Contents

Preface
PERFORMANCE REVIEW
Lesson 1 Applications Review
Rehearsal Task 1	4	(2)
Rehearsal Task 2	6	(2)
Rehearsal Task 3	8	(2)
Rehearsal Task 4	10	(2)
Rehearsal Task 5	12	(2)
Performance	14	(4)
Lesson 2 Internet Review
Tryout Task 1: Launch Internet Explorer; Navigate the Browser Window; Access a Web Site Using a Web Address (URL); Print Web Pages; Exit the Browser	18	(4)
Rehearsal Task 1	22	(2)
Tryout Task 2: Use Favorites Folders; Organize Favorites Folders; Copy from a Web Site; Save Web Pages	24	(6)
Rehearsal Task 2	30	(2)
Tryout Task 3: Search the Internet	32	(4)
Rehearsal Task 3	36	(2)
Encore	38
PERFORMING WITH WORD
Lesson 7 Correspondence
Tryout Task 1: About Advanced Word; Merge a Table Cell; Split a Table Cell; AutoFit Table Contents; Perform Calculations in Word Tables	3	(3)
Rehearsal Task 1	6	(2)
Tryout Task 2: Use Mail Merge; Merge a Letter with a Data Source; Merge Labels with a Data Source; Merge Envelopes with a Data Source; Merge E-mail with a Data Source	8	(10)
Rehearsal Task 2	18	(2)
Tryout Task 3: Create, Edit, and Run Macros; Delete a Macro; Rename or Copy a Macro	20	(8)
Rehearsal Task 3	28	(2)
Performance	30	(2)
Encore	32	(3)
Lesson 8 Reports and Long Documents
Tryout Task 1: Manage Orphans and Widows; Set Line Breaks; Set Page Breaks; Create and Format Document Sections; Use the Format Inspector to Verify Paragraph Format; Clear Formats	35	(9)
Rehearsal Task 1	44	(2)
Tryout Task 2: Apply a Style; Modify a Style; Create a Style	46	(6)
Rehearsal Task 2	52	(2)
Tryout Task 3: Create and Use Bookmarks; Create and Use a Document Map; Create Cross-References	54	(4)
Rehearsal Task 3	58	(2)
Tryout Task 4: Use Reference Tools	60	(6)
Rehearsal Task 4	66	(2)
Tryout Task 5: Create and Manage Master Documents and Subdocuments; Create, Format, and Edit Footnotes; Create, Format, and Edit Endnote	68	(5)
Rehearsal Task 5	73	(3)
Performance	76	(2)
Encore	78	(3)
Lesson 9 Meeting Documents and Schedules
Tryout Task 1: Understand Workgroup Collaboration; Use Electronic Comments	81	(9)
Rehearsal Task 1	90	(2)
Tryout Task 2: Track Changes to a Document; Review Changes to a Document; Merge Input from Several Reviewers; Distribute Documents for Revision via E-mail	92	(8)
Rehearsal Task 2	100	(2)
Tryout Task 3: Create and Edit Web Documents in Word; Create Multiple Versions of a Document	102	(4)
Rehearsal Task 3	106	(2)
Performance	108	(1)
Encore	109	(4)
Lesson 10 Sales and Marketing Documents
Tryout Task 1: Format and Insert Graphics; Modify and Delete Graphics; Work with Graphics and Text; Position a Graphic	113	(17)
Rehearsal Task 1	130	(4)
Tryout Task 2: Sort Paragraphs in Lists; Sort Paragraphs in Tables	134	(2)
Rehearsal Task 2	136	(2)
Tryout Task 3: Create and Modify Forms Using Various Form Controls; Protect Forms; Distribute Forms	138	(8)
Rehearsal Task 3	146	(2)
Performance	148	(2)
Encore	150	(3)
Lesson 11 Integration
Tryout Task 1: Use Hyperlinks; Create a Custom Menu	153	(8)
Rehearsal Task 1	161	(3)
Tryout Task 2: Understand Integration	164	(6)
Rehearsal Task 2	170	(2)
Performance	172	(2)
Encore	174
PERFORMING WITH EXCEL
Lesson 8 Budgets and Templates
Tryout Task 1: About Advanced Excel; Create a Workspace Consisting of Two or More Workbooks; Consolidate Data from Two or More Worksheets; Link Consolidated Data	3	(5)
Rehearsal Task 1	8	(2)
Tryout Task 2: Create a Workbook Template; Create a New Workbook Based on a User-Created Template; Edit a Workbook Template	10	(2)
Rehearsal Task 2	12	(2)
Performance	14	(2)
Encore	16	(3)
Lesson 9 Data Tables
Tryout Task 1: Create and Apply Custom Number Formats; Use Conditional Formats	19	(3)
Rehearsal Task 1	22	(2)
Tryout Task 2: Name a Range; Use a Named Range Reference in a Formula; Use HLOOKUP and VLOOKUP	24	(4)
Rehearsal Task 2	28	(2)
Tryout Task 3: Audit Formulas; Locate and Resolve Errors in Formulas; Identify Dependencies in Formulas	30	(6)
Rehearsal Task 3	36	(2)
Performance	38	(2)
Encore	40	(3)
Lesson 10 Accounting Records
Tryout Task 1: Customize Toolbars and Menus	43	(3)
Rehearsal Task 1	46	(2)
Tryout Task 2: Create, Edit, and Run Macros	48	(6)
Rehearsal Task 2	54	(2)
Performance	56	(3)
Encore	59	(4)
Data Lists
Tryout Task 1: Create and Sort a List; Use Subtotals with Lists and Ranges	63	(5)
Rehearsal Task 1	68	(2)
Tryout Task 2: Define and Apply Filters	70	(4)
Rehearsal Task 2	74	(2)
Tryout Task 3: Add Group and Outline Criteria to Ranges; Use Data Validation	76	(4)
Rehearsal Task 3	80	(2)
Performance	82	(2)
Encore	84	(3)
Lesson 12 Marketing and Sales Reports
Tryout Task 1: Import Data into Excel; Export Data from Excel; Publish Worksheets and Workbooks to the Web	87	(7)
Rehearsal Task 1	94	(2)
Tryout Task 2: Retrieve External Data and Crate Queries; Create Extensible Markup Language (XML) Web Queries	96	(6)
Rehearsal Task 2	102	(2)
Performance	104	(2)
Encore	106	(3)
Lesson 13 Data Analysis
Tryout Task 1: Create PivotTables and PivotTable Reports; Modify and Format PivotTables; Create PivotCharts and PivotChart Reports from a PivotTable; Create PivotCharts and PivotChart Reports from a Data List	109	(9)
Rehearsal Task 1	118	(2)
Tryout Task 2: Forecast Values with What-if Analysis	120	(4)
Rehearsal Task 2	124	(2)
Tryout Task 3: Create and Display Scenarios; Create and Print Reports with the Report Manager Add-in	126	(4)
Rehearsal Task 3	130	(3)
Performance	133	(3)
Encore	136	(3)
Lesson 14 Accounting Department: Shared Files
Tryout Task 1: Modify Passwords, Protections, and Properties	139	(5)
Rehearsal Task 1	144	(4)
Tryout Task 2: Create a Shared Workbook; Track, Accept, and Reject Changes in Workbooks; Merge Workbooks	148	(6)
Rehearsal Task 2	154	(2)
Performance	156	(2)
Encore	158
PERFORMING WITH ACCESS
Tables and Lists
Tryout Task 1: Use Database Objects; Use Data Types; Create Input Masks Using a Wizard; Create Input Masks Without Using a Wizard; Modify Input Masks; Use Data Validation; Use Validation Text; Enter Data in Fields with Input Masks and Validation Rules	3	(11)
Rehearsal Task 1	14	(2)
Tryout Task 2: Create Lookup Fields; Link Tables Between Access Databases; Establish Relationships	16	(12)
Rehearsal Task 2	28	(2)
Performance	30	(3)
Encore	33	(4)
Lesson 8 Forms
Tryout Task l: Use Form Design View; Modify Forms in Design View; Create Forms with Associated Subforms	37	(10)
Rehearsal Task 1	47	(3)
Tryout Task 2: Create a Macro; Run a Macro; Edit a Macro; Change Actions in a Macro; Add a Macro Button to a Form; Create Database Switchboards; Set Switchboard Defaults; Set and Modify Startup Options; Create an AutoExec Macro; Create a Conditional Macro; Attach a Conditional Macro to a Form; Use the Macro Builder	50	(13)
Rehearsal Task 2	63	(3)
Performance	66	(2)
Encore	68	(3)
Lesson 9 Obtaining Information
Tryout Task 1: Specify Multiple Query Criteria; Create and Run Queries with And Conditions; Create and Run Queries with Or Conditions; Create and Run Parameter Queries; Optimize Queries Using the Indexed Property; Create and Run Action Queries	71	(9)
Rehearsal Task 1	80	(2)
Tryout Task 2: Use Aggregate Functions in Queries; Use the Expression Builder; Create Advanced Filters	82	(8)
Rehearsal Task 2	90	(2)
Performance	92	(2)
Encore	94	(3)
Lesson 10 Access Reports and Integration
Tryout Task 1: Use Report Design View, Use Report Sections; Create Reports in Design View; Use Bound Controls; Modify Reports in Design View; Format Controls	97	(9)
Rehearsal Task 1	106	(2)
Tryout Task 2: Use Unbound Controls; Add Page Numbers to a Report Section; Add Date and Time to a Report Section; Add Subreport Controls to Access Reports; View a Subreport; Sort and Group Data in Reports; Add Calculated Controls to a Report Section; Modify Controls; Modify a Report Created by the Report Wizard	108	(11)
Rehearsal Task 2	119	(3)
Tryout Task 3: Add a Chart to a Report Using the Chart Wizard; Add an Excel Chart to a Report; Export Data to Other Applications; Import Data from Other Applications; Link Data from Other Applications	122	(8)
Rehearsal Task 3	130	(2)
Performance	132	(3)
Encore	135	(3)
Lesson 11 Advanced Access Tools
Tryout Task 1: Compact and Repair a Database; Compact and Repair a Closed Database; Use the Analysis Tools; Use the Database Splitter; Replicate a Database	138	(15)
Rehearsal Task 1	153	(3)
Tryout Task 2: Set Database Encryption; Set Passwords for a Database; Set User-Level Security	156	(14)
Rehearsal Task 2	170	(2)
Performance	172	(3)
Encore	175	(3)
Lesson 12 Web and Object Integration
Tryout Task 1: Create a Hyperlink; Create a Data Access Page	178	(13)
Rehearsal Task 1	191	(3)
Tryout Task 2: Create Visual Basic Modules; Work with XML Documents; Work with MDE Files	194	(8)
Rehearsal Task 2	202	(2)
Performance	204	(2)
Encore	206
PERFORMING WITH POWERPOINT
Lesson 6 Informative Presentations
Tryout Task 1: Hide a Slide; Apply Decorative Bullets and Numbered Paragraphs; Replace Fonts; Create a Custom Background; Customize Toolbars	3	(7)
Rehearsal Task 1	10	(3)
Tryout Task 2: Use the Grid and Guides; Nudge Objects; Align or Distribute Objects; Scale, Position, and Format WordArt; Work with Clip Art Objects and Pictures	13	(8)
Rehearsal Task 2	21	(3)
Tryout Task 3: Work with Tables; Modify Charts and Diagrams	24	(10)
Rehearsal Task 3	34	(2)
Performance	36	(5)
Encore	41	(4)
PERFORMING WITH POWERPOINT
Lesson 7 Enhance a Presentation
Tryout Task 1: Create and Play a Macro; Create a Custom Show	45	(10)
Rehearsal Task 1	55	(3)
Tryout Task 2: Apply Custom Animations; Use Action Buttons	58	(15)
Rehearsal Task 2	73	(3)
Tryout Task 3: Record a Narration; Record a Sound or Voice Comment	76	(8)
Rehearsal Task 3	84	(3)
Performance	87	(6)
Encore	93	(4)
Lesson 8 Share a Presentation
Tryout Task 1: Use Meeting Minder; Conduct an Online Meeting	97	(8)
Rehearsal Task 1	105	(3)
Tryout Task 2: Create a Photo Album; Hold a Web Discussion; Add Password Protection; Add a Digital Signature	108	(9)
Rehearsal Task 2	117	(3)
Performance	120	(7)
Encore	127
PERFORMING WITH FRONTPAGE
Lesson 4 Marketing Web Sites
Tryout Task 1: Create and Customize Web Sites; Modify Web Page Layout; Create Subwebs; Set Permissions	3	(11)
Rehearsal Task 1	14	(2)
Tryout Task 2: Create and Modify the Navigational Structure of a Web Page	16	(6)
Rehearsal Task 2	22	(2)
Tryout Task 3: Create Tables	24	(4)
Rehearsal Task 3	28	(2)
Performance	30	(2)
Encore	32	(2)
Lesson 5 E-Commerce Web Sites
Tryout Task 1: Create Frames	34	(6)
Rehearsal Task 1	40	(2)
Tryout Task 2: Add FrontPage Components to Web Pages	42	(4)
Rehearsal Task 2	46	(2)
Tryout Task 3: Create Forms for User Input; Add Search Capabilities to Web Pages	48	(6)
Rehearsal Task 3	54	(2)
Tryout Task 4: Generate Reports	56	(4)
Rehearsal Task 4	60	(2)
Performance	62	(2)
Encore	64	(2)
Lesson 6 Integration
Tryout Task 1: Use Collaborative Features	66	(6)
Rehearsal Task 1	72	(2)
Tryout Task 2: Publish Web Sites	74	(6)
Rehearsal Task 2	80	(2)
Tryout Task 3: Integrate Web Sites with Databases	82	(8)
Rehearsal Task 3	90	(3)
Performance	93	(2)
Encore	95
PERFORMING WITH OUTLOOK
Lesson 7 Managing Contacts, Tasks, and Journals
Tryout Task 1: About Outlook; Create a List of Tasks; Modify Task Details; Link Tasks to Contacts; Assign Tasks and Send Task Requests; Track Assigned Tasks Using Advanced Options; Send Task Information to Other Users; View Tasks Assigned to Other Users	3	(7)
Rehearsal Task 1	10	(2)
Tryout Task 2: Create Journal Entries; Modify Journal Entries; Assign Contacts to Journal Entries; Assign Categories to Journal Entries; Record Automatically in Journal	12	(6)
Rehearsal Task 2	18	(2)
Performance	20	(2)
Encore	22	(3)
Lesson 8 Customizing, Organizing, and Sharing Outlook Information
Tryout Task 1: Customize Outlook Today; Specify Start-up Settings; Set Word as E-mail Editor; Specify Mail Options; Modify Message Formats; Filter Messages; Organize Messages; Flag Messages for Follow-up	25	(10)
Rehearsal Task 1	35	(3)
Tryout Task 2: Create and Use Outlook Data File Folders; View Outlook Data File Management; Import and Export Information with Outlook; Work with Remote Mail and Online Folders	38	(6)
Rehearsal Task 2	44	(2)
Performance	46	(1)
Encore	47
FINAL PERFORMANCE
Prepare A Marketing Campaign Project Scenario	2	(2)
Phase I: Organize and Record Project Tasks	4	(1)
Phase II: Develop a Newsletter Template and Create - a Newsletter	5	(2)
Phase III: Create a Flyer	7	(1)
Phase IV: Create a Brochure	8	(1)
Phase V: Develop a Web Site	9	(2)
Phase VI: Create a Flyer and Web Page for Tour Packages	11	(1)
Phase VII: Analyze Customer Data and Create a Data File	12	(1)
Phase VIII: Create a Letter and Merge It with a Data File for a Promotional Mailing	13	(1)
Phase IX: Create a Presentation	14	(1)
Phase X: Summarize Consultant Hours for Billing	15
APPENDICES
Appendix A MOUS Correlation	2	(9)
Appendix B File Management	11	(6)
Appendix C Using the Mouse	17	(2)
Appendix D Toolbars, Menus, and Dialog Boxes	19	(6)
Appendix E Selection Techniques	25	(2)
Appendix E Portfolio Basics	27	(4)
Appendix G Proofreader's Marks	31	(2)
Appendix M Task Reference	33
Glossary	1