Microsoft Access

Lagged · 20-08-2008

G'day, meant to be working with Access this term and I cbf'd learning it, I missed most of it lol. Got a assignment now :S Figured out most of it just need help on 3 queries.

ASSESSMENT_Excel__Access.pdf - FileFront.com

That's the link for the file, my problem is Task 3.
Help would be appreciated :O

.checK · 20-08-2008

I remember doing this kind of thing at TAFE. I'll have a look and try to remember. Surely someone on gotgames knows how though.

.checK · 20-08-2008

Ok i think you would start a query then add all the fields in. Then in the Times Rented column you would have something like "> 149" or ">= 150" or something like that in the criteria bit.

Then for the second one start a query then in the criteria for year release put "1993" and in the criteria for Length put "> 119" or i think its "=> 120" or it might be ">= 120"

For the third one i think you would have "CBS Fox" or Like "CBS FOX" in the Distributor criteria.

Not sure if that is right, haven't accessd in a while. Its pretty basic stuff though so i'm sure someone will correct me if it is wrong.

Lagged · 21-08-2008

Indeed its very basic stuff lol thats why I didn't care I was away. Ta for the help though, will try now.

Edit --

Yeah all worked fine, Thanks!

ivo · 23-08-2008

you could always go and learn it rather than asking others for the answers...

Not understanding the material is fine, but not learning it? Lazy bastard.

Lagged · 29-08-2008

Ivo I put it to you that questioning my motive for getting gotgames to do my school work for me is rude and hurtful. Gotgames helps me out and I'm sure the people get some satisfaction from it, if not, I sure do

20-08-2008	#1 (permalink)
Lagged Honorary Member Join Date: May 2008 Location: Control Panel Posts: 1,323 Rep Power: 2	Microsoft Access G'day, meant to be working with Access this term and I cbf'd learning it, I missed most of it lol. Got a assignment now :S Figured out most of it just need help on 3 queries. ASSESSMENT_Excel__Access.pdf - FileFront.com That's the link for the file, my problem is Task 3. Help would be appreciated :O __________________ SuperFairyFriends-Lagged[2f] : i cant play under CMN eclipzebeaRs : wouldnt suprize me Last edited by Lagged; 21-08-2008 at 05:37 PM..

20-08-2008	#2 (permalink)
.checK Senior Member Join Date: Feb 2007 Posts: 920 Rep Power: 2	I remember doing this kind of thing at TAFE. I'll have a look and try to remember. Surely someone on gotgames knows how though. __________________

20-08-2008	#3 (permalink)
.checK Senior Member Join Date: Feb 2007 Posts: 920 Rep Power: 2	Ok i think you would start a query then add all the fields in. Then in the Times Rented column you would have something like "> 149" or ">= 150" or something like that in the criteria bit. Then for the second one start a query then in the criteria for year release put "1993" and in the criteria for Length put "> 119" or i think its "=> 120" or it might be ">= 120" For the third one i think you would have "CBS Fox" or Like "CBS FOX" in the Distributor criteria. Not sure if that is right, haven't accessd in a while. Its pretty basic stuff though so i'm sure someone will correct me if it is wrong. __________________

21-08-2008	#4 (permalink)
Lagged Honorary Member Join Date: May 2008 Location: Control Panel Posts: 1,323 Rep Power: 2	Indeed its very basic stuff lol thats why I didn't care I was away. Ta for the help though, will try now. Edit -- Yeah all worked fine, Thanks! __________________ SuperFairyFriends-Lagged[2f] : i cant play under CMN eclipzebeaRs : wouldnt suprize me Last edited by Lagged; 21-08-2008 at 05:42 PM..

23-08-2008	#5 (permalink)
ivo GotGames Moderator Join Date: Jun 2006 Location: Vic Posts: 2,060 Rep Power: 5	you could always go and learn it rather than asking others for the answers... Not understanding the material is fine, but not learning it? Lazy bastard. __________________ "If you wanna get it through their head, talk to them ragely" - fakeh

29-08-2008	#6 (permalink)
Lagged Honorary Member Join Date: May 2008 Location: Control Panel Posts: 1,323 Rep Power: 2	Ivo I put it to you that questioning my motive for getting gotgames to do my school work for me is rude and hurtful. Gotgames helps me out and I'm sure the people get some satisfaction from it, if not, I sure do __________________ SuperFairyFriends-Lagged[2f] : i cant play under CMN eclipzebeaRs : wouldnt suprize me