create tables from form etc

Reggie, I have looked at Northwind but I guess I am not finding it. I do find an enormous amount of information but trying to find out what one actually wants is quite another matter. A great deal of the time it is a case of just being pointed in the right direction but I just wish there were far ore detailed tutorials on how to do things. Yes I know it is a big program but recently I learned Dreamweaver and some of Flash so I am not expecting quick results. I have the said database open but cannot find how to create multiple items in an order – so if you can point me in the right direction I would be grateful. I am starting an Access course tomorrow morning but sometimes the tutors go so quickly that you do things (but there isn’t time to take notes) so afterwards one has only a little idea of what one has done.
--
Take care, David


"Reggie" wrote:

David, I would start by looking at the example of the Orders form in the
Northwind sample database that ships with access. On my machine it's in
C:\Program Files\Microsoft Office\Office\Samples folder. If you can find it
do a search for Northwind.mdb. If you still can't locate it let me know and
I will email a copy to you. I'm using Office2K/WXP Pro. Let me know. Not
trying to side-step your question, but I think you will get much more out of
seeing it for yourself and checking out how the queries/tables/relationships
etc. are setup.

--
Reggie

----------
" (donotspam) wrote in message
...
Hope you don't mind me posting again. If a client purchasers say 4 items
of papyrus - first is blank papyrus 13 @ $1.30, second Tutankhamen 1@ $1.30,
third is Nubian Princess 1@ $1.30, fourth Map of Roman Empire 5@ $1.30. They
are all same purchaser - how do I enter them so they are all entered for
ID1? Can I then create form so Quantity automatically multiplies Price to
give Subtotal of each then how would I create so that all Subtotals
automatically total - I can then add Sales Tax and S&H manually but want
Total Price to automatically calculate. Finally I would manually insert
Amount Paid so that Amount Owing automatically calculates (usually nil) -
thanks in advance.
--
Take care, David


" wrote:

I am just starting Access. Can one enter data in a form and create
tables from the data entered? Also I have created an invoice in Design View.
Three of the fields will be Units Ordered, Quantity and Price. I would like
to fill each of these in (depending on the order) from a drop down list. I
then need to multiply Quantity x Price to get a Subtotal. I then need all
the Subtotals to automatically get a Grand Subtotal (I would then add S&H 7%
min $3.95) to this + Sales Tax if appropriate to get Total - any advice on
how to do this greatly appreciated - thanks.
--
Take care, David

Tei,

I was where you were not too long ago with becoming familiar with
Access. I bought a Learnkey Access 2000 tutorial on 3 CDs on eBay a few
weeks back. It will tell you exactly everything you are looking for.
It tells you how to make a copy your Northwinds database (so you won't
zap the original); and how to design an Orders database that's precisely
what your asking.

But if your installed version of Access won't let you design tables, I
can only suggest that you fix your version or you acquire a completely
functional version.

Consider the time you've spent thus far as 'educational'. It's really
best if you design your tables first.

Here's a design hint: (BTW, set your current Form aside.)

You'll need several tables

Customer
Order
OrderItems
Products
ProductCategories

You might be in a hurry, but for you to have what you want in a hurry
won't come about unless someone does it for you; or you become more
familiar with designing a database quickly. With a tutorial (or as you
mentioned that you would be attending an Access class) you can
accomplish what you want.

C
==

wrote:
Reggie, I have looked at Northwind but I guess I am not finding it. I do find an enormous amount of information but trying to find out what one actually wants is quite another matter. A great deal of the time it is a case of just being pointed in the right direction but I just wish there were far ore detailed tutorials on how to do things. Yes I know it is a big program but recently I learned Dreamweaver and some of Flash so I am not expecting quick results. I have the said database open but cannot find how to create multiple items in an order – so if you can point me in the right direction I would be grateful. I am starting an Access course tomorrow morning but sometimes the tutors go so quickly that you do things (but there isn’t time to take notes) so afterwards one has only a little idea of what one has done.