Question

What is form and it's uses????

Answer 1

$<b><marquee behavior ="alternate">ANSWER:</marquee></b>$

A form is an acess object that allows the user to add an update data in one record at a time in a table.

Although access provides a datasheet view which is convenient way of entering data but it is not appropriate tool for every data entry situation.

Sometimes, when you work with different users and do not to escape to the inner working of access you may choose to use access form to create better user friendly experience.

Answer 2

Techopedia explains Form

Databases like SQL and Oracle do not use built-in forms, employing the query option for data creation and manipulation instead. This makes querying knowledge essential to handling these databases. Microsoft Access, however, uses forms for data entry, making it more user friendly than its counterparts. The fields and field labels are organized in a logical manner for easy form access and manipulation.

While making an entry into fields of a form, it is important to be careful about the field types, which are generally set when the form is created. As such, an attempt to enter values that do not satisfy the field constraints will fail. For instance, a field with a field type "not null" does not take null values and cannot be left blank. Some fields may also have table relationships connected by a foreign key; any alteration of such a field in a form needs special care.

Some online databases also have built-in form templates included in them. These databases can easily be used by users who are not even aware of scripting, as all entries and changes can be made in the form by a single click. A user is also free to customize the form layout by selecting suitable form templates.