newbie access 2007 question

[jamesy]

I am quite new to Access.

Basically I have been given an assignment in an IT survey class to:

"create a database using Microsoft Access. The database should contain three tables: Customers, Products, and Transactions; three queries: list of customers, transactions by customer, and transactions by product; and be something that a small business, such as a jewelry store or used car lot, can use for its daily needs. The database must contain an input form for the transactions and one report that is based on any of the queries; the tables must each contain 10 records; and the records in the transactions table must be created by way of the input form.

I've been searching the web and slowly learning the basics but I'm just about out of time to learn how to complete this assignment.

I have created tables, queries and basic forms but I can't get a form to 'talk' to more than one query or table at a time.

I believe I need a 'transactions' form that will pull data from the customer and product tables. (perhaps in a drop down menu?) That form would also need to accept input such as quantity and shipping destination and output all this info to a table called transactions. This is what I believe my goal is.

Unfortunately this is quite above my head for a survey course and the task is to 'figure it out' IE no direction given so game on.

Any thought and insight that could help would be appreciated. I am using Access 2007.

 

[MikeLeBen]

You need to familiarise with forms, form controls, SQL and VBA.
A drop down menu, within access, is a control named combobox: try and mess around with it and its properties so you get the hang of it.
Probably its most important feature is the row source, which determines what kind of data is going to be displayed in it; you can set that either via the access "control properties" pane or VBA (which is a very easy to learn programming language, though I'm not sure how much time you have on your hands).

The assignment isn't a complex one, but right now I can't point you to any resource that might help you through it: I see nobody has replied yet, and that is probably because the matter is too broad and would either require someone to do the work for you, or to explain very many things to you so you could do it yourself.
Try and be a little more specific and I'm sure the folks here (including myself with my little experience) will be glad to help.