Friday, February 20, 2009

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

10 comments:

  1. I have this problem.assuming that i have a database that contain a list of names,and my problem is i want to display all the names into a list in my program and im using a listbox is it posible?or is there an easy way.thanks in advance.


    http://img262.imageshack.us/my.php?image=97555472.jpg

    ReplyDelete
  2. can you provide a example program that display a report?for example i have to print a playslip.

    ReplyDelete
  3. Sure! Why not just give a time for that.

    ReplyDelete
  4. Yes i can display all the record inside that database in my Listbox using vb6.0.

    ReplyDelete
  5. Actually i already posted vb6 program. complete registration program that can generate reports and ID.. you can download here.

    ReplyDelete
  6. Anyway i just figured it out how to display all the records on my databse using dataGrid after downloading your example prog.My Goal is to highlight a rows in datagrid and delete a row by pressing delete button.any help would be greatful..thanks in advance

    ReplyDelete
  7. hi guys.. how can i help?..

    ReplyDelete
  8. I'm an 3rd year student of BSIT here in Bicol..
    its nice here!i think i will visit this on Finals111hehehe

    ReplyDelete

 

blogger templates | Make Money Online