![Page 1: Forms 5.02 Understand database queries, forms, and reports](https://reader036.vdocuments.us/reader036/viewer/2022082422/5697bfac1a28abf838c9b494/html5/thumbnails/1.jpg)
FormsForms
5.02 Understand database queries, forms, and reports.
![Page 2: Forms 5.02 Understand database queries, forms, and reports](https://reader036.vdocuments.us/reader036/viewer/2022082422/5697bfac1a28abf838c9b494/html5/thumbnails/2.jpg)
5.02 Understand database queries, forms, and reports used in business. Slide 2
FormsForms
• A database object that is used to create a user-friendly format for data entry and retrieval
• May include drop-down menus, instructions, navigational controls, and graphics
![Page 3: Forms 5.02 Understand database queries, forms, and reports](https://reader036.vdocuments.us/reader036/viewer/2022082422/5697bfac1a28abf838c9b494/html5/thumbnails/3.jpg)
UsesUses
• Online reservations for hotels, flights
• Entering contact and billing information online
• Electronic card catalog in the media center
5.02 Understand database queries, forms, and reports used in business. Slide 3
![Page 4: Forms 5.02 Understand database queries, forms, and reports](https://reader036.vdocuments.us/reader036/viewer/2022082422/5697bfac1a28abf838c9b494/html5/thumbnails/4.jpg)
5.02 Understand database queries, forms, and reports used in business. Slide 4
AdvantagesAdvantages of Forms of Forms
• Searching for information is faster
• Data entry is faster
• Easy to read and understand
• Allow information to be censored
– For example, a hotel reservation form posted on the web may allow users to select a type of room and the arrival and departure dates, but prevent or hide users from viewing the details of the hotel rates.
![Page 5: Forms 5.02 Understand database queries, forms, and reports](https://reader036.vdocuments.us/reader036/viewer/2022082422/5697bfac1a28abf838c9b494/html5/thumbnails/5.jpg)
5.02 Understand database queries, forms, and reports used in business. Slide 5
Common Elements of FormsCommon Elements of Forms • Graphics – lines, shapes, images• Data – content from records in the database• Calculations – forms can contain formulas that perform
calculations, similar to those written for spreadsheets – Ex.: Calculations such as totaling the price of a purchase order by
multiplying the quantity ordered by the price of a product
• Controls – define how data can be entered, viewed, or used in calculations
• Descriptive text – help text and hints for users• Subforms – forms embedded in and connected to a main form
through a common field.– Ex.: A grocery store form contains the customer name & contact info. on
the main form which is linked by the customer's ID no. to a subform. The subform contains the customers purchase orders
![Page 6: Forms 5.02 Understand database queries, forms, and reports](https://reader036.vdocuments.us/reader036/viewer/2022082422/5697bfac1a28abf838c9b494/html5/thumbnails/6.jpg)