Databases Answers

Use the drop-down menus to match each description to the correct term.Has records and fields: ✔ tablequeryform report

You have a database with three tables: one each for products, suppliers, and distributors. You need to locate the product ID number for hammers and find out who supplies them. Which database component would perform this task?

You have searched a database to locate US cities with population counts above 1 million people. You need to present the results to the class. Which of these describes the process you should use to accomplish these tasks?

Use the drop-down menus to match each description to the correct type of form.A form appears after opening a database, asking if you would like to view the fruits table, vegetables table, or nutrition report: boundhierarchicalcustom dialog box✔ switchboard

Read the scenario below, and then answer the questions that follow.You have a part-time job where you are responsible for maintaining a database for a charity. One database table contains the names of volunteers. Another table contains names of volunteers who have signed up to help at an upcoming event.Which query would you use to find out who is volunteering on Saturday at 10 a.m.? ✔ selectduplicateunmatched

You are creating a query for a website. The query is supposed to ask users to choose which category of news they would like to receive in weekly e-mail updates. Which query should you use?

You need to create a basic report from a query. The report will contain a list of employees in the human resources division. Which report should you use?

Has columns and rows: ✔ tablequeryform report

An administrative assistant is responsible for scheduling appointments at a doctor’s office. Which component would allow the administrative assistant to enter each patient’s name, date of birth, doctor’s name, and appointment date and time?

You need to present your observations from a chemistry experiment to the class. Which database feature should you use so that your presentation is organized and easy to view?

Student test scores entered into a database: unbound✔ data-entrycustom dialog boxnavigation

Your supervisor asks you to record the names of the volunteers who have not been scheduled for the upcoming event. Which query would allow you to complete this task? selectduplicate✔ unmatched

You work for a retail clothing store. You have been asked to create a table of items that are on 50 percent clearance. Which query should you run to accomplish this task?

A dictionary writer needs to organize words in alphabetical order. Which report should the writer use?

Enables a user to interact with a database without working directly with data: ✔ formtablereportdatasheet

A window appears before closing out of a database, asking you to save your work before exiting: ✔ switchboarddata-entrycustom dialog boxnavigation

Your supervisor asks you to find out which volunteer is scheduled because three volunteers have the same first name. Which query should you use? select✔ duplicateunmatched

Works like a dialog box: ✔ formquerytablereport

A basic form to input names, addresses, phone numbers, and e-mail addresses: ✔ flathierarchicalsynchronizednavigation

An interface that makes it easier for inputting data into a database: ✔ formtablereportquery

A suppliers form that contains a products form and a price form that pops up when you click on the Prices button: flatswitchboardhierarchical✔ synchronized

Enables you to search several tables for data: formtablereport✔ query

A form used as the basis of many websites because of its top-level organization system: boundflatswitchboard✔ navigation

A form that has replaced the outdated switchboards: ✔ navigationflatsynchronizeddata-entry