Using forms to create and edit a database in MS Access
Large table rows are awkward to work with, so a form is used for entering and viewing data: it shows one record field by field. The quick way: select the table and press Create – Form; for more control, in Form Wizard you choose the fields, layout and name. At the bottom of the form are navigation buttons (first, previous, next, last, new record) and a counter such as “3 of 8”; a value entered or changed in the form is written to the table at once. A report (Create – Report or Report Wizard) is meant for putting data on paper: it can group and sort but values cannot be edited in it. Before printing, look at the page in Print Preview and print only the pages you need, and do not hand personal data to strangers.
At a school contest a judge types each participant’s score into an entry screen that shows one record at a time. At the end a printed report grouped by category is made from the same data. A form is handy for entering, and a report for reading and printing.
Data-entry staff and cashiers work in forms, while managers read the finished reports.
Draw one card for an invented plant in the school garden with “name, height, date measured”, then use 4 such cards to make a one-page list (a report).
“Form and report”: a pair makes a form and a report from its own table, changes one record in the form and checks that the change shows in the report.