Database normalization of Student information using Microsoft Access with Data manipulation

Sample data normalization, data manipulation and one to one relationshipships using Microsoft Access.

In this image it shows on how to relate its field using there control field instead we put there description of the Course and Gender since we are doing normalization then we will use the control of each element or data in the table.















In this image it shows all the data under Male and Female student inside tblStudentInfo.








In this image it shows all the data with there corresponding course under tblCourse. Data inside tblStudentInfo.
















You can download my example below.


Download File

Database normalization of Student information using Microsoft Access

Simple database normalization of Student information that contains name, address, Age, Course, Gender it shows on how to normalize a database using one to one relationship using Microsoft Access. tblCourse and tblGender are the looked up table of tblStudentInfo. You can download this sample below.. thank you so much.
































You can download my example below.


Download File