best way to move forward

[outsidethewall]

I have few excel files that I want to compile in access database. As I got started I got stuck with couple of problems.

1) I have table with user info, another table with what software they use and so on. I have 4 tables and all four have same user a column with different info about the user.

Now should I keep all those information in one table? If I do that I will have over 40 columns.

Is there are way to link all those tables together such that I don't have to repeat those username in every table?

2) The other part of my problem lies in different kind of table. When I put it in access I set it as yes/no. Basically, table consists of first row and first column with text and test is filled with yes/no box. My rows are groups and my columns are access to parts of programs. If a certain group has access to that part of program, the box is ticked.

I have about 21 similar tables with same group at the top as rows. Column for each table is different for different programs. Rest of the table is filled with yes/no option. What is the best best way to move forward?

I hope my question was understandable.

Thanks in advance

 

[John Big Booty]

If you read up on the Subject of data normalisation you will find that this will help you better understand how your tables should be structured and how to best to migrate your Excel data into an Access data base.

You may also find this tutorial on the subject useful.