Excel Data to Access Database

[buttons]

I was given a project to figure out how to use Workforce data stored in Excel spreadsheet (Various Formulas such as Data for ethnicity, gender, new hires, turnover, etc) that can be converted into a useful Access database that can be easily manipulated and updated as needed (such as quarterly updates, etc). I understand I can't be given an extensive explanation - but where do you suggest I start? Thank you

[MMcCarthy]

The first thing you need to do is to import the spreadsheet into Access.

Then you need to Normalise it. This means that you need to spread the data out into tables.

Check out the following website for some information on how to break your data down into tables.

http://support.microsoft.com/kb/209534/

I was given a project to figure out how to use Workforce data stored in Excel spreadsheet (Various Formulas such as Data for ethnicity, gender, new hires, turnover, etc) that can be converted into a useful Access database that can be easily manipulated and updated as needed (such as quarterly updates, etc). I understand I can't be given an extensive explanation - but where do you suggest I start? Thank you