How to Create a Form in DBMS
Database management systems (DBMS), like Microsoft Access, Oracle and SQL Server, provide a standardized format for storing, using and retrieving data. Once the database designer has created the underlying tables and built custom queries, all users need do is run those queries and reports and get the information they need. Data entry is facilitated through the use of data entry forms. These data entry forms provide a simple interface operators can use to enter new records into the database as needed. Database designers create these forms to make it easy for others to use the database.
Other People Are Reading
Instructions
-
-
1
Log on to your computer and open your database program. Open the database for which you want to create the new form.
-
2
Open the table on which you want to base the form. Note the field names you want to include on the data entry form. If all of the fields are updatable by the user, you can include all the fields in the table when you build the form. Sometimes, however, the table contains static data that does not need to change. If that is the case, you do not need to include those fields on the form, since that data never changes.
-
-
3
Go to the forms section of the database window and choose the option to create a new form. The wording is slightly different depending on the database you are using. Just look for a "New" or "New Form" option on the screen.
-
4
Choose the wizard option to create your form based on the table you have chosen. The wizard is the fastest and easiest way to create the form. Scroll through each subsequent window to change the appearance and layout of the form as needed.
-
5
Click the "Save" button on the toolbar. Type a name for your new form, then close the form. Double-click the new form to open it and see it as a data entry operator would. Test the form by entering a few sample records into the database. Close the form and open the underlying table to make sure those records are present.
-
1
References
- Photo Credit Burke/Triolo Productions/Brand X Pictures/Getty Images
