Databases Answers

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

Has columns and rows: ✔ tablequeryform report

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

Works like a dialog box: ✔ formquerytablereport

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

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

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

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?

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?

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