management information system and app

a01c1Books.accdb

Home >Business & Finance homework help >Management homework help >management information system and app

Author ID	LastName	FirstName
11	Beschloss	Michael R.
12	Turow	Scott
13	Rice	Anne
14	King	Steven
15	Connelly	Michael
16	Rice	Luanne
17	YourName	YourName

AuthorCode	Title	ISBN	PublDate	Price	StockAmt	PubID
13	Blackhills Farm	0-275-41199-7	2011.0	18.87	28.0	KN
15	Chasing the Dime	0-316-15391-5	2010.0	51.75	400.0	LB
15	City of Bones	0-316-15405-9	2007.0	20.76	94.0	LB
15	Darkness More than Midnight	0-316-15407-5	2007.0	20.76	432.0	LB
13	Interview with the Vampire	0-394-49821-6	2006.0	19.57	371.0	KN
16	True Blue	0-553-38398-0	1981.0	7.5	492.0	BB
16	Follow the Stars Home	0-553-58102-3	2007.0	6.99	496.0	BB
13	Blood and Gold	0-679-45449-7	2005.0	18.87	640.0	KN
11	Reaching for Glory	0-684-80408-5	2006.0	24.0	480.0	SS
17	Computer Wisdom	0-684-80415-5	2006.0	23.5	75.0	PH
17	Computer Wisdom II	0-684-80416-5	2011.0	28.0	27.0	PH
14	Hearts in Atlantis	0-684-85351-5	2000.0	13.5	528.0	SS
12	Personality Injuries	0-742095692-X	1999.0	27.0	403.0	FS
14	From a Buick 8	0-743-21137-5	2004.0	16.8	368.0	SS
11	Presidential Courage	0-684-85705-7	2007.0	24.0	120.0	SS
12	Ordinary Hereos: A Novel	0-37418421-6	2005.0	18.0	121.0	FS
12	Presumed Innocent	0-44635986-6	2010.0	22.0	121.0	FS
13	The Wolf Gift	0-307-59511-0	2012.0	14.5	42.0	KN
14	Cell: A Novel	0-340-92144-7	2006.0	18.9	195.0	SS
14	11/22/63	1-451-62728-9	2012.0	18.9	430.0	SS
15	The Black Box	0-316-06943-4	2012.0	18.21	83.0	LB
16	Dream Country	0-553-38581-X	2008.0	10.42	76.0	BB
17	Computer Wisdom III	0-684-80417-5	2013.0	25.0	42.0	PH

PARAMETERS __Author ID Value; SELECT DISTINCTROW * FROM Books AS [Maintain Authors] WHERE ([__Author ID] = AuthorCode);

SELECT DISTINCTROW * FROM Author;

SELECT Books.Title, Author.LastName, Author.FirstName, Publishers.PubName FROM Publishers INNER JOIN (Author INNER JOIN Books ON Author.[Author ID] = Books.AuthorCode) ON Publishers.PubID = Books.PubID ORDER BY Books.Title, Author.LastName;