Thread: Set up database

Hey everyone.
I actually wouldn't go ask people on the internet about my ICT problems but this is extremely important to me - this could actually (literally) affect my whole life.
I will try to provide as much detail as possible, hoping it is relevant.
Please let me know if you need more info - but I should tell you that I do not know much about Access or the technical stuff about computers/Access. I only know how to do certain things, I kind of taught myself.
Okay, I really need to get to the point now.
The back story is there is a company that sells hampers online. These are either Standard Hampers that have food from one country (Like a British Hamper) or Bespoke Hampers that the customer can build from scratch. There are 12 items in each Standard Hamper. The prices for Standard Hampers (SH) is set but the price of Bespoke Hampers (BH) depend on the price of the individual items plus the delivery charge that depends on the weight of the items. When a customer buys a SH, the order is recorded in the database & the stock records are amended.
There are supposed to be 3 tables Stock, Order and Customer.
tblStock has fields to identify each type of stock item (I set this as an Autonumber field for Item ID), hold weight & price information (Number & Currency fields named weight & price respectively) and hold stock control information*.
tblOrder has fields to identify the order (Autonumber, Order ID), identify the customer (Number, Customer ID -- linked to tblCustomer, therefore perhaps a Look-up field), hold the hamper type (I am not sure if this refers to bespokestandard or standard french hamper), hold despatch information (I believed this to be Address and Number of Hampers, plus maybe Total Price but I do not know how to calculate it in Access) and hold an item list for a bespoke hamper*.
tblCustomer has fields to identify the customer (Autonumber, Customer ID), hold payment details (Credit Card Number [Number field]) and hold security information*.

* These are the areas I had most problems with, where I basically had no idea what to do. Could you suggest fields and comment on my existing fields?
Also, what do you think the relationships should be for my database to work correctly?

My specific problems, apart from the complications with the tables, are
- How can I make it so that when I enter a new order, the database will indicate if any item has fallen below a set stock level? I can set the validation rule so that Access alerts me but I do not know how to connect the order to the stock table.
- Also, the customers should be able to access the web site again after ordering to view a copy of the order. For this, there should be minimum input from customers but with a security feature. (I thought Usernames and Passwords would be enough for this. Do you agree) I need to, for this, design a method that will display the customer's order when the correct information is entered (It could be a flowchart, stuctured English, programming language etc. but I prefer flowcharts because they are the easiest to me.) I am supposed to assume that the link between the database & web site already exist and that each customer has a single order. After that, I am supposed to show a database view of how the customer information input earlier is linked to the correct order in my database.

I am sorry if this is a too long/simple/hard/weird/whatever-you-would-name-it question, but I am desperate. This task may have a very big effect on my life, which is why I'm so worried.
Thank you already for the help you will, or at least will try to, give me.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

I guess this is homework/coursework.

Have a look at one of the sample databases eg http://www.microsoft.com/downloads/d...kInfoContainer

Originally Posted by PinInPastels

but I need specific help. I have looked all over for it on the official MS site.

Specific help needs a specific question. If you are getting straight As in everything then in a few hours you should easily be able to make some sense of the link I gave you and be able to see how it applies to your own requirements.

I would expect you then to come back with some specific questions and something that shows you have applied some effort.

Endevour and you will get the university you deserve.