Transcript Slide 1
Integrated Business Projects
Part 4 Capstone Project Project 19 Preparing Materials for Bridge Day Press Esc to Exit
©2011 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
Project 19 Objectives
• • • • • •
Create a newsletter with columns, breaks, a table, hyperlinks, and media Create a Word document with form and ActiveX controls and hyperlinks Create a presentation with hyperlinks to motion clips and documents Import and export data among Applications Summarize financial data Create a flyer for a music concert
2
Press Esc to Exit
©2011 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
Project 19 Jobs
Job 19-1: Design and Prepare Newslette
Job 19-2: Create Application Form and Presentation for Rafting Competition
Job 19-3: Create Gauley Challenge Database
Job 19-4: Analyze Income and Expenses
Job 19-5: Create Concert Flyer
r Press Esc to Exit
©2011 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
3
Project 19-1: Design and Prepare Newsletter
• • • •
Creating a two-column document Inserting page, section, and column breaks Creating hyperlinks Inserting tables and media in a document
Press Esc to Exit
©2011 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
4
Bridge Day Sample Newsletter
Press Esc to Exit
©2011 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
5
Project 19-2 Create Application Form and Presentation for Rafting Competition
• • •
Creating an application form Creating a presentation Integrating word processing, spreadsheet, and slideshow files Press Esc to Exit
©2011 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
6
Sample Application Form
Press Esc to Exit
©2011 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
7
Project 19-3: Create Gauley Challenge Database
• • •
Importing and exporting data Integrating Access, Excel, and Word Creating an Access table, form, query, and report Press Esc to Exit
©2011 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
8
Gauley River Rapids Challenge
Teams Sample Report
Press Esc to Exit
©2011 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
9
Job 19-4: Analyze Income and Expenses
• •
Summarizing income and expense data Filtering and sorting records
Press Esc to Exit
©2011 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
10
Job 19-5: Create Concert Flyer
END SHOW
•
Designing and creating a promotional flyer Press Esc to Exit
©2011 Cengage Learning. All Rights Reserved. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole or in part.
11