| A | B |
|---|
| The insurance company has an online database that allows customers to file claims. Customers who log into the site must enter their name and policy number first. Next, they enter the date of the claim, type of claim, type of injury, property damage, and claim amount. This is an example of a: | form |
| Dax performed a search for counties with populations greater than 25,000 from one table in a database and states with populations less than 225,000 from another table in the same database. This search is an example of a: | query |
| Drake is a pharmacist at Walgreens. Walgreens keeps all customer information in a database. He is often asked by customers for a detailed summary of all medications purchased during a fiscal year. This summary is an example of a: | report |
| To calculate the total price for each calendar, Babs pulls paper and ink costs from the supplies table and duplicating and shipping costs from the production table. She then saves the information. This save search is an example of a: | query |
| Doug is searching an online database to find out how many U.S. presidents were Republicans. He does not intend to save his search. This search is an example of a: | filter |
| Dave is a salesman at CarMax. He searched the CarMax database for BMWs and printed a list of available cars for a client. This search is an example of a: | filter |
| Dino is searching the online Headhunter database for job postings. He prints out the job listings for all chef positions in the Chicago area. This search is an example of a: | filter |
| Dottie gave her students a test about database concepts and functions. She arranges the database of student grades so that only students who made an 85 or higher are displayed. This is an example of a: | filter |
| Dolly is the webmaster for a wholesale cosmetics company that sells products online. Which database object should she create that will allow customers to select products and input shipping instructions? | form |
| Denzel is an accountant for an insurance company. He printed a summary of claims filed for the year that is grouped by claim amount. This summary is an example of a: | report |
| The Blockbuster database consists of drop down lists that allow customers to search for actors by movie title, leading role, last name, and release date. This temporary search is an example of a: | filter |
| Dillon created a temporary alphabetized list of junior and senior FBLA members from the School Clubs database. This search is an example of a: | filter |
| Jed searched his database for the number of lawn mowers in stock. This is an example of a: | filter |
| SCENARIO 20: Babs sells personalized calendars. Customers email pictures, dates of special occasions, and themes they want included in their calendars. Once Babs has all of their information, she emails a sample calendar to the customer for approval. In Scenario 20, to advertise her company, Babs sends discount coupons to all customers who make referrals. She uses a Yes/No field in the Customers Table to track the referrals. When month’s end arrives, she searches for all “Yes” entries and prints the temporary list. This is an example of a: | filter |
| SCENARIO 20: Babs sells personalized calendars. Customers email pictures, dates of special occasions, and themes they want included in their calendars. Once Babs has all of their information, she emails a sample calendar to the customer for approval. In Scenario 20, Babs only accepts payment through her secure website. Customers are required to enter their name, address, and credit card information before final production of the calendars can begin. The object the customers use is an example of a: | form |
| SCENARIO 20: Babs sells personalized calendars. Customers email pictures, dates of special occasions, and themes they want included in their calendars. Once Babs has all of their information, she emails a sample calendar to the customer for approval. In Scenario 20, when customers request graphics and images related to a specific theme, Babs searches her image database for related objects and selects from the results. This search is an example of a: | filter |
| SCENARIO 20: Babs sells personalized calendars. Customers email pictures, dates of special occasions, and themes they want included in their calendars. Once Babs has all of their information, she emails a sample calendar to the customer for approval. In Scenario 20, Bab’s customers must visit her website and select color schemes, font schemes, and paper sizes for their calendars. The object the customers use is an example of a: | form |
| SCENARIO 20: Babs sells personalized calendars. Customers email pictures, dates of special occasions, and themes they want included in their calendars. Once Babs has all of their information, she emails a sample calendar to the customer for approval. In Scenario 20, when Babs prepares her taxes, she prints a year-end summary of expenses and receipts. This is an example of a: | report |
| SCENARIO 18: Jed is starting a landscaping business. He keeps track of customers, employees, suppliers, equipment, and labor costs in separate tables within a database. In Scenario 18, Jed’s customers can access his webpage to calculate estimates for landscaping services. To do so, they must enter the square yards, the type of service requested, and select the brand of lawn treatment products. The object used | form |
| SCENARIO 18: Jed is starting a landscaping business. He keeps track of customers, employees, suppliers, equipment, and labor costs in separate tables within a database. In Scenario 18, each week Jed prepares the payroll summary. He uses data from each table in his database to print a list of all employees, the amount paid to each, and the number of hours worked. The list is sorted in alphabetical order by employee last names. This summary is an example of a: | report |
| SCENARIO 18: Jed is starting a landscaping business. He keeps track of customers, employees, suppliers, equipment, and labor costs in separate tables within a database. In Scenario 18, Jed prepared a quote for a customer by pulling specific information from each table. The act of pulling data from the tables is an example of a: | query |
| SCENARIO 19: Jane operates a dog grooming business. She keeps track of customers, employees, suppliers, equipment, and labor costs in separate tables within a database. In Scenario 19, each week Jane prepares the payroll summary. She pulls information from each table and prints a list of all employees, the amount paid to each, and the number of hours worked. This summary is an example of a: | report |
| SCENARIO 19: Jane operates a dog grooming business. She keeps track of customers, employees, suppliers, equipment, and labor costs in separate tables within a database.In Scenario 19, Jane prepared a quote for a customer by pulling specific information from each table. Pulling the information from each table is an example of a: | query |
