Creating a Simple Data Entry Form

From NeoWiki

Revision as of 19:28, 15 September 2007 (edit) Jgd (Talk | contribs) (botlangbar -> Fr page) ← Previous diff		Revision as of 02:07, 19 September 2007 (edit) (undo) Lorinda (Talk | contribs) (correct formatting so numbering is consistent) Next diff →
Line 6:		Line 6:
	#In the {{Section|Database}} column of the main database document window, click on {{prefName|Forms}}		#In the {{Section|Database}} column of the main database document window, click on {{prefName|Forms}}
	#In the {{Section|Tasks}} section, click on {{prefName|Use Wizard to Create form...}}		#In the {{Section|Tasks}} section, click on {{prefName|Use Wizard to Create form...}}
-	-->''The {{Window|Form Wizard}} window appears	+	#:-->''The {{Window|Form Wizard}} window appears
	#In the {{prefName|Tables or Queries}} drop down, select '''Table: Locations'''		#In the {{prefName|Tables or Queries}} drop down, select '''Table: Locations'''
	#Since we want all the fields to appear, click on the {{Button|>>}} button		#Since we want all the fields to appear, click on the {{Button|>>}} button
-	''-->All the fields appear in the {{Section|Fields in the Form}} column	+	#:''-->All the fields appear in the {{Section|Fields in the Form}} column
-	:Note: If you wanted only certain fields on the form, you would select the fields in the {{Section|Available Fields}} collumn and then click the {{button|>}} button.	+	#:Note: If you wanted only certain fields on the form, you would select the fields in the {{Section|Available Fields}} collumn and then click the {{button|>}} button.
	#Click {{Button|Next>}}		#Click {{Button|Next>}}
	#We don't need a subform for this form, so click {{Button|Next>}} again.		#We don't need a subform for this form, so click {{Button|Next>}} again.
Line 23:		Line 23:
	#Choose to either {{prefName|work with the form}} (to begin data entry) or {{prefName|Modify the form}} (to alter the form layout.)		#Choose to either {{prefName|work with the form}} (to begin data entry) or {{prefName|Modify the form}} (to alter the form layout.)
	#Click {{Button|Finish}}		#Click {{Button|Finish}}
-	''-->The {{Window|Form Wizard}} window will disappear. It will appear as though Neo has hung, but be patient. In a few seconds, the new form will appear .	+	#:''-->The {{Window|Form Wizard}} window will disappear. It will appear as though Neo has hung, but be patient. In a few seconds, the new form will appear .
	{{botlangbarEN|[[Fr:Créer un Formulaire Simple|Français]]}}		{{botlangbarEN|[[Fr:Créer un Formulaire Simple|Français]]}}

---

Revision as of 02:07, 19 September 2007

While data can be entered directly into the tables, it is often much easier to use a form. Here we will make a Locations Data Entry form, to enter information on different locations visited by the birdwatcher using the database.

1. Open the database document
2. In the Database column of the main database document window, click on Forms
3. In the Tasks section, click on Use Wizard to Create form...

   -->The Form Wizard window appears

4. In the Tables or Queries drop down, select Table: Locations
5. Since we want all the fields to appear, click on the >> button

   -->All the fields appear in the Fields in the Form column

   Note: If you wanted only certain fields on the form, you would select the fields in the Available Fields collumn and then click the > button.

6. Click Next>
7. We don't need a subform for this form, so click Next> again.
8. Choose an arrangement in the Arrangement of Main Form. I opted for the farthest right arrangement, described as In Blocks - Labels Above
9. Click Next>
10. Choose a data entry mode. I opted for The form is to display all data.
11. Leave all the check boxes unchecked, unless you want those restrictions
12. Click Next>
13. Select the Background color and effects you desire
14. Click Next>
15. Enter a name for the Form. I chose Locations Data Entry
16. Choose to either work with the form (to begin data entry) or Modify the form (to alter the form layout.)
17. Click Finish

    -->The Form Wizard window will disappear. It will appear as though Neo has hung, but be patient. In a few seconds, the new form will appear .