Exam 8: Access

Which of the following types of files can Access create when it exports data to the XML file format? Select all the options that apply .

In SQL view, a select query starts with the SQL keyword _____.

The common field between two tables in a one-to-many relationship is the primary key field on the "one" side of the relationship and the _____ on the "many" side of the relationship.

An aggregate function is _____.

For a field that contains more than 256 characters of comments or notes, use the _____ data type.

Which of the following form controls can you format by applying a style to it?

Which of the following is the SQL keyword to identify tables containing the field(s) you are selecting?

You can _____ an Access database into a back-end database and front-end database.

What kind of criteria would you use to find records with no OrderDate values?

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

After you create a table, you must save the entire database so you do not lose the new table.

When you click the Blank Report button on the Create tab, Access opens a blank report in _____.

On a form, text box controls display data from an underlying record source.

The _____ button creates a new, blank report in Report Design view.

If you move the City column in a table datasheet, _____.

The outer join is the default join operation in Access.

Add a Number field to a table to store values that represent money.

Field _____ are the characteristics that describe each field, including Field Name and Data Type.

When you enter data in the rows of a table datasheet, you are entering _____.

To remove scroll bars on small forms, set the Scroll Bars property to As Needed.