Filters
Question type

Study Flashcards

Use the New (blank) record button to move the focus to the first record in a table.

Correct Answer

verifed

verified

If the Navigation Pane is not open, click the _____ to open it and view the database objects.


A) Shutter Bar Open/Close button
B) Expand button
C) View tab
D) Navigation bar

Correct Answer

verifed

verified

A field with the Currency data type contains values such as quantities, measurements, and scores.

Correct Answer

verifed

verified

Which Short Text field property should you use to indicate users must enter a value in the field?


A) Default
B) Required
C) Validation Rule
D) Yes/No

Correct Answer

verifed

verified

To insert a page break in a report in Report Design view, click a section, and then press the CTRL+ENTER keys.

Correct Answer

verifed

verified

To delete an action from a macro, point to the action in Macro Design View, and then click the Delete button. ​

Correct Answer

verifed

verified

To back up a database, you use the _____ command.


A) Make a Backup
B) Back Up Database
C) Package and Sign
D) Compact & Repair

Correct Answer

verifed

verified

To set a validation rule in the Employees table specifying that the DateHired field value must be greater than the DateBorn field value, you set the Validation Rule property for the _____.


A) DateHired field
B) Employees table
C) DateBorn field
D) database

Correct Answer

verifed

verified

When you apply the Currency format to a field, Access displays a currency symbol and two values after the decimal point, but it does not change the field's data type.

Correct Answer

verifed

verified

When you resize a label in Form Design view, _____.


A) you do not see the changes until you switch to Form view
B) you disconnect the label from its text box
C) you resize the label in all the other views
D) you do not have to save the design change

Correct Answer

verifed

verified

A group of related fields, such as all the demographic information for one customer, is called a _____.


A) table
B) record
C) query
D) field

Correct Answer

verifed

verified

Access adds @ signs around date criteria in Date/Time fields.

Correct Answer

verifed

verified

Which of the following are properties you can set for a Short Text field in Table Datasheet view? Select all the options that apply.


A) Name
B) Append Only
C) Required
D) Field Size

Correct Answer

verifed

verified

A common place to use the Input Mask property is for a FirstName field.

Correct Answer

verifed

verified

Before you can edit actions in Macro Design View, you might need to click the Expand All button on the Macro Tools Design tab to display all the actions.

Correct Answer

verifed

verified

What are you doing when you enter data into a subdatasheet?


A) You are entering properties for the fields.
B) You are creating an alternate view of the data.
C) You are enforcing referential integrity.
D) You are entering records in the related table.

Correct Answer

verifed

verified

You cannot set the Field Size property for Short Text fields in Table Datasheet view.

Correct Answer

verifed

verified

You can create a comment by starting the statement with _____.


A) dim
B) com
C) rem
D) ignore

Correct Answer

verifed

verified

You can use the Format property to display dates in a report using a Short Date format.

Correct Answer

verifed

verified

A _____ is a grid that displays fields as columns and records as rows.


A) query
B) datasheet
C) logical table
D) report

Correct Answer

verifed

verified

Showing 541 - 560 of 652

Related Exams

Show Answer