Help Design Food Price Database

[Davi]

Access 2003
Excel 2003

I want to design a Food Price Database

Record International Food Price
Record Market Food Price

International Food Price
City

Market Food Price
Food
Price

Table
International Food Price Table: Date, City, Country, FoodName, Price
Market Food Price Table: Date, MarketName, FoodName, Price
Market Walk Time Table: MarketName, Time

Relation
Find Food interest in International Food Price Table
Find Market Food Price and record in Market Food Price Table
Analyze International Food Price Table
Market Food Price Table


International Food Price List
Excel Sheet
Food Name Date Food Price US$
2007-6-2 2007-6-3
potato 0.5 0.5
flour 0.5 0.5
etc.

place of production
Excel Sheet
Food Name Date place of production
2007-6-2
potato Derbyshire, UK
flour YO, US
potato Nottinghamshire, UK
potato UK
potato Shropshire, UK
flour Hertfordshire, UK
flour West Sussex, UK
flour Manchester, UK
potato CA, US

Every day, I walk to Market A, and then MarketB, and then MarketC
When I am in MarketC, I have note down all products price in MarketA,
MarketB, MarketC
I know which Market is the lowest price
Then I go to the market, and buy food, go home

Walk Time
Excel Sheet
MarketA minutes MarketB minutes MarketC minutes
MarketA 6 6
MarketB 6 6
MarketC 6 6
Home 3 10 4

Market Price
Excel Sheet
MarketA MarketB MarketC
potato 0.5 0.65 0.5
flour 0.3 0.5 0.2
etc.

International Food Price List are different from the MarketA, MarketB,
MarketC price
But I need to choose the best food names from International Food Price List,
then ask these food names in MarketA, MarketB, MarketC.
I will not ask many food names, only some food names.

International Food Price List
place of production
Walk Time
Market Price
4 Excel Sheets

Please instruct me details.