Creating a Data Entry Form

Diving Line


If you need to print this page out, type your name in the box below.

Your Name : 


Information

There are a few methods you can use to create a data entry form in a database. The easiest way is to use the Form Wizard feature.

Click on the Create tab and then the Form Wizard button.

Databases


On this first screen in the wizard, you need to select the fields you want to include in your form.  Use the Databases button to add a single field to the form or the Databases button to add all the fields.

Databases


Most of the time, you will want to use all the fields in your form.  Sometimes you might want to miss out the ID field.

You can also include fields from more than one related table if you need to.  You might want to read through the tutorials on related tables by clicking on the button below.

Next  Related Tables


You can also create a form from a query which is useful for displaying data that has been sorted alphabetically or for showing the results of a search.  Click on the button below to read through the query tutorials.

Next  Database Queries


When you have added the fields you need to your form, click on the Databasesbutton.


Information

The next stage in the wizard will let you choose between four different layouts for your form.

Databases


Databases Columnar
Databases Tabular
Databases Justified


Select the layout you want to use for your form and click Databases.


Information

This is the final step in the wizard.  Give your form a useful and meaningful name and click Databases.

Databases


PrintIT  Print out this Page

Next  Using Data Entry Forms


Last modified: Wednesday, 18 November 2020, 1:08 PM