CTEC226 Module 1 Garden Naturally Database Lab Microsoft Excel Paper Please follow the instructions on the rubric to do the assignment Customer Number AA30

CTEC226 Module 1 Garden Naturally Database Lab Microsoft Excel Paper Please follow the instructions on the rubric to do the assignment Customer
Number
AA30
CT02
GG01
GT34
LH15
ML25
OA45
PL10
PN18
SL25
TG38
TW34
TY03
YS04
YW01
Customer Name
All About Gardens
Christmas Tree Farm
Garden Gnome
Green Thumb Growers
Lawn & Home Store
Mum’s Landscaping
Outside Architects
Pat’s Landscaping
Pyke Nurseries
Summit Lawn Service
TriState Growers
TAL Wholesalers
TLC Yard Care
Yard Shoppe
Young’s Wholesalers
Address
47 Berton St.
483 Cantor Rd.
10 Main St.
26 Jefferson Hwy.
33 Maple St.
196 Lincoln Ave.
234 Magnolia Rd.
22 Main St.
10 Grant Blvd.
345 Oaktree Rd.
24 Main St.
234 Cantor Rd.
24 Berton St.
124 Elm St.
5239 Lancaster Hwy.
City
Greer
Pleasantburg
Gossett
Pleasantburg
Chambers
Quaker
Gaston
Chesnee
Adelphia
Chesnee
Gaston
Pleasantburg
Greer
Quaker
Adelphia
Postal
State Code
PA
19158
NJ
07025
PA
19157
NJ
07025
NJ
07037
DE
19719
DE
19723
NJ
07053
PA
19159
NJ
07053
DE
19723
NJ
07025
PA
19158
DE
19719
PA
19156
Amount
Paid
$1,190.00
$2,285.50
$1,300.00
$3,325.45
$895.00
$0.00
$4,205.50
$1,165.00
$2,465.00
$3,225.45
$1,075.00
$4,125.00
$1,845.00
$445.00
$1,785.50
Balance
Due
$365.00
$825.35
$297.50
$865.50
$515.00
$1,805.00
$945.00
$180.00
$530.00
$675.50
$0.00
$350.00
$689.45
$575.00
$345.60
Sales Rep
Number
26
29
29
32
26
29
32
26
32
26
29
26
29
32
32
Lab 4
CTEC 226.555
Module 1 – Lab 1
Due – Wednesday, June 5, 2019 @ 5 PM
(Minus 50% after 5:15 PM )
**** Upload to Dropbox ****
Please see section 1 – 12f in your book: “In the Lab – Lab #1”. You will see the instructions
and you will be asked to download the needed Access Database form Mindtap (Garden Naturally
database from the Data Files)
Additionally, I have:
•
Uploaded the need file (Garden Naturally database from the Data Files) to Blackboard
•
Copied the instructions below.
Once you complete the tasks, upload your file to the Blackboard Dropbox.
Instructions: Perform the following tasks:
1.
Run Access, open the Lab 1 Garden Naturally database from the Data Files, and enable the content.
2.
Open the Sales Rep table in Datasheet view and add the Salary YTD field to the end of the table. The field
has the Currency data type. Assign the caption SR # to the Sales Rep Number field.
3.
Add the records shown in Table 1–6.
Table 1–6
Data for Sales Rep Table
Sales Rep Last
First
Number
Name
Name
32
Ortiz
Gloria
Street
982
City
State Postal
Start
Commission
Salary
Code
Date
Rate
YTD
Chesnee NJ
07053
9/12/2015 .05
$32,555.65
Quaker
DE
19719
8/28/2017 .04
$1,500.00
Gossett
PA
19157
6/1/2015
.06
$35,075.30
Greer
PA
19158
5/16/2016 .05
$33,100.50
Victoria
Ln.
35
Sinson
Mike
45 Elm
St.
29
Gupta
Rufus
678
Hillcrest
Rd.
26
Jones
Pat
43 Third
St.
4.
Resize the columns to best fit the data. Save the changes to the layout of the table.
5.
Import the Lab 1-1 Customer workbook shown in Figure 1–86 into the database. The first row of the
workbook contains the column headings. Customer Number is the primary key for the new table. Assign
the name Customer to the table. Save the Import steps, and assign the name Import-Customer Workbook
to the steps. Assign Import Customer Workbook as the description.
6.
Open the Customer table in Design view and make the following changes:
Change the field size for the Customer Number field to 4.
Change the field size for the Customer Name field to 30.
Change the field size for the Address field to 25 and the field size for the City field to 20.
Change the field size for the State field to 2 and the field size for the Postal Code field to 5.
Change the field size for the Sales Rep Number field to 2.
Add the caption CU # to the Customer Number field.
Add the caption SR # to the Sales Rep Number field.
7.
Save the changes to the Customer table. If a Microsoft Access dialog box appears with the ‘Some data may
be lost’ message, click the Yes button.
8.
Open the Customer table in Datasheet view and resize all columns to best fit the data. Save the changes to
the layout of the table.
9.
Create a query using the Simple Query Wizard for the Customer table that displays the Customer Number,
Customer Name, Amount Paid, Balance Due, and Sales Rep Number. Save the query as Customer Query.
10.
Create the report shown in Figure 1–87 for the Customer table. The report should include the Customer
Number, Customer Name, Amount Paid, Balance Due, and Sales Rep Number fields. Include totals for the
Amount Paid and Balance Due fields. Be sure to change the column headings to those shown in Figure 1–
87. Save the report as Customer Financial Report.
Figure 1–87
11.
If requested to do so by your instructor, change the address for Pat Jones in the Sales Rep table to your
address. If your address is longer than 20 characters, simply enter as much as you can.
12.
Submit the revised database in the format specified by your instructor.
13.
The Commission Rate field has a field size of Single. If you changed the field size to Integer, what values
would appear in the Commission Rate column? Why?

Purchase answer to see full
attachment