FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 13: Databases

Show Answer

Share

---

All types

Filters

Study Flashcards

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

JoAnn is a jewelry salesperson. She is assigning data types to various fields in her inventory database. Please answer the two questions below. -One of the fields in the Jewelry Inventory Database asks whether or not JoAnn has the customer's e-mail address or not. A reasonable data type for this field would be ____.

A) Yes/No
B) On/Off
C) Either/Or
D) Date/Time

E) A) and D)
F) All of the above

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

The order in which you select the fields will determine the order in which the information is displayed in the query results.

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

Danny is the new database administrator for a small pet supply business. Please answer the questions below. -Danny wants to create a database of all the pet food that they keep in inventory. He does NOT want to start the database from scratch. What would you recommend?

____ are specifications that allow you to customize the data type settings.

When you create a form, you are adding a new sort sequence to the database.

To sort, in ____ view, click the field name that you want sorted; the column is highlighted. Click the arrow to the right of the column name to display the shortcut menu. Select Sort A to Z or Sort Z to A.

Although you can produce a report manually, the ____, similar to the Query Wizard, provides an easy and fast way to design and create one.

Please identify the letter of the choice that best matches the numbered definitions below. -Stores a hyperlink to an URL, other document, or other object

Please identify the letter of the choice that best matches the numbered definitions below. -Used for more advanced features, such as storing or linking objects in a table

A ____ is a software program that is used to create, maintain, and provide controlled access to data.

In ____ view, Access displays a row-and-column view of the data in tables, forms, and queries.

In addition to adding and viewing records in Datasheet view, you also can create and use a data-entry ____________________, which provides a convenient way to enter and view records in a table.

The ____________________ Query Wizard displays data in a spreadsheet format.

Please identify the letter of the choice that best matches the numbered definitions below. -Numeric data used in mathematical calculations

A(n) ____ is a format used to display and work with various objects.

You can add a record by clicking in the last field of the last record and then pressing ____ or Enter.

Please identify the letter of the choice that best matches the numbered definitions below. -Used for alphanumeric data with more than 255 characters

In Report view you can create a table, form, query, and report. _________________________

____________________ is unorganized text, graphics, sound, or video.

The ____ Query Wizard locates records in one table that have no related records in another table.