Exam 16: Access: Presentation Development

Steven is working on a database that stores student data. He needs to find students majoring in either one of two majors. He is looking for students majoring in Economics. He also is looking for students majoring in History. Which operator would Steven use to find this information?

An operand is a mathematical symbol.

A text field may contain numbers, text, and special characters.

The ________ view of an Access table looks similar to an Excel spreadsheet.

The ________ data type is used for fields that will be used in mathematical calculations except those involving money.

The ________ view organizes and displays data in a summary view.

The ________ data type will automatically increment each time a new record is entered.

For fields containing social security numbers or dates, a(n) ________ can automatically provide characters such as hyphens or slashes.

When defining a field, the field ________ property determines how much physical storage space the field requires.

The result of a query, which appears similar to a table, is called a ________.

The ________ of a field determines the kind of content that can be entered or operations that can be performed on the field content.

The ________ field property changes how a field will appear when displayed or printed, but does not change the values stored in the field.

In most cases, it is advisable to enforce referential integrity in databases with related tables.

The ________ data type contains values that can be used in a calculation.

The ________ is a special character that is used to represent one or more characters in the criterion of a query.

The simple query wizard displays a series of dialog boxes that guide users through the query design process.

When designing a database, all of the following statements are true EXCEPT:

Which of the following statements is true about how Access and Excel share data:

The Collect Data group on the External Data Tab allows a user to import data into a database.

A field containing the AutoNumber data type must be manually incremented for each record entered.