Question: COMP 1 0 0 3 In Class Module 1 2 Actionzone Cricket Camp runs events for boys and girls in grades 1 through 5 .
COMP In Class Module
Actionzone Cricket Camp runs events for boys and girls in grades through You need to automate the registration process for this camp. Complete the following:
Download the file called Youth Cricket from eConestoga and save first on your desktop, and then backup to OneDrive.
In the Documentation worksheet, enter your name and todays date use a function to enter the date
In the Receipt worksheet, insert two rows above row
Create a WordArt using the Fill: Blue, accent color ; Shadow style.
Type Actionzone Cricket Academy.
Change the text fill of the WordArt to Blue, Accent Darker
Change the font size to and move the WordArt so it spans A:E
Still in the Receipt worksheet, define names as follows:
a Create defined names for B:B using the names found in A:A
b Change the defined name Address to StreetAddress.
c Use the Name box to create the defined name YouthInfo for the range D:E and the defined name TrainingTypeand Cost for the range A:B
In the Documentation worksheet, starting in B paste the list of defined names.
In the Receipt worksheet, in the range B:B create the data validation rules, input messages, and error alerts shown in the chart below.
Cells Settings Input Message Error Alert
B Registration Date must be Title: Registration Date
Message: Date must be within the calendar year Style: Stop
Title: Invalid Registration Date
Message: Date must be within the calendar year.
B List
Source range A:A Title: Training Type
Message: Click the arrow to select the training type Style: Stop
Title: Invalid Training Type
Message: Use the arrow to select the training type
B List
Source range D:D Title: Grade
Message: Click the arrow to select the Grade Style: Stop
Title: Invalid Grade
Message: Use the arrow to select the Grade
B List
Source range E:E Title: Shirt Size
Message: Click the arrow to select the Shirt Size Style: Stop
Title: Invalid Shirt Size
Message: Use the arrow to select the Shirt Size
B
List, Yes, No Title: Early Registration Style: Stop
Title: Invalid ER
Message: Use the arrow to select early reg.
In the range B:B enter information as follows:
Registration Date: Todays Date
Youth LN FN: Your last and first name
Training Type: Choose which training you would like
Grade: Enter a Grade for yourself
Shirt Size: Enter a Shirt Size
Guardian LN FN: Enter a fictitious last and first name
Street Address: Enter a fictitious address
City Province Postal Code Enter fictitious information
Telephone: Enter a fictitious telephone number
Early Registration Choose Yes
there is a $ discount for early registration
Enter the following formulas in the transfer area:
Cell A Guardian
Cell B Telephone
Cell C YouthName
Cell D Training
Cell E Grade
Cell F Shirtsize
Scroll down so you can see the receipt starting in Row Enter the following formulas in the specified cells using the defined names you created earlier:
o Cell E RegistrationDate Format as Short Date
o Cell B Guardian
o Cell B StreetAddress
o Cell B CityProvincePC
o Cell B Telephone
o Cell E YouthName
o Cell E Training
o Cell E Grade
o Cell E ShirtSize
In cell E insert a VLOOKUP based on E VLOOKUP table is in A:B After you have completed the VLOOKUP, add an IFERROR function that will show a blank cell if the receipt has not been completed.
In cell E insert an IF function to determine the amount of discount if any
In cell E calculate the total cost with a formula that subtracts the discount from the cost. Add an IFERROR function that will show a blank cell if the receipt has not been completed
Actionzone Cricket Camp runs events for boys and girls in grades through To finish automating the registration process for this camp, you will make two macros, one to print a PDF copy of the receipt, and the to her to add information to the Actionzone CC database.
Add the Developer tab to the ribbon if its not already there.
Save your workbook as macroenabled.
Make sure your active sheet is the Receipt worksheet.
Create a macro named TransferData with CtrlT as the shortcut key. Store the macro in the current workbook. Record the following steps to create the PrintReceipt macro:
a Go to the Registration Data sheet.
b Click in cell A and insert a new row.
c Copy the Transfer Area on the Receipt sheet.
d Paste values into the new row.
e Return to the Receipt worksheet.
f Clear Contents from cells B:B
g Click in cell B
h STOP RECORDING
On the Receipt page, create a Form Control macro button in H:I to connect to the TransferData macro. Put the words Transfer Data on the button, and the
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help