All instructions and files are attached below. Just follow the instructions along with the filesthe

  

All instructions and files are attached below. Just follow the instructions along with the filesthe access file can not be uploaded so here is the link to ithttps://www108.zippyshare.com/v/B9MrQv81/file.html
vba01_exam_chap_orderform.xlsm

vba01_exam_chap_scorecard.xlsx

Don't use plagiarized sources. Get Your Custom Essay on
All instructions and files are attached below. Just follow the instructions along with the filesthe
Just from $13/Page
Order Essay

exploring2016_vba1_pe_instructions__1_.pdf

Unformatted Attachment Preview

South Lincoln Hockey Fundraiser
Player Name:
Player Address:
Player City:
Player State:
Player Zipcode:
QTY
Order Due Date:
Order Delivery Date:
SIZE
CUSTOMER NAME
UNIT PRICE
LINE TOTAL
$

$

$

$

$

$

$

$

$

$

$

$

$

TOTAL
Make all checks payable to South Lincoln Youth Hockey
Save Form
Exit Form
Scorecard
vba01_exam_chap_scorecard
Hockey Fundraiser
Name
Step
a
b-e
f-h
i
j-k
l
m-o
p-q
r
s-t
u
v
w-y
z
Description
Save the file as vba01_exam_Orderform_LastFirst
Perform debugging and fix code to ActiveWorkbook.Save
Add code to close the workbook On Click
Enter data provided for QTY, SIZE, CUSTOMER NAME, and UNIT PRICE
Save Form button correctly saves the form and Exit Form button correctly
closes the form
Save the file as vba01_exam_Orders_LastFirst
Create a user input box with text Enter Order ID
Create a query that returns the record entered by the user
Find Order button locates correct order.
Declare the constant sngFree as a Single set to 100
Declare the variables sngTotal as a Single and strEligible as a String.
Use If Then Else statement to determine eligibility
Create a message box that displays player’s eligibility and the Total Due
formatted as Currency
Score:
Point
Value
5
5
5
5
Free Camp button gives the correct Eligible and Not Eligible messages
Copyright © 2017 Pearson Education, Inc.
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
5
5
10
10
5
5
5
20
10
5
100
100
Points
Deducted
0
Copyright © 2011 Pearson Education, Inc. Publishing as Prentice Hall
Prepared Exam
Exploring Microsoft Visual Basic for Applications, Chapter 1
Hockey Fundraiser
You have been asked to help with your child’s fundraiser for the local youth hockey
association. One of the other parents started creating the order form and associated
database. The database is used to track orders and determine if players are eligible for
free registration in the fall. You will need to fix the existing order form and make some
enhancements to both the order form and database to meet the goals for each.
Debug and Fix Procedure
Users are receiving an error when trying to use the Save Form button on the existing
order form. You will need to determine the cause of the issue and correct it.
a. Open the file vba01_exam_chap_orderform and save it as
vba01_exam_Orderform_LastFirst.
b. Click on the Save Form button to reproduce the error.
c. Locate the source of the error and make the necessary change (hint: you can get
suggested code by deleting the existing line and typing ActiveWorkbook.S).
d. Save the workbook.
e. Run the procedure to verify there are no longer any issues.
Create a New Procedure
You need to create a new procedure that will close the form when a user clicks on the
Close button.
f. Open the VB Editor and locate the procedure btnExit_Click().
g. Allow users to close the form by adding the following line of code:
h. Save the changes and exit the VB Editor.
Copyright © 2017 Pearson Education, Inc.
i. Enter the following data in Row 10:

QTY = 2

SIZE = XL

CUSTOMER NAME = Mary Lincoln

UNIT PRICE = 10
j. Click the updated Save Form button to save the workbook.
k. Click the Exit Form button to close the workbook.
Create Search
Users will need to be able to search for an order based on the Order ID they are
provided. You will need to allow a user to enter an Order ID when they click on the Find
Record button. The database will then return the record associated to that Order ID.
l. Open the file vba01_exam_chap_orders and save it as
vba01_exam_Orders_LastFirst.
m. Open the frmOrderStatus in Design View.
n. Select the Find Order button and add a new event that is triggered for the On
Click event.
o. Create a user input box by adding the following lines of code:
p. Create a query that returns the record the user entered by adding the following
lines of code:
q. Save and close the VB editor.
r. Test the button using Order ID 12.
Copyright © 2017 Pearson Education, Inc.
Determine Player Eligibility
A player will receive free camp registration in the fall if they generate over $100 in sales.
You will need to allow a user to click a button that will quickly determine if a player is
eligible for the free registration. The message should also quickly display how much
money the player generated if there are any questions.
s. In design mode select the Free Camp button and add a new event that is
triggered for the On Click event.
t. Declare a constant sngFree as a Single set to 100.
u. Create variables sngTotal as a Single and strElibible as a String under the
constant in the declaration statement that will be used to determine if the player
is eligible by adding the following lines of code:
v. Use logical operators to determine if the player is eligible for a free camp by
adding the following lines of code:
w. Create a message box that displays the total the player generated and if they are
eligible for free camp by adding the following lines of code:
x. Format the TotalDue to be displayed as currency by altering the following line of
code:
Copyright © 2017 Pearson Education, Inc.
y. Save and close the VB editor.
z. Test the button and close the form.
aa. Exit Access and Excel and based on your instructor’s directions submit the files
vba01_exam_Orderform_LastFirst and vba01_exam_Orders_LastFirst.
Copyright © 2017 Pearson Education, Inc.

Purchase answer to see full
attachment

  
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more