Access

acc_4_mc_linksaver.zip

Home >Information Systems homework help >Access

ACC_4_MC_LinkSaver.accdb

LID	LTitle	LURL	NumLinks	LinkAddDate
1	Google Search Engine	www.google.com	2	4/7/07
2	Yahoo!	www.yahoo.com	2	4/6/07
4	CNN News Network	www.cnn.com	1	4/3/07
5	University of Georgia	www.uga.edu	1	4/10/07
7	Official ASP.Net Site	www.asp.net	2	4/27/07

LUID	fkUID	fkLID	LCat	LDate
1	1	1	Search	4/7/07
2	1	2	Search	4/6/07
4	2	1	Search Engines	4/20/07
5	3	2	Search Sites	4/27/07
6	2	4	News	4/3/07
7	3	5	School	4/10/07
11	2	7	Programming	4/28/07
12	1	7	Web Development	4/27/07

UID	LUserName	LPassword	LEmail
1	cpearson	sd123$	[email protected]
2	kilgore	j$k$L$	[email protected]
3	Adent	a2b9c2	[email protected]
4	nick	dnao89s	[email protected]
5	estelle	98jk12$	[email protected]
6	jim	oskd49	[email protected]

SELECT tblUserLink.fkUID, tblLink.LID FROM tblLink INNER JOIN tblUserLink ON tblLink.LID=tblUserLink.fkLID WHERE (((tblUserLink.fkUID)=1));

SELECT tblUserLink.LDate, tblLink.LTitle, tblLink.LURL FROM tblLink INNER JOIN tblUserLink ON tblLink.LID=tblUserLink.fkLID WHERE (((tblUserLink.LCat)="Search") AND ((tblUserLink.fkUID)=1));