PLS 21 Lecture Notes - Lecture 6: Page Header, Doubleclick
Lab 6 Notes - OpenOffice Week 2
Forms and Reports
● Forms and reports are the main ways users interact with the database. They are specifically
designed to control what and how queries and tables are modified, and to design the arrangement and
formatting of information on screen or paper. For example, most of the web pages where you enter
information, log in, or search for information using terms that you type in are web versions of forms.
● Most likely, your official transcripts are reports, whereas your unofficial transcripts viewed
on the web are forms. Forms are not usually designed to be printed.
***REMEMBER TO SAVE TWICE***
Forms
● Forms are used to enter or display data on the screen.
● Labels are based off of the fields. Records are shown in text boxes.
● Two Views:
○ Form View (Double-click)
■ Navigate and Add Records
○ Design View (Right-click → Edit)
■ Edit the design and structure of the form
● Creating Form using Wizard
Forms and Reports-use wizard
○ Design View
■ Label Field (ABC with no border)
■ Text Box (ABC with border)
■ Header and Footer
Modify with form-opens form in design view
Do not use text box, use label field !!!!!
Reports
● Reports are used to display data on paper so you can obtain a physical copy of the data.
Similar to forms, reports are based on tables/queries.
●Meant to be printed, but forms are meant for online viewing
● REMEMBER: Forms are meant to be shown online, while Reports are meant to be
printed.
● Two Views:
○ Report View (Double-click)
○ Design View (Right-click → Edit)
limepig485 and 2 others unlocked
8
PLS 21 Full Course Notes
Verified Note
8 documents
Document Summary
Forms and reports are the main ways users interact with the database. Most likely, your official transcripts are reports, whereas your unofficial transcripts viewed. Forms and reports designed to control what and how queries and tables are modified, and to design the arrangement and formatting of information on screen or paper. For example, most of the web pages where you enter information, log in, or search for information using terms that you type in are web versions of forms. on the web are forms. Forms are not usually designed to be printed. Forms are used to enter or display data on the screen. Edit the design and structure of the form. Do not use text box, use label field !!!! Reports are used to display data on paper so you can obtain a physical copy of the data. Similar to forms, reports are based on tables/queries. Meant to be printed, but forms are meant for online viewing printed.