Creating a Data Entry Form

Diving Line

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

Your Name : 


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.


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.


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.


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


Databases Columnar
Databases Tabular
Databases Justified

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


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


PrintIT  Print out this Page

Next  Using Data Entry Forms

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