Results 1 to 3 of 3
  1. #1
    monica is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2012
    Posts
    1

    Save datas in the table

    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.

  2. #2
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    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

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 11
    Last Post: 07-24-2012, 07:50 PM
  2. save record in 2 table
    By smahdih in forum Forms
    Replies: 2
    Last Post: 11-13-2011, 12:51 AM
  3. select datas where equal to the max
    By rbg in forum Queries
    Replies: 0
    Last Post: 03-28-2011, 12:38 PM
  4. Replies: 9
    Last Post: 01-20-2011, 02:22 PM
  5. Manipulating datas on access table
    By 3rdeye in forum Access
    Replies: 6
    Last Post: 10-12-2010, 02:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums