in desperate need of an Access professional

[Ackms421]

Hi,

I'm a student and I am working on an assignment on Access. I can't
seem to figure most of it out. How do I figure out how to set the
relationships up properly so that the queries work. Also, one of the
tasks is to take information from two tables, "price per day" and
"capacity of students" and come up with a price per student within a
query. I have no clue how I am supposed to do this. Any help would be
much-appreciated. Thanks,

Steve

 

[Smartin]

Hi,

I'm a student and I am working on an assignment on Access. I can't
seem to figure most of it out. How do I figure out how to set the
relationships up properly so that the queries work. Also, one of the
tasks is to take information from two tables, "price per day" and
"capacity of students" and come up with a price per student within a
query. I have no clue how I am supposed to do this. Any help would be
much-appreciated. Thanks,

Steve

Hi Steve, sounds like you are a bit under the gun. I make no claims of
being an "Access professional" (though I play one at work), however I
doubt it takes a professional level of understanding to help you out.

Relationships associating the common information in tables. Do you have
a good example of a relational database, such as Northwind? Try looking
at the relationships window or some of the query designs... the lines
drawn between the tables represent the relationships. I realize this may
be a little vague, but I imagine if you are taking a class asking you to
this kind of thing, you must have some examples at hand.

As for your query, it's rather difficult to help here because you
haven't given any information about what these tables. If I have to
guess, "price per day" has basically date and currency columns, and
"capacity" has date and some kind of number of students. If this is
anywhere near correct, you would start by including both of these
tables, joined on the date column. You can then get the corresponding
price and capacity numbers, and do some division.

Is this helping?

 

[Ackms421]

Well it's an Introduction to Computer Info. Systems class and Access is
just brushed over so there are actually not any examples. But, do you
have AIM? or some other instant messenger service? Maybe you could do
me a huge favor and chat w/me on there. my aim screen name is
Supersteve81.

 

[Smartin]

Well it's an Introduction to Computer Info. Systems class and Access is
just brushed over so there are actually not any examples. But, do you
have AIM? or some other instant messenger service? Maybe you could do
me a huge favor and chat w/me on there. my aim screen name is
Supersteve81.

Sorry I don't actually, but any questions you might have I will be happy
to attempt to answer here.

Regards,

 

[David F Cox]

Are you sure it is not a management class? Private consultations with an
Access professional for free? If it so, you should do well ...

 

[Ackms421]

David, I certainly appreciate your wit but the sad fact is that I was
not taught access and I can't believe that it is this difficult to
figure it out. The "specific area" where I'm having trouble is the
queries. I have no concept of what to do. help...

 

[David F Cox]

I don't know what "capacity of students" is. (My first guess was alcohol
related
Let us guess that we are hiring a room.
If so we will have something on the lines of [Cost_per_day] and [capacity]
and [room_id] field names. I would expect to see these all in one table, so
I need more info to see where relationships come into the scene.

Have you used the QBE (Query by example) design grid to design any queries?

 

[Ackms421]

Dave,

The "capacity" is how many students can fit into the room. If you
actually are feeling very graceful right now, I would defer you to my
other post where I typed out the entire problem. At this point, I have
everything done except for "d." I do not know how to create a query
such that the cost per class is divided by the capacity of students.
I'm lost here. Can you help me out? I'll e-mail you what I have so
far if you feel like going above and beyond. Nonetheless, any kind of
help you are gracious enough to offer will be very appreciated.

Steve

 

[Brendan Reynolds]

Here are some resources that might help ...

http://office.microsoft.com/en-us/assistance/CH790018001033.aspx
http://office.microsoft.com/en-us/training/CR061829401033.aspx

http://msdn.microsoft.com/library/en-us/dnacc2k2/html/odc_FMSNormalization.asp
http://msdn.microsoft.com/library/en-us/dnacc2k/html/acfundsql.asp

Lot's of other good stuff in the MSDN Library too ...

http://msdn.microsoft.com/library/en-us/odc_2003_ta/html/odc_ancoffsol.asp

Check out the Access 2002 and Access 2000 technical articles as well as the
Access 2003 technical articles. Most of them still apply to the later
versions.

 

[Jamie Collins]

I do not know how to create a query
such that the cost per class is divided by the capacity of students.
I'm lost here.

http://www.sqlcourse.com/

Jamie.

--