Anyone good at MicrosoftAccess? ? ? Free Cards for help....

Allen · March 29, 2004 6:35AM

Nayone good at Access LMK

chiliwilly · March 29, 2004 7:09AM

Before I say I know what I'm doing what's the project?

Bill

kr580 · March 29, 2004 8:04AM

i have it

mreuter · March 29, 2004 9:49AM

I have used it to create a program to catalog my cards. Here is a website for an Access discussion group, just click on "General Discussion" when you get there and you can post questions, usually somebody answers them within a couple of hours. I don't know alot about it but you can contact me if you want and I'll see if I can help.

http://support.microsoft.com/newsgroups/xnewsleft.aspx?pr=newsgacc&&SD=GN&def=1

Allen · March 29, 2004 10:06AM

Here is what I have to do and I am pretty lost on it.

Start Microsoft Access and create database tables from scratch.

In the first database table, you want to a field name titled State. This will list all the 50 states including DC. The second field name for this table should be NumberStudents, this will have field values of number of students representing those states in WVU. Make sure your total number adds up to at least 24,000 students. Feel free to assign any numbers to any states.

Save this table as Number of Students.

Make another table that contains State, LiveOnCampus, and OffCampus as field names. Once again, the State should list all the states the US and DC.

LiveOnCampus should contain number of students from that state that live on campus, while OffCampus should contain the number of students from each state that live off campus.

You may use State as the Primary Key in both tables since each state has a unique two alphabet that represents it. Otherwise Excel will assign numbers, i.e. 1-51 as your primary key. In any case, you should have a primary key in each table.

You will need to establish a relationship between the two tables before you create your query.

You will then create a query that shows the number of students from any 3 close states (e.g. MD, VA, and DC) that live on campus and that live off campus. Save the query as tri-state.

kr580 · March 29, 2004 10:59AM

i've never used Access, so i'm prolly more lost than you... sorry

mreuter · March 29, 2004 11:45AM

mreuter · March 29, 2004 11:49AM

I'm not going to be of any help, sounds like you know alot more about access than I do. Maybe check the access discussion board for help.

Allen · March 29, 2004 11:54AM

Ok, Thanks for the help.

todderfield · March 29, 2004 1:19PM

did u get any help. I might could help ya out b/c I just got through working with access in my computer class at college. LMK.

If ya have AIM or MSN pm me. I'll prob have to get back to ya tommorow though.

daverint · March 29, 2004 1:35PM

I just read your post a few minutes ago. Still need that database? I made it.

-Dave

Allen · March 29, 2004 1:44PM

yeah that would be sweet can you mail it to me? eye_verson@yahoo.com

daverint · March 29, 2004 1:49PM

I think I sent it....

Allen · March 29, 2004 1:56PM

Yeah I got it- looks right but like I said I don't know exactly what im doing. I will find out tomarrow and see if i can find something for ya.

daverint · March 29, 2004 2:00PM

To be honest, I was a little confused by what you were trying to do also...You could do that with one table instead of two....And really, I'm just doing it for fun. I really don't need anything from you for it, if that's what you were thinking......I'm kind of a nerd. I just do stuff like this for grins...If you know more about what to do, let me know and I can make the changes...

-Dave

Allen · March 29, 2004 2:14PM

Thanks a lot man, I think the point was to learn to link the info between 2 tables. Im not sure but that is definate help- thanks.

MrRookie · March 29, 2004 10:03PM

<< <i>Here is what I have to do and I am pretty lost on it.

Start Microsoft Access and create database tables from scratch.

In the first database table, you want to a field name titled State. This will list all the 50 states including DC. The second field name for this table should be NumberStudents, this will have field values of number of students representing those states in WVU. Make sure your total number adds up to at least 24,000 students. Feel free to assign any numbers to any states.

Save this table as Number of Students.

Make another table that contains State, LiveOnCampus, and OffCampus as field names. Once again, the State should list all the states the US and DC.

LiveOnCampus should contain number of students from that state that live on campus, while OffCampus should contain the number of students from each state that live off campus.

You may use State as the Primary Key in both tables since each state has a unique two alphabet that represents it. Otherwise Excel will assign numbers, i.e. 1-51 as your primary key. In any case, you should have a primary key in each table.

You will need to establish a relationship between the two tables before you create your query.

You will then create a query that shows the number of students from any 3 close states (e.g. MD, VA, and DC) that live on campus and that live off campus. Save the query as tri-state. >>

looks like someone's in a CPT 101 class lol

have you learned how to type your name in Word yet?

Allen · March 29, 2004 10:12PM

Yah- I never go to that class because I knew how to do Word and Excel, but I have never used Access so I guess I shoulda gone once or twice.

Anyone good at MicrosoftAccess? ? ? Free Cards for help....

Comments