If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form Tutorial
Any links to a good tutorial around writing forms that the inputted data will
then dump into a table for analysis??? Thanks |
#2
|
|||
|
|||
Form Tutorial
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...ml/ch04DDP.asp http://www.eade.com/AccessSIG/downloads.htm (See the last download titled "Understanding Normalization") Support WebCast: Database Normalization Basics http://support.microsoft.com/default...lurb060600.asp Database Normalization Tips by Luke Chung http://www.fmsinc.com/tpapers/genacc...abasenorm.html Sprinks "Andy" wrote: Any links to a good tutorial around writing forms that the inputted data will then dump into a table for analysis??? Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Search facility | tezza | General Discussion | 13 | February 18th, 2010 12:26 AM |
Move feild entries from form to form using global variables | JackCGW | General Discussion | 11 | November 14th, 2005 05:22 AM |
Need Help In Printing Current Record in Specific Report | RNUSZ@OKDPS | Setting Up & Running Reports | 1 | May 16th, 2005 09:06 PM |
Dates in a listbox connected to a form... | RusCat | Using Forms | 13 | November 25th, 2004 02:31 AM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |