Ch 12: Forms and Reports
Forms
Form: a database object with a user-friendly interface to enter and view data — the front end for data entry and modification.
A field control has two parts: a label (describing text) and a field value text box (linked to the table field). Two ways to create: Wizard or Design View.
- Tool-tip: Control Properties > Help Text (shown on hover).
- Calendar for date: Date Format = Standard, DropDown = Yes.
Reports
Report: presents retrieved data in a formatted manner. It can be based on a table, a query, or both.
Static vs Dynamic: a dynamic report updates automatically when the table/query changes; a static report does not.
Summary
- Form = front end for data entry (label + value box).
- Report = formatted output from a table/query/both.
- Dynamic report updates automatically; static does not.
Forms
Form: user-friendly interface वाला database object जिसमें data enter और view होता है — data entry का front end।
Field control के दो हिस्से: label (वर्णनात्मक text) और field value text box (table field से जुड़ा)। बनाने के दो तरीके: Wizard या Design View।
- Tool-tip: Control Properties > Help Text (hover पर दिखता है)।
- Date के लिए Calendar: Date Format = Standard, DropDown = Yes।
Reports
Report: निकाले गए data को formatted रूप में दिखाता है। यह table, query या दोनों पर आधारित हो सकता है।
Static vs Dynamic: dynamic report table/query बदलने पर अपने आप update होता है; static नहीं होता।
सारांश
- Form = data entry का front end (label + value box)।
- Report = table/query/दोनों से formatted output।
- Dynamic report अपने आप update; static नहीं।
Frequently Asked Questions
What is the difference between a form and a report?
A form is the front end used to enter and modify data, while a report presents retrieved data in a formatted manner.
What is the difference between a static and dynamic report?
A dynamic report updates automatically when the underlying table or query changes; a static report does not.