G
Guest
I need to design database for Trade Company, use Access 2003or SQL Server 2000?
Access 2003
Northwind Sample Database
Sheet
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?
Access 2003
Northwind Sample Database
Sheet
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?