Database Article written by Tanya Puntti - How to make database form Microsoft Access

How to make database form Microsoft Access

Database Forms - Microsoft Access

Yesterday we showed you how to make an Access database. Todays tutorial demonstrates how to make a database form. The main advantage of database forms, are that they allow you to easily add or delete customers (or products etc depending on your database content) from a user friendly form interface. In other words, a database form interacts with the database so the user doesn't need to know how to edit the actual database tables.

The picture below is an example of an Access database form:

Note: Before you begin the tutorial below, you will need to have a database already created so you can link your form buttons and text boxes. You cannot add a customer or product if you don't already have a database to which to add them.

To start the database form tutorial, press the go arrow.

Where to from here?

This is one of those rare times where Microsoft has created a very helpful tutorial on creating databse forms. It is recommended that you print out the whole tutorial and keep it close for future reference. I personally found it the most useful when first starting to build database applications.

Microsoft Access Tutorial

Other useful resources to learn from are free applications you can downloaded and experiment with. Note: You don't need to make any database tables before using these templates as they are already included.

http://office.microsoft.com/en-us/templates/CT101428241033.aspx

You may also be interested in our other Database Tutorials available at Hypergurl.