Applied Business Software

Phones.accdb

Home >Computer Science homework help >Applied Business Software

Carrier	CarrierID
Roger Wireless	1
Bell	2
Comwave	3
Cogeco	4
Vonage	5
Telus	6
Virgin Mobile	7
Compare Cellular	8
Fido	9
Koodo	10
N/A	11

TypeOfDevice	DeviceDescription
A	Accessory
M	MP3 Player
P	Phone

InventoryID	SellerFirstName	SellerLastName	TypeOfDevice	Manufacturer	Model	Carrier	Colour	PurchaseDate	Features	AskingPrice	SellingPrice	BuyerFirstName	BuyerLastName	SellDate
1	Chris	Deephouse	P	HTC	EVO 3D	Comwave	Black	1/1/12	Uneven call quality doesn't stop the EVO 3D from being the best phone currently available on Comwave.	¤ 165.00	¤ 150.00	Jim	Everyly	6/1/12
2	Donna	Hunt	P	HTC	ThunderBolt	Rogers Wireless	Black	3/5/12	The well-appointed ThunderBolt is the phone to buy if you want to see what 4G can do.	¤ 70.00
3	Kelly	German	P	HTC	Sensation 4G	Rogers Wireless	Silver	6/1/13	The Sensation delights with a gorgeous display, a beautiful design, and dual-core power, but possible “death grip” issues are worrisome.	¤ 99.99	¤ 69.50	Susan	Dykas	7/5/13
4	Jon	Treadwell	P	Microsoft	G2x	Cogeco	Black	9/18/12	The T-Mobile G2X is a no-frills powerhouse that excels at gaming, multitasking, and video.	¤ 145.00
5	Ellen	Hepp	P	Motorola	Atrix 4G	Bell	Black	2/5/12	This dual-core phone is fast and boasts solid data speeds, but the Atrix-powered laptop accessory is a good idea poorly executed.	¤ 55.00	¤ 43.00	Ralph	Borden	5/7/12
6	Keith	Mast	P	Samsung	Charge	Bell	Black	4/28/13	The LTE speeds dazzle, the AMOLED display shines, and you get a free mobile hotspot at least for a little while. What’s not to like? Well, the battery life disappoints, but that may not be enough to spoil the fun.	¤ 35.00
7	Shanti	Kengeter	P	Microsoft	myTouch 4G Slide	Cogeco	Blue	10/31/11	The myTouch 4G Slide has one of the best cameras we've ever tested--and the rest of the phone is pretty amazing as well.	¤ 125.00
8	Frank	Jones	P	Samsung	Epic 4G	Bell	Black	11/25/11	The standout of the Galaxy S phones, the Epic 4G offers some enticing features like a physical keyboard, front-facing camera, and 4G network support.	¤ 25.00	¤ 25.00	Alicia	Myers	11/26/11
9	Andi	Smith	P	Microsoft	myTouch 4G	Cogeco	Black	2/14/12	The powerful myTouch 4G delivers when it comes to multimedia and performance, but make sure you live in an HSPA+-supported area before purchasing it.	¤ 22.00	¤ 19.00	Miguel	Angeles	3/18/12
10	Coz	Smith	P	Apple	16GB iPhone 4	Bell	Black	3/3/13	The Verizon iPhone 4 is a major upgrade from its predecessor, the iPhone 3GS, in everything from the camera quality to data speeds.	¤ 250.00
11	Katie	Hepp	M	Apple	iPod	N/A	Blue	6/13/10	4GB memory; headphones; good condition.	¤ 49.00
12	Manna	Geist	A	Rocnation	Aviator	N/A	Black	11/12/11	The remote and mic are supported only by iPod nano (4th generation and later), iPod classic (120GB, 160GB), iPod touch (2nd generation and later), iPhone 3GS, iPhone 4, iPad, and iPad 2.	¤ 112.00
13	James	Jones	P	Samsung	Glyde U940	Rogers Wireless	Black	6/29/12	Good camera.	¤ 45.00
14	Mohammad	Khan	A	Apple	Headphones	N/A	White	7/19/12	Basic headphones that come with iPod.	¤ 10.00
15	Lily	Xu	P	Apple	iPhone 3	Bell	Pearl	8/15/12	No scratches.	¤ 88.00
16	Carl	Paks	P	Apple	iPhone 4	Bell	Blue	9/2/12	Comes with case and two chargers.	¤ 125.00

SELECT Inventory.[InventoryID], Inventory.[SellerFirstName], Inventory.[SellerLastName], Inventory.[TypeOfDevice], Inventory.[Manufacturer], Inventory.[Model], Inventory.[Carrier], Inventory.[Colour], Inventory.[PurchaseDate], Inventory.[Features], Inventory.[AskingPrice], Inventory.[SellingPrice], Inventory.[BuyerFirstName], Inventory.[BuyerLastName], Inventory.[SellDate] FROM Inventory WHERE (((Inventory.[SellDate]) Is Null));