Grocery shopping database

[Accessuser67]

I use excel for entering my grocery receipts but after reviewing Microsoft access I think I can save a lot of time that it can be a useful tool for getting a list of things.

could someone please advise how I can use access to generate a grocery list that includes store, item, quantity, price and aisle. The aisle table is sort of confusing me a little to include.

best regards.

[ranman256]

the Isle table would just be for info about the store

tIsle table
--------
[Isle]
[storeID]
[contents] (beans, bread, and snacks)

tStore tbl
-------------
StoreID
StoreName
Addr
City
Manager

tGrocery tbl
--------------
GroceryItem
Isle
StoreID
Price
PackingVol (1 ct, 24 rolls, 1lb)
FoodType

[Accessuser67]

Thanks for your suggestion. Could you also provide how I can generate a grocery list with item and price and qty and store and aisle?