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.
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
 | Want to learn more about designing a website or improving an existing one? Subscribe to Website Design Tips today for free. |
Comments (2)
hi i have my website and i want to make member area i mean login system, but really i don't know how to make this system. I hear we need create database but i don't know how to make database which software need. I use ftp server and i don't know about my server how to know more detail about my host server because last time i maked feedback.php form but they don't accept my php form because old version so how to know which version use to my webserver.
Hello Ashok,
The best place to start would be to email your webhost and ask them what types of databases their servers support. For example, do they support SQL? If so, what version? Your webhost will also need to support PHP or similar language to interact with your database.
Yes, SQL and PHP can take time to learn. Therefore, you also need to ask yourself if you really need a database? Don't take someone elses word for it. Often when website owners think they need a database, in actual fact they don't. What type of information are you planning on storing in your database? You don't necessarily need a database for a feedback form to work. Instead of the feedback being stored on your server, it can be emailed to you. FormMail is a popular free cgi script that can be used for this if your host supports CGI. Many webhosts nowdays already have such a form installed for clients to use. So again, check with your host.
Kind Regards.
Tanya Puntti.
Posted by ashok | July 17, 2007 7:04 PM
Posted on July 17, 2007 19:04
can you please teach me how to make a database because I am on a programming course i just want to have an advance study of databasing.....will you please send me the instructions on my e-mail add????
Hello Ryan,
We have plans in the near future to add advanced database tutorials to the Hypergurl.com website. They will be more aimed towards those people wanting to create a database website, so keep watch for them.
Kind Regards.
Tanya.
Posted by ryan atutubo | February 4, 2008 1:42 AM
Posted on February 4, 2008 01:42