Ms Access 2010 tutorial:form


Form

I. What is form?

Form is a database object in Microsoft Access that can be used to create an interface (front end) for a database application in order to help users to display, enter, update, delete or search data easily. You can create a form by using bound form or unbound form. A bound form is a form that connects to a data source directly while an unbound form does not connect to the data source. The underlying data source that the form connects to can be a table or query.

The bound form can be used to display, enter, edit or find data in the underlying data source without caring about writing code to make these form's actions operate. However, the unbound form contains only controls such as labels, text boxes, command buttons, or other controls that do not work. Those controls need you to apply code to perform actions.

You can use a bound form to control access to data also. For instance, a user wants to display only a few fields in a table. Moreover, you can use a bound form to set a rule and display a message when the form performs against the rule, and does other works. But the ability of the bound form still limited if it is compared to unbound form.

An unbound form can meet your need because you can command it to do what you need. If you create an unbound form, you must apply code to make the form perform actions. So you must have knowledge with VBA code.


Comments




This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.