Recommended - Lesson 7 Overview This venture uses the skills you’ve obtained for Notice, Excel, PowerPoint, and Entry to prepare for a promotional match to introduce a brand unique line of fishing hooks to local retailer

Lesson 7 Overview

This venture uses the skills you’ve obtained for Notice, Excel, PowerPoint, and Entry to prepare for a promotional match to introduce a brand unique line of fishing hooks to local outlets. You’ll mediate the characteristic of company president for a exiguous fishing address company that’s factual getting started. For this venture, it be necessary to total the following steps:

Get a database of outlets for possible outlets that could simply raise your hooks.
Get a spreadsheet with statistics and a chart.
Total a mail merge letter interesting gross sales reps to a fishing lodge to take a gape at out your product.
Manufacture a presentation to present on the fishing lodge.

Lesson Objectives

Put collectively for a promotional match to introduce a brand unique product to local outlets

Put collectively for a Promotional Occasion to Introduce a Original Product to Native Retailers

Graded Challenge: Developed PC Functions

Your venture ought to be submitted as a Notice story (.docx, .doc)*. Your venture will be for my portion graded by your teacher and attributable to this fact will soak as much as a pair weeks to grade.

Make certain that each of your files accommodates the following files:

Your title
Your student ID number
The lesson number (584085)
Your electronic mail address

Imprint: Whenever you happen to’ve got more than 10 attachments, you’ll ought to gain your total files into a compressed folder. To accept this, apply these instructions in line with your working system:

Dwelling windows: Pick the files you need to compress, factual-click and opt Ship to after which Compressed (zipped) folder.
Mac: Pick the files you need to compress, alter-click and opt Compress.

To post your graded venture, apply these steps:

Rush to http://www.pennfoster.edu.
Log in to your student portal.
Click on on Take Exam subsequent to the lesson you’re working on.
Notice the instructions offered to total your exam.

Guarantee to preserve a backup reproduction of any files you post to the college!

Retailers Database

Notice the steps below to maintain the Retailers database.

Click on to fetch the files you are going to ought to total this graded venture.

Begin Entry and maintain a brand unique blank database named “Retailers.”
Establish the unique table “Retailers” after which present it in Fabricate ogle.
Edit the ID discipline to be “Retailer ID” and study that it’s files kind AutoNumber and that it has been selected as the principle key.
In Fabricate ogle, add the final fields and corresponding files sorts:

Discipline Establish	Info Form
Store Establish	Short Textual hiss material
Tackle	Short Textual hiss material
Metropolis	Short Textual hiss material
Explain	Short Textual hiss material
Zip	Short Textual hiss material

5. Place after which finish the Retailers table.

6. Get a brand unique table named “Gross sales Reps” and present it in Fabricate ogle.

7. Edit the ID discipline to be “Gross sales Salvage ID” and study that it’s files kind AutoNumber and that it has been selected as the principle key.

8. Add a discipline named “Retailer ID” after which opt the Lookup Wizard as the Info Form.

a. Use the Wizard to favor Retailers as the table for the Lookup discipline.

b. Click on Retailer ID as the discipline with the values to decide on out from.

c. Kind the values in Ascending give an explanation for.

d. Click on Conclude.

9. In Fabricate ogle, add the final Gross sales Reps fields and corresponding files sorts:

Discipline Establish	Info Form
First Establish	Short Textual hiss material
Final Establish	Short Textual hiss material
Job Title	Short Textual hiss material

10. Place and finish the Gross sales Reps table.

11. Get a Retailers originate that involves the following files:

Retailer ID
Store Establish
Tackle
Metropolis
Explain
Zip

12. The originate ought to gape reminiscent of the figure below.

13. Get a Gross sales Reps originate that involves the following files:

Gross sales Salvage ID
Retailer ID
First Establish
Final Establish
Job Title

14. The originate ought to gape reminiscent of the figure below.

15. Use the Retailers originate to populate the Retailers table with the guidelines listed below.

Retailers Records
Retailer ID	1
Store Establish	Fishing World
Tackle	160 Trout Circle
Metropolis	Any Town
Explain	PA
Zip	16754

Retailer ID	2
Store Establish	Every thing Bait Store
Tackle	1336 Ocean Parkway
Metropolis	Any Town
Explain	PA
Zip	16755

Retailer ID	3
Store Establish	Most most indispensable Carrying Items
Tackle	14998 Atlantic Ave.
Metropolis	Any Town
Explain	PA
Zip	16759

16. Use the Gross sales Reps originate to populate the Gross sales Reps table with the guidelines listed below. Imprint that the Retailer ID is a look up discipline and also you’ll be ready to favor the notice from a list.

Gross sales Reps Records

Gross sales Salvage ID	1
Retailer ID	2
First Establish	Marty
Final Establish	Hu
Job Title	Owner

Gross sales Salvage ID	2
Retailer ID	1
First Establish	Chris
Final Establish	Tryniski
Job Title	Fishing Dept. Salvage

Gross sales Salvage ID	3
Retailer ID	1
First Establish	Karm
Final Establish	Howard
Job Title	Begin air Items Supervisor

Gross sales Salvage ID	4
Retailer ID	3
First Establish	Liz
Final Establish	Bennett
Job Title	Tackle Gross sales Salvage

Gross sales Salvage ID	5
Retailer ID	3
First Establish	Turner
Final Establish	Ward
Job Title	Store Supervisor

17. Structure Table Datasheet ogle for the Retailers and Gross sales Reps table, adjusting column widths as appropriate.

18. Get a query in Fabricate ogle that displays total contact files in alphabetical give an explanation for by store title. The tables ought to already present a relationship on anecdote of the Lookup discipline. If no longer, be half of the tables accurately to trot the query because it’ll be.

19. Bustle the query and establish apart it apart as “Contacts.”

20. Shut the query and any originate tables and sorts.

21. Shut the Retailers database.

Hook Outcomes Spreadsheet

Notice the steps below to maintain the Hook Outcomes spreadsheet.

Begin Excel and maintain a brand unique blank workbook.
Enter the following files:

a. Table Trout Hooks

b. Fish Caught

c. Match Table Leading Trace #1 Leading Trace #2 Leading Trace #3 % Caught with Table

d. Native Trout Match 185 126 90 130

e. Tri-Explain Annual Derby 568 445 229 330

Structure the workbook as follows (proven in the figure below):

a. Merge and center the titles. “Table Trout Hooks” is the total title, and “Fish Caught” is the heading for the Table and Leading Trace columns.

b. Structure cell titles and labels as daring.

c. Imprint borders across the total cells with files.

d. Substitute the spreadsheet orientation to landscape to permit the massive columns to be printed on one sheet of paper.

4. In column F, enter formula that employ a characteristic to calculate % Caught with Table (fish caught with Table hook divided by the total different of fish caught).

5. Structure the % Caught with Table values as a p.c with one decimal build.

6. Insert a Column Chart of kind 2-D Clustered Column that charts files in cells A4 thru E6.

7. Substitute the title to “Fish Caught by Hook Trace.”

8. Substitute the Chart Sort to Sort 11, in shriek that your chart looks reminiscent of the figure.

9. Guarantee the chart is sized accurately and positioned under the guidelines.

10. Place the workbook, naming it “Hook Outcomes.”

Invitation Letter

Notice the steps below to maintain the Invitation Letter.

Begin Notice and maintain a brand unique single-spaced (blank) story.
Form “Table Trout Hooks” after which press Enter.
Insert an on-line image of a trout (employ “trout” as the hunt textual hiss material) after which press Enter.
Now not vital: It’s possible you’ll take away the background coloration of your image, if wished, by following these steps:

a. Pick the image.

b. On the Characterize Instruments Structure tab, click Coloration > Place Transparent Coloration.

c. Click on on the background coloration of the selected object.

Size the image accurately after which center align the paragraph containing the image.
Structure the Table Trout Hooks textual hiss material as Georgia 22-point. Your letter ought to gape reminiscent of the figure.

7. Begin the mail merge job.

8. Can have to you opt recipients, employ an existing list, opt the Retailers.accdb database you created earlier, after which opt the Contacts query.

9. Form the textual hiss material proven below, inserting merge fields and leaving a blank paragraph the build indicated. You’ll ought to Match Fields at the same time as you insert the AddressBlock discipline code in shriek that that you just can well perhaps match the Firm to the Store Establish discipline.

March 30, 20xx

Are you as excited as I am about the outlet day of Trout Season? In preparation for the Grand Day, I invite you to affix me on the Native Fishing Lodge for a morning of fishing followed by a catered lunch on April 8, 20xx at 7:30 am. You’d accept to journey firsthand the adaptation a Table trout hook makes.

As <> at <>, I know you need to invent the most convenient fishing address on hand to your clients. Table trout hooks hook more trout. Fair gape on the results from two recent tournaments:

Please RSVP by emailing me at pres@tabletrouthooks.com and let me know in the occasion you need to raise a customer. Anticipating for my portion assembly with you.

Tight lines,

Your title right here

President

10. Your letter ought to gape like the figure below.

11. Make certain that you just’ve formatted the date and Table trout hooks title as daring and faded your title in the closing. If the email address isn’t automatically formatted as a hyperlink, then click Insert > Hyperlink to format it.

12. Within the 2nd blank paragraph after “. . . two recent tournaments:” paste a reproduction of the chart from the Hook Outcomes spreadsheet. Size the chart accurately, in shriek that it looks reminiscent of the figure.

13. Place the story, naming it “Lodge Lunch.”

14. Use the actual pronounce to merge the discipline files and maintain a story containing the person letters.

15. Scroll thru the letters and take a look at that the hiss material requires most efficient one web page. If the chart is so mammoth that your letter requires two pages, then finish the merged story without saving it and resize the chart in the Lodge Lunch story sooner than performing the merge again. Repeat this job until you kind letters that can print on one web page each.

16. Place the merged story, naming it “Merged Lodge Letter.”

Occasion Presentation

Notice the steps below to maintain the Occasion Presentation.

Begin PowerPoint and maintain a brand unique blank presentation.
Substitute the Theme of the presentation to Wood Form or one more appropriate vogue in the occasion you don’t have Wood Form.
Check lumber 1 is in Title Slither format after which enter the following textual hiss material:
- Title: Table Trout Hooks
- Subtext: Bring dwelling dinner!

4. Your lumber ought to gape reminiscent of the figure below.

5. Add a brand unique lumber with a Stutter with Caption format (lumber 2) after which insert the Table Hook.jpg image, the guidelines file you downloaded for this graded venture. Add the following textual hiss material and measurement the image in shriek that lumber 2 looks reminiscent of the figure.

Title: The Table Trout Hook
The patented originate of the Table trout hook combines sharpness, potential to penetrate, and energy to present a high rate product for inserting dinner on the table.

6. Add a brand unique lumber with a Title and Stutter format (lumber 3) and add the following textual hiss material.

Title: Table Trout Hook Fabricate
The double feature has been tournament tested with overwhelmingly certain response.
Pro and weekend fishers alike will gape immediate results with the double hook and curved shank.
The hook is fabricated from carbon metal for energy and a shaded nickel accept for sturdiness.

7. Structure the title and textual hiss material (as a bullet list) as proven in the figure.

8. Add a brand unique lumber with a Title and Stutter format (lumber 4) and add textual hiss material as follows:

Title: Establish Recognition
Hook-a-Allow promotion gave a Table hook to the principle 250 in-individual Trout allow purchases.
Native Trout Match sponsor with every angler receiving a free Table hook.
Tri-Explain Annual Trout Derby sponsor is offering more than 2,000 Table hooks.

9. Add a brand unique lumber with a Title and Stutter format (lumber 5). Use the identical textual hiss material as Slither 1 for the title, nonetheless blended. Edit the title and paste the chart from the Hook Outcomes spreadsheet in shriek that the lumber looks reminiscent of the figure below.

10. Add a brand unique lumber with a Title and Stutter format (lumber 6) and add hiss material as follows. Consult with the Hook Outcomes spreadsheet to accept the figure for the principle bullet.

Title: Conclusion
35% of tournament trout were caught with Table hooks
Competitive wholesale prices
Customer toughen and pleasure assured
Free setup of in-store displays
Plan your give an explanation for this day and accept a free initiating low cost

11. Insert a image of the identical trout (if that that you just can well perhaps imagine) faded in the Lodge Letter. The lumber ought to gape reminiscent of the figure.

12. Apply the Wind transition to the total slides.

13. Apply the Wipe animation to every of the bullet items on slides 3, 4, and 6.

14. Place the presentation, naming it “Gross sales Presentation,” after which play the lumber repeat from the initiating to study your work.

Scoring Pointers

Rubric

SKILL/GRADING CRITERIA	EXEMPLARY (4)	PROFICIENT (3)	FAIR (2)	POOR (1)	NOT EVIDENT (0)
Get a database	Handsome discipline names and discipline sorts were faded to maintain a table and originate.	Largely factual discipline names and discipline sorts were faded to maintain a table and originate.	Some factual discipline names and discipline sorts were faded to maintain a table and originate.	An strive has been made to maintain a table and originate.	No strive has been made to maintain a database with a table and originate.
Populate a database	All of the guidelines have been entered with no errors.	A lot of the guidelines were entered with no errors.	Some files were entered and there are errors.	There are a pair of files nonetheless they are able to simply no longer have the factual files.	No strive has been made to populate the database.
Get a database query	The query criteria encompass factual fields and kind, and the tables have an outlined relationship.	The query criteria encompass largely factual fields and kind, and the tables have an outlined relationship.	The query criteria encompass some fields with out a form, and the tables have an outlined relationship.	A query has been created with most efficient one table.	No strive has been made to maintain the query.
Get a spreadsheet	A spreadsheet with factual files, formatting, and formula has been created.	A spreadsheet with largely factual files, formatting, and formula has been created.	A spreadsheet with some factual files, formatting, and formula has been created.	A spreadsheet with formula that don’t employ functions has been created.	No are attempting to maintain a spreadsheet has been made.
Get a chart	A column chart of the factual kind and elegance with the actual title has been created.	A column chart of the factual kind with the actual title has been created.	A column chart with the actual title has been created.	A chart of any kind has been created.	No strive has been made to maintain a chart.
Form story textual hiss material	The specified letter has been typed because it’ll be with factual spacing, formatting, and on-line image.	The specified letter has been typed with few errors.	The specified letter has been typed with many errors and doesn’t have lots of the desired formats.	The specified letter has been typed with varied errors, wrong spacing, and lacks an image.	No are attempting to kind the letter has been made.
Insert merge fields	The letter accommodates the total factual merge fields in the factual positions.	The letter accommodates lots of the factual merge fields in the factual positions.	The letter doesn’t have an AddressBlock merge discipline and various merge fields are missing.	The letter accommodates textual hiss material rather then the merge fields.	No strive has been made to position merge fields or typed placeholders on the designated positions.
Merge discipline letters	Database merge fields were merged to maintain a story with individual letters.	Database merge fields are being previewed in the letter.	N/A	N/A	No strive has been made to merge fields and maintain a story containing individual letters.
Get a presentation	A presentation in the specified theme with six slides in the factual layouts has been created.	A presentation in the specified theme with lots of the slides in the factual layouts has been created.	A presentation in the specified theme with a pair of of the slides in the factual layouts has been created.	A presentation with fewer than six slides in varying layouts has been created.	No strive has been made to maintain a presentation.
Insert an image from the computer	A knowledge file image has been inserted, sized, and positioned.	A knowledge file image has been inserted and sized, nonetheless without optimal positioning.	A knowledge file image has been inserted without sizing or positioning.	A image assorted than that specified has been inserted.	No are attempting to insert an image has been made.
Paste an Excel chart	The specified Excel chart has been pasted into lumber 5 and accurately sized and positioned.	The specified Excel chart has been pasted into lumber 5 nonetheless no longer sized or positioned.	The specified Excel chart has been recreated in the presentation by using the Insert Chart divulge.	The chart has been inserted as an Excel Worksheet Object and displays your total worksheet.	No strive has been made so as to add a chart to the presentation.
Insert an on-line image	A suitable clip art work image has been inserted on lumber 6 and accurately sized and positioned.	A suitable clip art work image has been inserted on lumber 6 nonetheless could simply no longer be sized or positioned.	N/A	A image unrelated to the topic has been inserted.	No strive has been made to insert a clip art work image.
Apply a Transition	The Wind transition has been utilized to all slides.	The Wind transition has been utilized to multiple lumber.	The Wind transition has been utilized to most efficient one lumber.	The depraved transition has been utilized to the presentation.	No strive has been made to prepare a transition to any of the slides.
Apply Animations	The Wipe animation has been utilized to every bullet item individually on slides 3, 4, and 6.	The Wipe animation has been utilized to the total bullet items collectively on slides 3, 4, and 6.	A definite animation has been utilized to every bullet item individually on no longer no longer as much as one lumber.	A definite animation has been utilized to the total bullet items collectively on no longer no longer as much as one lumber.	No strive has been made to prepare an animation.

Submission Checklist

Earlier than submitting your graded venture, ensure you’ve accomplished the total required initiatives.

Get a database with multiple tables and a Lookup discipline table.
Get sorts reminiscent of database tables.
Populate a database table by using sorts.
Get a query in line with 2 connected tables.
Specify a form in a database opt query.
Get a spreadsheet and prepare formatting, at the side of merge and center, to cells.
Use a characteristic in a components to calculate a notice.
Get a Column chart of kind 2-D Clustered Column.
Edit a chart title.
Substitute a chart vogue.
Form and format textual hiss material in a Notice story.
Insert, measurement, and situation an on-line clip art work image.
Get a mail merge story using an existing database query as an files source.
Insert merge fields, at the side of an AddressBlock, in a Notice letter.
Match fields in an AddressBlock merge discipline.
Paste an Excel chart in a Notice story.
Merge discipline files with precise files to maintain individual letters.
Get a PowerPoint presentation.
Apply a theme to a presentation.
Insert an existing image into a lumber after which measurement and situation it.
Paste an Excel chart into a lumber.
Consult with a spreadsheet for hiss material so as to add to a lumber.
Insert an on-line clip art work image into a lumber after which measurement and situation it.
Apply a transition.
Apply animations individually to bullet items on a lumber.

Graded Assignment: Developed PC Functions Graded Challenge

Listen

Instructions

Make certain that each of your files accommodates the following files:

Your title
Your student ID number
The lesson number (584085)
Your electronic mail address

Imprint: Whenever you happen to’ve got more than 10 attachments, you’ll ought to gain your total files into a compressed folder. To accept this, apply these instructions in line with your working system:

Dwelling windows: Pick the files you need to compress, factual-click and opt Ship to after which Compressed (zipped) folder.
Mac: Pick the files you need to compress, alter-click and opt Compress.

Guarantee to preserve a backup reproduction of any files you post to the college!

260301PAQP_584127 7/2/2026 Thank you on your recent venture submission. Then again, it appears to be like there are required key aspects of the venture that are no longer factual or missing. Your venture is per chance no longer graded at the present and an RTN will be posted to your file. (What does RTN point out? Can have to you upload your work an RCD is posted alerting us that you just have submitted files. An RCD prevents you from importing any assorted files for that express venture until your work has been reviewed. An RTN methodology that your work became as soon as reviewed and the venture has been returned rather then graded. RTN is no longer a penalty of any kind. Most seriously, an RTN enables the system to settle on your corrected work.) Please accept no longer be depressed and think that we’re going to post a failing grade on your venture. You accept ought to factual your work and resubmit it as if it were the principle strive. Most students accept no longer basically successfully total the venture on the principle strive. It’s a necessity that you just designate the splendid system to because it’ll be employ the tool and the vital skills in this venture in give an explanation for to be worthwhile in your future endeavors. Whenever you happen to’ve got any questions, please reach out to us thru cell phone at 1-888-427-1000 or send us an electronic mail thru the Assist & Fortify piece of your Pupil Portal. An appointment to talk about to an teacher can also be scheduled at https://pennfoster.libcal.com/appointments/college?g=6758. Here are these areas it is top to present a boost to upon: ⮚On the factual video display! Lacking the Retailers database file which ought to be an Entry database. Also, take a look at the principle line of the 2nd paragraph in Lodge Lunch for Job Title and Store Establish. Inspect the examples below. Please assessment the venture instructions to ogle which files needs to be submitted and post the total files on the identical time for grading. Contact our build of enterprise for assistance. ⮚One of the files required for this venture is t

WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
Assignment status: Already Solved By Our Experts
(USA, AUS, UK & CA PhD. Writers)
CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS

QUALITY: 100% ORIGINAL PAPER – NO ChatGPT.NO PLAGIARISM – CUSTOM PAPER

Looking for unparalleled custom paper writing services? Our team of experienced professionals at AcademicWritersBay.com is here to provide you with top-notch assistance that caters to your unique needs.

We understand the importance of producing original, high-quality papers that reflect your personal voice and meet the rigorous standards of academia. That’s why we assure you that our work is completely plagiarism-free—we craft bespoke solutions tailored exclusively for you.

Why Choose AcademicWritersBay.com?

Our papers are 100% original, custom-written from scratch.
We’re here to support you around the clock, any day of the year.
You’ll find our prices competitive and reasonable.
We handle papers across all subjects, regardless of urgency or difficulty.
Need a paper urgently? We can deliver within 6 hours!
Relax with our on-time delivery commitment.
We offer money-back and privacy guarantees to ensure your satisfaction and confidentiality.
Benefit from unlimited amendments upon request to get the paper you envisioned.
We pledge our dedication to meeting your expectations and achieving the grade you deserve.

Our Process: Getting started with us is as simple as can be. Here’s how to do it:

Click on the “Place Your Order” tab at the top or the “Order Now” button at the bottom. You’ll be directed to our order form.
Provide the specifics of your paper in the “PAPER DETAILS” section.
Select your academic level, the deadline, and the required number of pages.
Click on “CREATE ACCOUNT & SIGN IN” to provide your registration details, then “PROCEED TO CHECKOUT.”
Follow the simple payment instructions and soon, our writers will be hard at work on your paper.

AcademicWritersBay.com is dedicated to expediting the writing process without compromising on quality. Our roster of writers boasts individuals with advanced degrees—Masters and PhDs—in a myriad of disciplines, ensuring that no matter the complexity or field of your assignment, we have the expertise to tackle it with finesse. Our quick turnover doesn’t mean rushed work; it means efficiency and priority handling, ensuring your deadlines are met with the excellence your academics demand.

ORDER NOW and experience the difference with AcademicWritersBay.com, where excellence meets timely delivery.