New user needs help

[roccoau]

Hi I am new to Access and just need some advise.
I currently have 5 different excel spreadsheets that record sales for 4 different state's then another to hold stock items.
I want to make an access database to hold all this info.
Should I make one table to record all information from the 5 spreadsheets or have a seperate table for each.
Any advise would be most appreciated.

Tks

 

[Banana]

You'll want to read up on normalization to answer how many tables you need for your spreadsheets. Search around on this forum about this or google any scholarly articles on "normalization" and "database design theory".

HTH.

 

[roccoau]

Thanks for advice, I will search for info.

 

[Bee]

Thanks for advice, I will search for info.

http://www.access-programmers.co.uk/...d.php?t=100211

http://www.utteraccess.com/forums/sh...Number=1203148

You may want to try these for a start.

 

[cross5900]

wikipedia has a good article on normalization.