ALERT

[FREE DEMO] Deploy Your Enterprise Cloud in Minutes

Form

Definition - What does Form mean?

In a database context, a form is a window or screen that contains numerous fields, or spaces to enter data. Each field holds a field label so that any user who views the form gets an idea of its contents. A form is more user friendly than generating queries to create tables and insert data into fields.

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 and data entry into forms, 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.

This definition was written in the context of Databases

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
Tweat cdn.techopedia.com
"Techopedia" on Twitter


'@Techopedia'
Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Resources
The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.