CIS160 Access Exam

The default value for a Short Text data type is ____ characters.

255

What is the maximum character length of a field name?

64

You are creating a query using the Query Design button. What happens when you double-click a table name in the Show Table dialog box?

A field list box for the table is added to the query.

When viewing a table in Datasheet view, what happens when you click the Delete button?

A message box appears asking you to confirm deletion of the record

As you type a formula directly into a property box, what feature displays suggested entries?

AutoComplete

_____ are used to control the behavior or interactivity of the field in database objects.

Field properties

Which of the following query wizards must be run using two tables?

Find Unmatched

New records can be added to an Access table in either Datasheet view or ____ view.

Form

To create a form using the Form tool, click the ____ button in the Forms group on the CREATE tab.

Form

To restrict the values in a Lookup table to just those values contained in the drop-down list, change the setting in the

Limit To List property box to Yes.

What numeric data type has a field length that will store whole numbers from -2,147,483,647 to 2,147,483,647?

Long Integer

The Find Duplicates Query Wizard button is found in the _____ on the Query Wizard button on the CREATE tab.

New Query dialog box

To change the format of a field from within the query design window, click the ____ button in the ____ group.

Property Sheet; Show/Hide

What default time interval does the crosstab query use to summarize the data?

Quarter

Which of the following dialog boxes appears after the Query Design button is clicked?

Show Table

On which tab will you find the button used to add fields to a table?

TABLE TOOLS DESIGN

A calculated control object in a form is created using the ____ button.

Text Box

You have a form open in Layout view. What happens when you click the Logo button?

The Insert Picture dialog box appears.

What happens when you clear the check box for a field in the design grid portion of the query design window?

The column is hidden in the query results datasheet.

What does it mean when a pencil icon appears in the record selector bar?

The record is being edited.

A form is composed of a series of objects referred to as

controls.

A(n) ____ query calculates an aggregate function in which field values are grouped by two fields

crosstab

A ____ is a collection of data that has been organized so that the data can be easily stored, sorted, extracted, and reported.

database

You select a column in a table and then click the Filter button. What is displayed in the filter list box?

each unique field value from the column

You are sorting a table by the contents of a field in ascending order. The records listed first will be those in which the field value is

empty.

A query is an Access object designed to

extract data from one or more tables.

Delete more than one field in a table by using this feature to select multiple fields and delete all of them in one operation.

field selector bar

When you create a query in Design view, you begin by providing two pieces of information: the table or query from which to extract records, and the

fields you wish to display in the query results datasheet.

A ____ is used to view only those records that meet the specified criteria.

filter

Which query can most quickly identify your loyal customers?

find duplicates

To move a report column in Layout view, position the pointer inside the selected column until the pointer displays as a ____ and then drag the column to the desired location.

four-headed move icon

Where is the Relationships button located?

in the Relationships group on the DATABASE TOOLS tab

Where will you find the Ascending button?

in the Sort & Filter group on the HOME tab

Where is the Microsoft Access Help button located?

in the upper right corner of the screen

To best fit a column in the query design grid, place your cursor at the right column boundary until it displays a ____, and then double-click.

left-and-right-pointing arrow

By default, Access prints a datasheet on

letter size paper in portrait orientation.

Which of the following types of queries is an example of an action query?

make-table

When working in query design mode, clicking the Shutter Bar Open/Close button

minimizes the Navigation pane.

When scrolling in the middle of an Access table, pressing the Tab key will move you to the

next field in the current record.

Access is called a relational database management system because of the relationships that can be established among

tables.

Which of the following would you not include when choosing fields that might contain duplicate values?

the primary key field

What do you choose in the first dialog box in the Find Unmatched Query Wizard?

the table or query whose records you want to view in the query results

What information do you supply in the first dialog box of the Find Duplicates Query Wizard?

the table or query you want to search for duplicate field values

Which of the following is not a component of an Access database?

worksheet

Which of these statements is true concerning mailing labels and Access 2013?

Use the Label Wizard in the Reports group to create mailing labels in Access 2013.

The two field properties associated with validating field entries are

Validation Rule and Validation Text

For a table containing a primary key field called DistID, which of the following statements would be true?

When a record is deleted from the table, the value in its DistID field will not be used again.

What happens when you open an Access 2013 database from outside a trusted location?

A security warning appears in the message bar

This property stores descriptive titles for fields and is useful if you abbreviate a field name or want to show spaces between words in a compound field name.

Caption

When Access calculates the Sum function in a query, it assigns a column heading beginning with SumOf. To create your own column heading, modify this property for the column.

Caption

Files in a database can become fragmented when records and objects have been deleted. What Access button helps remedy such a situation?

Compact & Repair Database

To compact a database, begin by clicking the

Compact & Repair Database button in the Info backstage area.

Which button can be used to remove extra spacing between rows in a report?

Control Padding

What is the keyboard shortcut for selecting all records in a table, query, report, or form?

Ctrl + A

Which of the following is not one of the lines that make up the design grid for a select query?

Database

When you click the Query Wizard button, you choose from four different types of Query Wizards. Which of the following is not one of them?

Delete Records Query Wizard

What should you do if you need to make structural changes to a table that has a relationship with another table?

Delete the relationship, make the changes, and then recreate the relationship.

Controls in this section of a report make up the body of the report.

Detail

Which of the following characteristics do the Memo, Date/Time, Currency, and Yes/No data types have in common?

There is no field size property available for them.

Which of the following statements regarding label controls is true?

They contain text not associated with an existing field in a table or query.

With a table in Design View, you can move a field by

clicking in the field selector bar and dragging the field to a new position.

What feature does Access 2013 use to apply font formatting options to values in a report that meet certain criteria?

conditional formatting

What appears just below the label to show you where the new control object will be placed?

a pink bar

You are using a form to view data in a table. Clicking the New button in the Records group on the HOME tab has this effect.

adds a new, blank record to the table

What does the Best Fit button in the Column Width dialog box do?

adjusts the width of the selected column to accommodate the longest entry

A one-to-one relationship between two tables is indicated by a

black join line with the number 1 at each end.

When a field in a table is deleted, it

cannot be undeleted with the Undo command.

When two tables are joined on each table's primary key field, the join is known as a ____ relationship.

one-to-one

When adding a calculation to a form, the Build button

opens the Expression Builder.

The dashed lines that appear on a report in Layout view represent

page breaks.

You drag a field from the Field List task pane onto your form. The position at which the field objects will be inserted is illustrated by a

pink bar.

In a datasheet that contains subdatasheets, the expand indicators contain this symbol.

plus sign (+)

A _____ holds data that uniquely identifies each record in the table.

primary key

In a one-to-many relationship, a common field is used to join tables. On the "one" side of the relationship, the field is called the ____, while on the "many" side of the relationship, it is called the ____.

primary key; foreign key

In an Access table, each row is one ____ in the table.

record

The first field you choose in the Crosstab Query Wizard becomes the

row heading.

In a table with a primary key field, how are records displayed by default?

sorted in ascending order by the primary key field values

When performing calculations in a query, field names used in the calculation are placed in

square brackets [ ].

Creating a new table in an Access database generally involves determining fields, assigning a data type to each field, designating the primary key, and naming the table. This process is referred to as defining the table

structure.

When two tables are joined, you can view the records of the related table from within the primary table datasheet by displaying a

subdatasheet.