What table should I make for PURCHASE and SALES database?

[wannabesmart]

What table should I make for purchase and sales database in Ms. Access? and ....
What will each table contain?
e.g. :


Table Goods = goods_code, name, unit, etc.
Table Customer = customer_id, name, etc.

Then is this possible?

a.Table Purchase (or Buying?)
= goods_code, name, unit, selling price

b.Table Sales (or Selling?)
= goods_code, name, unit, purchase price

Is it possible? so, data type of both tables are Lookup Wizard?

I need someone or those who knows well / are experts at database/Microsoft Access, because this is for my essay.

I'd be really grateful if anybody could help.

[Ruegen]

Tables could include:

Customers, orders, invoices, products.

Then, towns, states etc for customer details

DO NOT use a lookup wizard. EVER. in a table. NEVER.

http://access.mvps.org/access/tencommandments.htm

You don't want to get that mixed up. Tables are for storing data. Not interacting e.g. table lookup wizard.

Once you have created the tables you link them in into relations using the relationship manager. Using each tables ID to a number field on the other table.

Then make a forms with subforms or combo boxes to pull data from another table etc.

You can use the form wizard when you click on the create tab - this will help you build a form based off a table

[orange]

CAUTION: Do not jump into Access without some understanding of database.

Here is a list of links to articles/videos/tutorials that will help you.

CAUTION: Do not jump into Access without some understanding of database.



Principles of relational Design http://forums.aspfree.com/attachment...2&d=1201055452
Entity Relationship Diagramming http://www.rogersaccesslibrary.com/T...lationship.zip

Video tutorials(Langer):
If you are quite good at learning by Watching/Listening
rather than reading.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

https://www.youtube.com/watch?v=lXAG...6FE5448948D9B4 E-R Diagramming Price and Quantity

Complete set of tutorials on Acc2010.
https://www.youtube.com/playlist?lis...FoilxbUY0yUqZP

A standard list of helpful items for new developers:
A good data model is the first step to realizing any database and Database Answers (free models) has several free models on which to base a business concept for getting some ideas to match what may closely compliment your business model.

The concepts of database building are best conceived when thoroughly planned . . .

• Database planning tutorial Part I
• Database planning tutorial Part II
• Argeedblu's FAQ on Design Strategies

And the following links on normalization cannot be stressed enough . . .

• Noah's FAQ on Normalization
• Roger's Blog on Normalization
• Jerry's FAQ on Normalization
• GroverParkGeorge's PDF on Normalization
• MSKB 283878: Description of the database normalization basics

Tutorials, KB Articles and Demos that can assist a new Access developer are found here:

• UA Access Tutorials
• Crystal's Access Basics for Programming
• Access Tutorial
• Access VBA Tutorial
• UA Access Knowledgebase / FAQ
• UA Code Archive

Good luck with your project

[Ruegen]

Pretty much take Orange's advice. I've wasted a week of work once because I didn't follow the rules. At least only a week.