CODEWITHSUNDEEP
excelms-access
Deborah
Deborah

Reputation: 243

MS Access Table Normalization

I have 2 excel sheets, in which one sheet contains an organization’s entire employees details with Code, Name, Designation and the other sheet contains the books that an employee had studied. Second table consists of employee code, name and name of the book studied by that employee. One employee might have studied more than one book and one book can be read by many employees.

Now, I want to know how to get a resultant table, which holds employee details from table 1 and appropriate books they have studied from table 2 .

Finally, that table should contain columns of only employee code, name, designation, name of book1, name of book 2. And also in this resultant table I should be able to write queries and export the table contents.

Thanks in advance!!

Upvotes: 0

Views: 54

Answers (1)

ashleedawg
ashleedawg

Reputation: 21619

That's not Normalization...

Database normalization, or simply normalization, is the process of organizing the columns (attributes) and tables (relations) of a relational database to reduce data redundancy and improve data integrity. Normalization is also the process of simplifying the design of a database so that it achieves the optimal structure composed of atomic elements...

Normalization involves arranging attributes in relations based on dependencies between attributes, ensuring that the dependencies are properly enforced by database integrity constraints. Normalization is accomplished by applying some formal rules either by a process of synthesis or decomposition. (Wikipedia)

That's consolidation or more commonly referred to as an Access query with simple joined tables

Here is SQL for an a sample query which gets data from two joined tables: (based on the fields you named)

SELECT EmployeeDataTable.*, BookDataTable.*
FROM EmployeeDataTable 
INNER JOIN BookDataTable 
ON EmployeeDataTable .ID = BookDataTable.ID;

Queries don't get much simpler than that.

Is this a one-time merging of data or will you need to continually import data from Excel? That might change the steps slightly, but either way it sounds like you'll need to find some beginner's tutorials for Access. (There are plenty on YouTube that are great for beginners.)

Before anything, you'll need to get the data into Access. Simple and self-explanatory if, in your Access database, you click the External Data tab and then New Data Source then From File and Excel.

Upvotes: 1

Related Questions