Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please explain and show me how to do this on Access. Thank you! I posted this question before, and the person who answered did not
Please explain and show me how to do this on Access. Thank you!
I posted this question before, and the person who answered did not answer the full question and did not answer it correctly, I have seen other questions like this get answered fully to completion and I really need help with this assignment, thank you.
^^^this is the items.xlsx worksheet
Step | Instructions | Point Value |
---|---|---|
1 | Start Access. Open the downloaded Access file named Exp19_Access_Ch4_ML2_Auction.accdb. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. | 0 |
2 | Open the Items table in Design view. Change the ID Field Name to ItemID. Add a second field named Description. Accept Short Text as the data type for the Description field and change the field size to 50. | 5 |
3 | Enter the remaining field names in the table (in this order): DateOfDonation, Category, Price, DonorName, DonorAddress1, and then DonorAddress2. Change the data type of the DateOfDonation field to Date/Time and the Price field to Currency. Accept Short Text as the data type for the remaining fields. | 10 |
4 | Open Excel, and then open the file Items.xlsx. Examine the length of the Category, DonorAddress1, and DonorAddress2 columns. Return to Access. Change the field size for the Category to 15, DonorAddress1 to 25, and DonorAddress2 to 30. Save the table, and switch to Datasheet view. | 9 |
5 | Copy and paste the 26 rows from the Excel spreadsheet into the Items table. AutoFit all of the column widths so all data is visible. Save and close the table. | 10 |
6 | Verify that the Items table is selected in the Navigation Pane. Create a new form using the Form tool. | 6 |
7 | Select all of the fields and labels in the Detail section of the form. Change the layout of the form to a Tabular Layout. With all of the fields selected, switch to Design view and use the Property Sheet to set their widths to 1.3". Change the width of the ItemID, Category, and Price columns to 0.75". | 10 |
8 | Add conditional formatting so that each Price that is greater than 90 has a font color of Green (in the first row, under Standard Colors). (Hint: Search Conditional Formatting in the Tell me box). Save the form as Auction Items Form. | 10 |
9 | Switch to Form view and create a new record. Enter iPad as the Description; 12/31/2018 as the DateOfDonation; House as the Category; $400 as the Price; Staples as the DonorName; 500 Market St as the DonorAddress1; and Brick, NJ 08723 as the DonorAddress2. | 10 |
10 | Add a sort to the form, so the lowest priced items display first. Save and close the form. | 5 |
11 | Select the Items table in the Navigation Pane and create a report using the Report Wizard. Include all fields except the two donor address fields, group by Category, include the Sum of Price as a Summary Option, accept the default layout, and then save the report Auction Items by Category. | 7 |
12 | Switch to Layout view. Resize the DateOfDonation control so that the left edge of the control aligns with the left edge of the column label. Select the Price and Sum of Price controls and increase the width to 0.75". Select any value in the DonorName column and drag the left edge of the controls to the right to decrease the width of the column. Preview the report to verify the column widths are correct. | 3 |
13 | Switch to Layout view, and then sort the report so the least expensive item is displayed first in each group. Save and close the report. | 5 |
14 | Select the Items table in the Navigation Pane. Create mailing labels based on the Avery 5660 template. (Hint: Search Labels in the Tell me box and then click the Labels tool in the results.) Place DonorName on the first line, DonorAddress1 on the second line, and DonorAddress2 on the third line. Sort the labels by DonorName. Name the report Donor Labels. After you create the labels, display them in Print Preview mode to verify that all values will fit onto the label template. Close the label report. | 10 |
15 | Close all database objects. Close the database and then exit Access. Submit the database as directed. | 0 |
. B D E F G H 1 2 3 4 5 6 7 ItemID Description 1 Cake 2 Picture 3 Men's Haircut 4 Set of knives 5 Dinner for two 6 Lawn service 7 Photo session 8 Gift card 9 Gift card 10 Gift card 11 Brownies 12 Garden tools 8 9 10 11 12 13 14 13 Plants Donation Date Category 11/1/16 Food 11/1/16 House 11/8/16 Service 11/10/16 House 11/10/16 Certificate 11/11/16 Service 11/11/16 Service 11/17/16 Certificate 11/17/16 Certificate 11/17/16 Certificate 11/20/16 Food 11/23/16 House 11/26/16 House 11/26/16 House 12/5/16 Service 12/16/16 Clothes 12/16/16 Clothes 12/16/16 House 12/19/16 House 12/21/16 Service 12/24/16 Service 12/24/16 Food 12/25/16 House 12/26/16 Certificate 12/27/16 Clothes 12/28/16 House Price Donor Name $20.00 Rabiah Hannah $10.50 Alfredo Ramirez $15.00 Jasmine Rangan $35.95 Takeshi Ito $64.50 Kyong Shin $100.00 Mouna Bishara $75.00 Gang Liu $100.00 Kiyoshi Sasaki $50.00 Kiyoshi Sasaki $ $25.00 Kiyoshi Sasaki $10.00 Akira Yamada $125.00 Toshio Sasaki $95.00 Hui Lin $54.50 Li Zhang $95.00 Dalia Abboud $100.00 Yasuo Tanaka $25.00 Kenji Yamamoto $13.50 Kwan Jeong $45.00 Soranlly Lopez $135.00 Yukio Ito $150.00 Kyu Shin $75.00 Dario Perez $44.00 Rajesh Bhatnagar $50.00 Target $99.00 Rajesh Bhatnagar $150.00 Loelia Hamade Donor Address 1 553 Madsen's Place 66 England Circle 887 Aurora Street 671 Homer Drive 829 Klevin Street 703 McGowan Street 926 Loon Circle 1159 Town Park Circle 1159 Town Park Circle 1159 Town Park Circle 816 Clipper Ship Drive 1083 Evergreen Street 821 East 23Rd Street 453 Sun Valley Drive 148 Cobblecreek Circle 659 Lindblad Avenue 522 Bridle Circle 167 Ramona Street 477 Nabesna Circle 89 Ostovia Circle 876 Canterbury Way 401 Sanak Circle 855 Tiffin Circle 1099 Venus Way 855 Tiffin Circle 35 Tree Top Lane Donor Address 2 Paulsboro, NJ 08066 Ventnor City, NJ 08406 Pomona, NJ 08240 Little Ferry, NJ 07643 Rockaway, NJ 07866 Helmetta, NJ 08828 Sussex, NJ 07461 Point Pleasant Beach, NJ 08742 Point Pleasant Beach, NJ 08742 Point Pleasant Beach, NJ 08742 Little Silver, NJ 07739 Middletown, NJ 07748 Princeton, NJ 08541 Dumont, NJ 07628 Cream Ridge, NJ 08514 Gloucester City, NJ 08030 Hibernia, NJ 07842 Trenton, NJ 08641 Allendale, NJ 07401 Glen Rock, NJ 07452 Ventnor City, NJ 08406 Mauricetown, NJ 08329 Glen Gardner, NJ 08826 Hampton, NJ 08827 Glen Gardner, NJ 08826 Totowa, NJ 07511 15 16 17 18 19 20 21 14 Flowers 15 Cleaning service 16 Clothes 17 Shoes 18 Umbrella 19 Blender 20 Carpet cleaning 21 Car detailing 22 Six steaks 23 Dishware 24 Target gift card 25 Designer coat 26 Used computer 22 23 24 25 26 27 File Home Create External Data Database Tools Help Fields Table of cut New Copy View Paste Filter 21 Ascending Y Selection Al Descending Advanced 2. Remove Sort Y Toggle Filter Sort & Filter Save Format Painter Refresh All - X Delete Views Clipboard Reco A... > Items . B D E F G H 1 2 3 4 5 6 7 ItemID Description 1 Cake 2 Picture 3 Men's Haircut 4 Set of knives 5 Dinner for two 6 Lawn service 7 Photo session 8 Gift card 9 Gift card 10 Gift card 11 Brownies 12 Garden tools 8 9 10 11 12 13 14 13 Plants Donation Date Category 11/1/16 Food 11/1/16 House 11/8/16 Service 11/10/16 House 11/10/16 Certificate 11/11/16 Service 11/11/16 Service 11/17/16 Certificate 11/17/16 Certificate 11/17/16 Certificate 11/20/16 Food 11/23/16 House 11/26/16 House 11/26/16 House 12/5/16 Service 12/16/16 Clothes 12/16/16 Clothes 12/16/16 House 12/19/16 House 12/21/16 Service 12/24/16 Service 12/24/16 Food 12/25/16 House 12/26/16 Certificate 12/27/16 Clothes 12/28/16 House Price Donor Name $20.00 Rabiah Hannah $10.50 Alfredo Ramirez $15.00 Jasmine Rangan $35.95 Takeshi Ito $64.50 Kyong Shin $100.00 Mouna Bishara $75.00 Gang Liu $100.00 Kiyoshi Sasaki $50.00 Kiyoshi Sasaki $ $25.00 Kiyoshi Sasaki $10.00 Akira Yamada $125.00 Toshio Sasaki $95.00 Hui Lin $54.50 Li Zhang $95.00 Dalia Abboud $100.00 Yasuo Tanaka $25.00 Kenji Yamamoto $13.50 Kwan Jeong $45.00 Soranlly Lopez $135.00 Yukio Ito $150.00 Kyu Shin $75.00 Dario Perez $44.00 Rajesh Bhatnagar $50.00 Target $99.00 Rajesh Bhatnagar $150.00 Loelia Hamade Donor Address 1 553 Madsen's Place 66 England Circle 887 Aurora Street 671 Homer Drive 829 Klevin Street 703 McGowan Street 926 Loon Circle 1159 Town Park Circle 1159 Town Park Circle 1159 Town Park Circle 816 Clipper Ship Drive 1083 Evergreen Street 821 East 23Rd Street 453 Sun Valley Drive 148 Cobblecreek Circle 659 Lindblad Avenue 522 Bridle Circle 167 Ramona Street 477 Nabesna Circle 89 Ostovia Circle 876 Canterbury Way 401 Sanak Circle 855 Tiffin Circle 1099 Venus Way 855 Tiffin Circle 35 Tree Top Lane Donor Address 2 Paulsboro, NJ 08066 Ventnor City, NJ 08406 Pomona, NJ 08240 Little Ferry, NJ 07643 Rockaway, NJ 07866 Helmetta, NJ 08828 Sussex, NJ 07461 Point Pleasant Beach, NJ 08742 Point Pleasant Beach, NJ 08742 Point Pleasant Beach, NJ 08742 Little Silver, NJ 07739 Middletown, NJ 07748 Princeton, NJ 08541 Dumont, NJ 07628 Cream Ridge, NJ 08514 Gloucester City, NJ 08030 Hibernia, NJ 07842 Trenton, NJ 08641 Allendale, NJ 07401 Glen Rock, NJ 07452 Ventnor City, NJ 08406 Mauricetown, NJ 08329 Glen Gardner, NJ 08826 Hampton, NJ 08827 Glen Gardner, NJ 08826 Totowa, NJ 07511 15 16 17 18 19 20 21 14 Flowers 15 Cleaning service 16 Clothes 17 Shoes 18 Umbrella 19 Blender 20 Carpet cleaning 21 Car detailing 22 Six steaks 23 Dishware 24 Target gift card 25 Designer coat 26 Used computer 22 23 24 25 26 27 File Home Create External Data Database Tools Help Fields Table of cut New Copy View Paste Filter 21 Ascending Y Selection Al Descending Advanced 2. Remove Sort Y Toggle Filter Sort & Filter Save Format Painter Refresh All - X Delete Views Clipboard Reco A... > Items
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started