Technician Training Database

[tajerome]

I have a good size excel spreadsheet that was created to keep track of technician copier training. The excel spread sheet has about 10 tabs broken down by region. The spread sheet is getting too big. It has the name of the employee, technician number, and an X of what equipment they're trained on. there are about 100 technicians. I want to create tables and link them together would be the first step. What is the best way to accomplish this? I would like to do this myself so I can learn. Can someone give me direction, especially linking tables.

[June7]

A field for each equipment with x is not a normalized data structure.

You need to get familiar with relational database principles, Access functionality, and programming concepts.

Suggest you go through some tutorials (book or web).

Start with http://www.rogersaccesslibrary.com/

[tajerome]

I realize an X is not appropriate. The excel spreadsheet I was given with data has an X.

[June7]

X or whatever, the structure is still not normalized.

[tajerome]

Should I just start from scratch and forget importing the excel spreadsheet? Should I manually re-enter all the data?

[June7]

You could maybe import or link the spreadsheets as is then manipulate the data in Access into a normalized structure and continue from there.