14 min read

What Is a Form, and Why Use One?

A form is a custom-designed window for entering data, one record at a time — the friendly face most people interact with day to day.

You will learn: what a form is and how RecordSource works. You will do: compare a datasheet to a form. see how a form reads Members.

What Is a Form?

A table datasheet shows every row in a grid. A form is a screen layout for one record at a time . The form's RecordSource tells Access which table or query to read. For member entry, RecordSource is Members . Change the record source and the same layout can show different data — for example a query that lists only London members.

Datasheet vs form

$Members datasheet$	$Members form$
$Many rows visible — easy to scroll past the wrong line$	$One member on screen$
$Click to Add can create stray columns$	$Layout shows only the fields you placed$
$Fine for scanning many rows$	$Fine for calm data entry at the desk$

Members · Form View

MemberIDFull nameCityPhone

Record 1 of 6 · This screen writes into the Members table.

Record 1 of 5 at the bottom. The form reads Members — it is not a second table.

When you type a new member on the form and move to the next record, Access writes a new row in Members. Queries that read Members see the new row too. The form is a window onto stored data.

Practice

Swipe or use the arrows to move between questions.

1 / 2

You edit Sophie's phone on MembersForm. Where is the new number stored?

Which jobs suit a form at the desk?

Select every task that fits a form.

A form is a custom-designed window for viewing and entering data, typically showing one record at a time, with fields arranged clearly, labeled in plain language, and often enhanced with dropdown lists, checkboxes, and buttons. Forms are what most people who use a finished database actually interact with day to day — they may never even see a raw table. Forms offer real advantages beyond appearance: they restrict what can be typed into each field far more precisely than a plain table, they can combine data from multiple related tables onto one convenient screen using subforms, and they can include buttons that run useful actions, like saving a record or opening a related report.