Access

1 Start Access. Open the downloaded file named a01ch02_grader_pc_Putts.accdb. Save the file with the name a01ch02_grader_pc_Putts_LastFirst, using your last and first name. If necessary, enable the content. 2 Open the downloaded Excel file, a01ch02_grader_pc_PuttsGolf, copy the contents of cells A1:I9 and paste the contents into the tblParticipant table as new records. Close Excel and close tblParticipant. 3 Import the records on the Corporate contacts worksheet from the downloaded Excel file, a01ch02_grader_pc_PuttsCont, into the tblPartcipant table. 4 Import the records in the Volunteers named range from the downloaded Excel file, a01ch02_grader_pc_PuttsVol, into the tblParticipant table.
yo16_ac_ch04_grader_ps1_hw_instructions.docx

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on
Access
Just from $13/Page
Order Essay

Office 2016 – myitlab:grader – Instructions
Your Office – Access Chapter 4: Homework Project 1
YO16_AC_CH04_GRADER_PS1_HW – Clothing Sales
Project Description:
Wanda Robinson runs a home business selling designer clothing and has started using an Access database to
keep her records. The database has been created and is now able to retain data. Wanda wants to have some
forms and reports created to make dealing with the data easier. She has hired you to develop the necessary
forms and reports.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Points
Possible
Instructions
1
Start Access. Open the downloaded file named a02ch04_grader_h1. Save the file with the
name a02ch04_grader_h1_LastFirst, replacing LastFirst with your name. In the Security
Warning bar, click Enable Content.
0
2
Open tblCustomer. Add a new record with CustomerID 16, FirstName Access, LastName
Student, Address 101 Main Street, City Santa Fe, State NM, and ZipCode 87594.
5
3
Create a split form to show all the product information from tblProduct. Save the form as
frmProductInfo_aStudent. Apply the Ion theme to all objects in the database. Add
Created by a Student to the Form Footer. Save and close the form.
10
4
Use the Form Wizard to create a form that will display the customer’s LastName and
FirstName in the main form, and ProductDescription, Price, Size, and Color in a subform.
Accept all default options. Name the form frmCustOrders_aStudent and the subform
frmProductSubform_aStudent.
10
5
Remove the subform label. Move the subform to line up with the First Name label. Autofit the
columns in the subform. Resize the subform to fit the columns. Change the title of the form to
Customer Orders. Add Created by a Student to the main form Form Footer. Save and
close the form.
10
6
Use the Report Wizard to create a report to summarize each customer’s purchases. Include
LastName, FirstName, ProductDescription, Price, and Quantity (in that order.) (Hint: this
information will come from three different tables). Accept the grouping options, sort ascending
by ProductDescription, use a format of Stepped and Landscape, and save the report as
rptCustSummary_aStudent.
10
7
Add the sum of the quantities for each customer. Add a caption Total Products.
8
8
Apply conditional formatting to make any sum of quantities greater than 3 bold and red.
10
9
Add Created by a Student to the report footer. Change the title of the report to Customer
Summary. Save and close the report.
7
Updated: 04/05/2016
1
YO16_AC_CH04_GRADER_PS1_HW_Instructions.docx
Office 2016 – myitlab:grader – Instructions
Step
Your Office – Access Chapter 4: Homework Project 1
Points
Possible
Instructions
10
Use the Report Wizard to create a report that includes all product fields except ProductID.
Group products by Category and then Price, sort by ProductDescription and then Size. Use
Summary Options in the wizard to show the sum of QuantityInStock. Change the orientation
to Landscape. Name the report rptPriceCategories_aStudent.
10
11
Click on the Product Description text box. In the Property Sheet, on the Format tab, change
the Width to 1.5″. Move the Size label and Size text box to the left next to Product Description
(the Left property should be 6.8333″). Move the Quantity in Stock label, text box, subtotals,
and grand totals to left next to Size (the Left property should be 7.1667″). Move the Color
label and text box to the left next to Quantity in Stock (the Left property should be 8.875″).
Click on the Color label and Color text box to select them. In the Property Sheet, on the
Format tab, change the Width to 1.5″.
10
12
Add Created by a Student to the report footer below the Grand Total. Change the title of
the report to Products by Category and Price. Save and close the report.
10
13
Close all database objects. Close the database and exit Access. Submit the database as
directed.
0
Total Points
Updated: 04/05/2016
2
100
YO16_AC_CH04_GRADER_PS1_HW_Instructions.docx

Purchase answer to see full
attachment

Order a unique copy of this paper
(550 words)

Approximate price: $22

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

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your essay today and save 15% with the discount code DISCOUNT15