Exam 13: Databases

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

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

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

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

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

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.

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

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

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.

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 ____.

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

The ____________________ Query Wizard displays data in a spreadsheet format.

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

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

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?

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

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

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