Save datas in the table

[monica]

I am a fresher. I have a created a student form with two textboxes(txtName,txtRegNo) & a Save Button.If i click save button the datas entered should save in the student table.How to do this? I need a detail explanation.If possible any video link is there it will be more helpful.

[alansidman]

Are you using a bound form or an unbound form for data entry? If your form is bound, then you do not need to use a save button as Access will automatically save the record to your bound table. If however, you are using unbound forms, then go to this web site

http://www.datapigtechnologies.com/AccessMain.htm

and look at the video on updating tables from unbound forms.

Alan

[orange]

Further to Alan's advice, I would recommend you follow up with some research of database concepts such as Normalization, Data modeling and entity relationship diagramming.

Here are a number of free video tutorials related to database design concepts.

These free video tutorials describe the processes of data modelling, normalization and entity relationship diagramming. There are other videos, but this group is by the same presenter and covers an example situation.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

http://www.youtube.com/watch?v=lXAGQ8vmhCY ERD Part 2

The first few topics at this site are well worth the read.

http://www.rogersaccesslibrary.com/forum/topic238.html

Good luck with your project.