ACCESS 2013 Project

g.-n-ac2013-fixit-3-6.accdb

Home >Computer Science homework help >ACCESS 2013 Project

CustomerID	FirstName	LastName	StreetAddress	City	ZipCode	Phone	Newsletter
AG01	Antonio	Gonzalez	702 Columbia Road	West Palm Beach	33403	(561) 555-9361	false
AW01	Anthony	Willett	1274 Valley Street	West Palm Beach	33412	(561) 555-7939	false
BG01	Bruce	Garber	1107 Murry Street	Ft. Lauderdale	33312	(954) 555-4473	true
CF01	Caroline	Fredette	4123 Five Points	West Palm Beach	33403	(561) 555-0634	false
CS01	Charlotte	Sager	749 Petunia Way	Miami	33156	(305) 555-2879	true
DB01	Dale	Brown	4849 Sunrise Road	West Palm Beach	33401	(561) 555-2312	false
DD01	David	Duron	1317 Everette Lane	West Palm Beach	33414	(561) 555-5510	false
DT01	Danny	Tweed	711 Duke Lane	Miami	33183	(305) 555-7623	false
EM01	Emily	McNabb	3633 Armbrester Drive	Miami	33134	(305) 555-7363	false
GE01	Genevieve	Eades	1941 Collins Avenue	West Palm Beach	33401	(561) 555-4819	false
GP01	Gerald	Price	3735 Jadewood Drive	Ft. Lauderdale	33312	(954) 555-6754	false
HH01	Heidi	Hartzell	2204 Plainfield Avenue	Ft. Lauderdale	33301	(954) 555-3859	true
JA01	Joe	Alleyne	2086 Lewis Street	Miami	33176	(305) 555-3748	false
JB01	Juan	Bettencourt	4769 Pinewood Avenue	West Palm Beach	33412	(561) 555-4509	true
JC01	John	Castellano	56 Waldeck Street	Miami	33176	(305) 555-7731	false
JD01	Jeff	Defelice	2202 Boone Street	Miami	33134	(305) 555-9012	true
JM01	Jason	Mayer	2331 Upland Avenue	Miami	33183	(305) 555-1956	false
JW01	Jeffery	Weldon	3775 Willow Oaks Lane	Ft. Lauderdale	33305	(954) 555-6243	true
MB01	Melinda	Bocanegra	355 Garrett Street	Miami	33156	(305) 555-5648	true
MN01	Marvin	Numbers	4630 Meadowcrest Lane	Ft. Lauderdale	33305	(954) 555-4366	true
MZ01	Min	Zhou	3952 Hewes Avenue	Ft. Lauderdale	33316	(954) 555-4386	false
NG01	Nora	Gomez	3182 Roguski Road	Ft. Lauderdale	33316	(954) 555-9177	true
NW01	Nathan	Westmoreland	4066 Glen Street	West Palm Beach	33414	(561) 555-0096	true
PE01	Philip	Elson	2905 Washington Street	Miami	33186	(305) 555-1028	false
RR01	Russell	Rand	3320 Sharon Lane	West Palm Beach	33417	(561) 555-2958	true
RR02	Ronald	Rayner	3670 Beechwood Drive	West Palm Beach	33417	(561) 555-1141	true
RS01	Roberta	Storm	2191 Jarvis Street	Miami	33186	(305) 555-0049	true
RW01	Ralph	Whitacre	590 Grant View Drive	Ft. Lauderdale	33304	(954) 555-4512	true
SD01	Steve	Diggs	2860 Godfrey Road	Ft. Lauderdale	33304	(954) 555-1017	false
TW01	Thomas	Walk	2474 Croft Drive	Ft. Lauderdale	33301	(954) 555-9960	false

PetID	AnimalType	Breed	MainColor	AgeInMonths	Price
144601	Cat	Bengal	Brown	3	¤ 50.00
147883	Dog	Fox Terrier	White	5	¤ 95.00
208636	Dog	Siberian Husky	Gray	3	¤ 180.00
236936	Dog	Bull Terrier	White	3	¤ 135.00
267349	Cat	Siamese	Beige	4	¤ 35.00
308359	Dog	Yorkshire Terrier	Brown	4	¤ 120.00
366426	Dog	Pomeranian	Beige	3	¤ 145.00
382848	Dog	American Eskimo Dog	White	5	¤ 220.00
412745	Dog	Chihuahua	Brown	4	¤ 90.00
451472	Cat	Turkish Angora	White	3	¤ 95.00
453557	Dog	Boxer	Beige	3	¤ 210.00
458263	Dog	Poodle	White	4	¤ 75.00
466448	Cat	American Shorthair	Calico	2	¤ 20.00
495646	Dog	Dachshund	Brown	3	¤ 105.00
519192	Dog	Bloodhound	Brown	4	¤ 165.00
520691	Cat	American Bobtail	Brown Tabby	4	¤ 30.00
571764	Cat	Himalayan	White	5	¤ 60.00
599703	Cat	American Shorthair	Black	4	¤ 20.00
661399	Cat	Savannah	Beige Tabby	5	¤ 105.00
665054	Dog	Irish Setter	Brown	5	¤ 175.00
678221	Cat	Persian	White	4	¤ 100.00
718056	Cat	Scottish Fold	Gray	4	¤ 75.00
723951	Dog	Golden Retriever	Beige	5	¤ 180.00
763290	Cat	American Shorthair	Orange Tabby	2	¤ 20.00
796859	Cat	Manx	Gray Tabby	3	¤ 50.00
797129	Cat	American Shorthair	Silver Tabby	3	¤ 20.00
831176	Dog	Old English Sheepdog	White	4	¤ 175.00
858070	Cat	Maine Coon	Gray Tabby	3	¤ 75.00
883940	Dog	Giant Schnauzer	Black	4	¤ 110.00
910387	Dog	Cocker Spaniel	Beige	3	¤ 145.00

ID	PetID	CustomerID	SaleDate
1	208636	DD01	6/30/13
2	144601	JA01	6/1/13
3	147883	JB01	6/1/13
4	208636	MB01	6/1/13
5	236936	DB01	6/20/13
6	267349	SD01	6/20/13
7	366426	SD01	6/20/13
8	382848	CF01	6/4/13
9	451472	AG01	6/5/13
10	519192	JA01	7/14/13
11	520691	JW01	7/4/13
12	520691	HH01	7/17/13
13	661399	PE01	7/24/13
14	718056	RR01	7/14/13
15	831176	RR02	8/14/13
16	678221	CS01	8/1/13
17	661399	TW01	8/4/13
18	520691	JW01	7/4/13
19	910387	MN01	8/15/13
20	858070	MZ01	8/1/13

SELECT [Customers].[CustomerID], [Customers].[LastName] FROM Customers;

SELECT [Pets].[PetID] FROM Pets;

SELECT [Pets].[PetID] FROM Pets ORDER BY [PetID];

SELECT DISTINCTROW * FROM Customers;

SELECT Sales.SaleDate, Customers.LastName, Customers.CustomerID, Sales.CustomerID AS CustomerID_Sales, Customers.FirstName, Pets.PetID, Sales.PetID AS PetID_Sales, Pets.Price, Pets.AnimalType, Customers.Phone FROM Pets INNER JOIN (Customers INNER JOIN Sales ON Customers.CustomerID = Sales.CustomerID) ON Pets.PetID = Sales.PetID;

SELECT DISTINCTROW * FROM Pets;

SELECT DISTINCTROW * FROM Sales;