IFMG 101

exploring_a01_grader_h1.accdb

Home >Information Systems homework help >IFMG 101

Author ID	LastName	FirstName	mSysRowId
11	Beschloss	Michael R.	3O/OmPjekXhE71C3kOEg68iArA7NMK4VgwCQ0i/BGQA=-~wNwueTJ+Wxks8rsvjfApZw==
12	Mulbery	Keith	WIx894LIZcRe4dQPymQC0/TskbCd70TrSBRlixYgBgY=-~DkyuQlkuLdMHUGp82bctRQ==
13	Rice	Anne	pS19mM/YAi6lhQyyJa2Rlz87+5M/Hg1EyfwOXoU8P/8=-~fJaJLt/0Dyk6J6ne5VBC2g==
14	King	Steven	1Cz30JBBUmtb9DSQgK7YsJ+Yu0UWBY5JPEvI4+ZS1+k=-~YzGgj5V2HYpRzT6tLjLMUg==
15	Harvey	Michael	Ql5U/TRhheiA0ncLt8N5QQiqy+WYE7DAfhtcLQjR93s=-~rGmEsWcBdHf3c5g8aPIyiQ==
16	Rice	Luanne	Vk7tNzdnoJfpM+cyRMsflPfY01O4n9SAtXmXkUjVX3M=-~nc8ndEkfHJWhkeWucNtH4A==

AuthorCode	Title	ISBN	PubID	PublDate	Price	StockAmt
13	The Wolf Gift	0-307-59511-0	KN	2012.0	14.5	42.0
13	Blackhills Farm	0-275-41199-7	KN	2011.0	18.87	28.0
14	Cell: A Novel	0-340-92144-7	SS	2006.0	18.9	195.0
13	Interview with the Vampire	0-394-49821-6	KN	2006.0	19.57	371.0
16	True Blue	0-553-38398-0	BB	1981.0	7.5	492.0
16	Dream Country	0-553-38581-X	BB	2008.0	10.42	76.0
16	Follow the Stars Home	0-553-58102-3	BB	2007.0	6.99	496.0
13	Blood and Gold	0-679-45449-7	KN	2005.0	18.87	640.0
11	Reaching for Glory	0-684-80408-5	SS	2006.0	24.0	480.0
12	Computer Wisdom	0-684-80415-5	PH	2006.0	23.5	75.0
12	Computer Wisdom II	0-684-80416-5	PH	2011.0	28.0	27.0
14	Hearts in Atlantis	0-684-85351-5	SS	2000.0	13.5	528.0
11	Presidential Courage	0-684-85705-7	SS	2007.0	24.0	120.0
14	From a Buick 8	0-743-21137-5	SS	2004.0	16.8	368.0
14	11/22/63	1-451-62728-9	SS	2012.0	18.9	430.0

ID	mSysRowId
1	tlHTfF5Ip/CGltCoKaOhV8+4i0wHHojXZksiSvjDah8=-~iD1WNWMXAtud2Z9w9iHtbw==

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;