Re: Design Trade Company Database

Tech-Archive recommends: Speed Up your PC by fixing your registry

PC Data***
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@xxxxxxxxxxxxxxx





"Davi" <Davi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:77A2FAC1-9900-4AEF-814D-5F09E75E52BB@xxxxxxxxxxxxxxxx
I need to design database for Trade Company, use Access 2003or SQL Server
2000?

Access 2003

Northwind Sample Database

***
Product:
1,"Apple Juice",1,1,"24bottles/case",US$18,39,0,10,1
2,"Milk",1,1,"24bottles/case",US$19,17,40,25,0
3,"Tomato Juice",1,2,"24bottles/case",?10,13,70,25,0
My Company, the same.

Order:
10248,"VINET",5,1996-7-4 00:00:00,1996-8-1 00:00:00,1996-7-16
00:00:00,3,US$32,"Miss U","G N Rd. 124","Washington","Washington
DC","00000","the United States"
10249,"TOMSP",6,1996-7-5 00:00:00,1996-8-16 00:00:00,1996-7-10
00:00:00,1,US$12,"Miss X","Q N Rd. 543","New York","New York","the United
States",""
10250,"HANAR",4,1996-7-8 00:00:00,1996-8-5 00:00:00,1996-7-12
00:00:00,2,US$66,"Miss Y","G Street 22",,"New York","New York","the United
States"

Order Details:
10248,17,US$14,12,0.00
10248,42,US$10,10,0.00
10248,72,US$35,5,0.00

Supplier:
1,"JJ","Miss C","Purchse Manager","X Street 110","Washington","Washington
DC.","100000","the United States","(000) 000000000",,
2,"KF","Miss H","Purchasing Manager","XF Street
290","Washington","Washington DC.","10000","the United States","(000)
00000000",,
3,"MS","Mr H","Sales Representative","NJ Rd. 23","New York","New
York","10000","the United States","(000) 00000000","(000) 00000000",
MyCompany, have more:"Web URL", "Email"

Customer:
"ALFKI","SC","Miss L","Sales Representative","DC 50","New York","New
York","10000","the United States","(000) 00000000","(000) 00000000"
"ANATR","DN","Miss W","Owner","CD 80","New York","New York","10000","the
United States","(000) 00000000","(000) 00000000"
"ANTON","TS","W","Owner","HT 780","New York","New York","10000","the
United
States","(000) 00000000",

Categories:
1,"Drink","Soft Drink, Coffee, Tea, Beer",

Freight Forwarder
3,"Fedex","(000) 00000000"



I need to design database for Trade Company, use Access 2003or SQL Server
2000?
Is it right?
How to do?



.

Quantcast