+1(978)310-4246 credencewriters@gmail.com
  

STEP 1 – Create a new database and three new tables.

Create a new, blank database with the name Lastname_Assignment2.

Import the External Data files: tblCustomer, tblProduct, and tblPurchase into three new tables. All three are Excel workbooks. Select the CustomerID field as the Primary key for the tblCustomer file. Select the ProductID field as the Primary key for the tblProduct file. Let Access create the Primary key for the tblPurchase file.

STEP 2 – Use the Simple Query Wizard

Using the Simple Query Wizard, create a query showing all of the fields in the tblProduct table. Run and save the query with the name qryProduct_yourlastname.

STEP 3 – Use the Query Design View

Create a single table query using the Query Design View. Use the tblCustomer table and add the fields CustomerFirstName, CustomerLastName, and CustomerEmail. Run and save the query with the name qryCustomer_yourlastname.

Close and save all of the database objects.

Close your database.

ProductID CustomerIDPurchaseType
PurchaseDate Quantity
24
23 In Person
10
7/14/2013
13
23 In Person
10
7/14/2013
19
15 In Person
1
7/16/2013
20
15 In Person
1
7/16/2013
16
7 Online
3
7/16/2013
17
6 Phone
1
7/17/2013
25
6 Phone
2
7/17/2013
18
6 Phone
1
7/17/2013
4
2 Online
2
7/17/2013
1
2 Online
1
7/17/2013
3
2 Online
1
7/17/2013
9
2 Online
2
7/17/2013
10
2 Online
2
7/17/2013
21
2 Online
1
7/17/2013
5
11 In Person
1
7/17/2013
1
11 In Person
6
7/17/2013
1
1 In Person
3
7/17/2013
8
1 In Person
1
7/17/2013
2
20 In Person
1
7/17/2013
3
20 In Person
1
7/17/2013
11
20 In Person
1
7/17/2013
6
13 In Person
3
7/17/2013
5
13 In Person
3
7/17/2013
22
13 In Person
1
7/17/2013
25
12 In Person
1
7/17/2013
21
11 Phone
2
7/17/2013
17
11 Phone
1
7/17/2013
ProductID ProductDescription
Category QtyInStockPrice
Size
1 NikeID KD VI
Basketball
100
65.00
2 NFL Gear Football
94
80.50
3 CJ81 TrainerFootball
80
97.25
4 Hypervenom
Soccer
40
55.95
5 FC Barcelona
Soccer
30
45.24
6 Avocado Foot
Running
Care Cream 104
99.00
7 Alpha Pro Football
27
86.95
8 Cleats
Football
31
74.95
9 Coreware Football
49
31.95
10 Coolware Football
49
35.95
11 Hyperstrong
Football
42
89.50
12 ManchesterSoccer
City
30
34.95
13 Women’s Shorts
Sportsware
25
35.95
14 Tank Top Sportsware
27
34.95
15 Hoodie
Sportsware
19
79.95
16 Boy’s JacketSportsware
34
79.95
17 Roshe Run Running
iD
9
109.95
18 Softshell Sportsware
29
79.95
19 Jordan SuperFly
Basketball
13
47.95
20 Jordan CP3Basketball
15
44.95
21 Lemon Sportsware
Sportsware
Butter
26
22.50
22 Fleece
Sportsware
44
34.00
23 Training Basketball
38
14.95
24 CTR360 Soccer
22
87.25
25 Jerseys
Soccer
26
38.95
6
8
12
16
16
8
16
12
23
23
8
16
4
16
16
16
16
16
6
4
16
5
4
8
8
CustomerID CustomerFirstName
CustomerLastName
CustomerAddress
CustomerCity
CustomerState
CustomerPhone
CustomerEmail
1 Raja
Blake
P.O. Box 875,
Casper
708 Suspendisse
WI
Street
(701) 555-8217
justo.eu@milorem.edu
2 Omar
Bond
2485 FusceMartinsburg
Street
VA
(320) 555-4149
orci.consectetuer@Donecsollicitudin.ca
3 Mercedes Bowers 636 Sed Street
Murray
UT
(203) 555-3800
et@nonloremvitae.org
4 Lois
Buchanan Apt 206-7268
West
Amet
Warwick
Street
UT
(734) 555-2525
Sed@nibhsitamet.ca
5 Lavinia
Burton
P.O. Box 772,
Saipan
7168 A Road
PA
(385) 555-4836
lacinia.at.iaculis@gravidamolestie.ca
6 Haviva
Cleveland P.O. Box 735,
Port
3036
Jervis
Amet
PA Street (239) 555-4103
diam@Proinnon.ca
7 Hamish Dunn
Apt 992-9224
West
Donec
Lafayette
Street
NM
(406) 555-7943
sed@conubia.org
8 Guy
Grant
Apt 337-8497
Clarksburg
Et StreetND
(385) 555-0247
neque.non.quam@anunc.com
9 Fallon
HendersonP.O. Box 443,
Derby
1587 Donec
NC Road (828) 555-3242
quis@Fuscedolorquam.com
10 Erica
Hinton
Apt 526-549
Bradbury
In Street MT
(317) 555-6201
amet@Nullamvitaediam.edu
11 Emily
Hogan
Apt 740-6878
Miami
EnimBeach
Street
MN
(484) 555-6243
Aenean@maurisid.ca
12 Brenden Hogan
Apt 873-8407
IsleInofStreet
Palms
MN
(505) 555-9244
urna.Nullam.lobortis@loremDonecelementu
13 Blaze
Joseph
2610 Shadowbox
Spokane
Avenue
MN
(480) 555-3227
nec.luctus@inconsequat.com
14 Eden
Kinney
Apt 340 9 Sed
Kona
Road MI
(303) 555-4101
vulputate.risus.a@IntegermollisInteger.com
15 Genevieve Malone P.O. Box 819,
Meridian
922 Euismod
ME Road (808) 555-8217
fringilla.Donec@pellentesque.ca
16 Harper
Meadows 4558 SapienRye
Avenue IN
(484) 555-4149
augue@molestie.ca
17 Jonah
Mercedes P.O. Box 146,
Darlington
8510 Ipsum
IN Street (207) 555-3800
ipsum@dui.edu
18 Kibo
Perkins
P.O. Box 832,
Gary
51 DonecIAAvenue (219) 555-2525
vehicula.risus.Nulla@euaugue.edu
19 Marvin
Rhodes
Apt 294 747Suffolk
Posuere Avenue
HI
(715) 555-4836
mollis.dui@tortordictum.org
20 Nero
Rocha
5880 QuamCanton
Street
HI
(320) 555-4103
pharetra.felis@Sedeu.org
21 Otto
Rocha
388 DictumChicago
AvenueHeights
FL
(479) 555-7943
iaculis@netuset.ca
22 Raja
Silva
8089 Nec Avenue
OrangeburgCT
(320) 555-0247
pharetra@arcuetpede.edu
23 Samson Tanner
4139 Ornare
Anchorage
Avenue CO
(319) 555-3242
placerat@convallis.org
24 Silas
Travis
P.O. Box 819,
Meridian
9224 Euismod
AZ
Road(808) 555-8217
sit.amet.consectetuer@Pellentesquehabitan
25 Troy
UnderwoodP.O. Box 369,
Las6183
Vegas
Cursus
AK Road (571) 555-6243
dapibus.quam@egestasblanditNam.edu
@loremDonecelementum.edu
egermollisInteger.com
r@Pellentesquehabitantmorbi.ca

Purchase answer to see full
attachment

  
error: Content is protected !!