Form Tutorial

[Guest]

Any links to a good tutorial around writing forms that the inputted data will
then dump into a table for analysis???

Thanks

 

[Guest]

The following link will get you started, as will any good Access reference
book.

Microsoft Access 2000: Building Applications with Forms and Reports
http://tinyurl.com/2szmm

A form is basically a window into a table or query. If the form has a
non-null RecordSource property, then it is Bound to the source, otherwise is
is Unbound. Controls on the form (textboxes, combo boxes, checkboxes, etc.)
that have a non-null ControlSource property are Bound to a field in the
RecordSource, which means that data entered into them is saved to the field.

The simplest way to create a form is using the Form Wizard, which will guide
you through the creation of the basic form, afterwhich you may edit it to
suit your needs.

Much more critical than form creation, however, is the design of the tables
in your application, specifically, database normalization. Well-normalized
tables will make the application straightforward to design. See the
following sources for information:


ACC: Database Normalization Basics
http://support.microsoft.com/?id=100139
http://support.microsoft.com/?id=209534
http://support.microsoft.com/?id=283878

"Understanding Relational Database Design" Document Available in Download
Center:
http://support.microsoft.com/?id=283698
http://support.microsoft.com/?id=164172

ACC2000: "Understanding Relational Database Design"
http://support.microsoft.com/?id=234208

Fundamentals of Relational Database Design:
http://support.microsoft.com/?id=129519

Database Deisgn Principles:
http://msdn.microsoft.com/library/en-us/dndbdes/html/ch04DDP.asp

http://www.eade.com/AccessSIG/downloads.htm
(See the last download titled "Understanding Normalization")

Support WebCast: Database Normalization Basic
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc060600/wcblurb060600.asp

Database Normalization Tips by Luke Chung
http://www.fmsinc.com/tpapers/genaccess/databasenorm.html

Sprinks