Question Orders Database

[jimd1768]

I would like to build a very simple customer orders database. I have looked for examples of this and can't find one. If anyone can point me in the direction of a sample, it would be greatly appreciated.

I think I need 4 tables:
Customers
Products
OrderDetails
Payment

I am not sure which fields should be linked through them all. Again any help on this would be great.

Thank you

 

[HiTechCoach]

I would like to build a very simple customer orders database. I have looked for examples of this and can't find one. If anyone can point me in the direction of a sample, it would be greatly appreciated.

I think I need 4 tables:
Customers
Products
OrderDetails
Payment

I am not sure which fields should be linked through them all. Again any help on this would be great.

Thank you

See if this example helps:

Orders.mdb and Solutions.mdb

 

[jimd1768]

Thank you for the response. Unfortunately it is saying that it cannot link to linked tables in Northwind. I have Northwind open.
I am using Access 2007, not sure if that may be the problem.

Thanks again

 

[HiTechCoach]

Thank you for the response. Unfortunately it is saying that it cannot link to linked tables in Northwind. I have Northwind open.
I am using Access 2007, not sure if that may be the problem.

Thanks again

If you already have the Northwind 2007 open then you have already found a orders template.

Is there a problem with the Northwind 2007 orders template that comes with Aces 2007?

 

[jimd1768]

I am not that far advanced and am trying to build slowly. There is so much going on when you go into relationships, I am not sure where to start. I was looking for a simplified orders db if that is possible.

Thanks

 

[HiTechCoach]

I am not that far advanced and am trying to build slowly. There is so much going on when you go into relationships, I am not sure where to start. I was looking for a simplified orders db if that is possible.

Thanks

A major part to how difficult an order processing database is to build depends on if you need inventory control.

If you want inventory control, in my experience from 30+ years building accounting/inventory control systems, you should build that is from the start. It can be added later, but it is a lot more difficult to do unless you have already planned out how to add it later.

If inventory control is not an issue then see the attached example:

 

[HiTechCoach]

If you will need inventory control, please read:

Inventory Control: Quantity on Hand

 

[gemma-the-husky]

without trying to pour too much cold water on this, an order processing database is not simple at all, and not to be undertaken lightly.

if you are trying to build in payments, then it also includes deliveries, invoices, and so on. I should imagine wherever you are there are issues with local sales taxes. (eg VAT in the UK)

if you are trying to learn access, i would start with something much simpler.

 

[jimd1768]

A major part to how difficult an order processing database is to build depends on if you need inventory control.

If you want inventory control, in my experience from 30+ years building accounting/inventory control systems, you should build that is from the start. It can be added later, but it is a lot more difficult to do unless you have already planned out how to add it later.

If inventory control is not an issue then see the attached example:

Thank you so much. This helps a lot.
Understanding the relationships is the key for me.

Thanks again