Exam 8: Access

_____ is a set of Access rules that governs data entry and helps ensure data accuracy.

You can use a function created in a standard module in any query in the database.

In Form view, how can you navigate to the previous record in the form?

What is the result of selecting a text box in Report Design view and then clicking the Center button on the Home tab?

Which of the following can you define in Table Datasheet view? Select all the options that apply.

Which of the following statements accurately describe null field values? Select all the options that apply.

If you delete the text box for the State field on a report, Access removes _____.

In a Date/Time field named HireDate, the validation rule expression >#7/1/21# means _____.

You switch to Report Layout view to display the entire report as it will appear when printed.

Changing the _____ property for a field does not change the actual data stored in the field.

Which of the following fields are good candidates for a single-value lookup field? Select all the options that apply.

If users must enter text in a LastName field, you can set the _____ property for the field in Table Datasheet view.

If most records will contain "NY" in the State field, enter _____ as the _____ property for the State field.

When you create an option group on a form, you enter the Option Value property for each option button.

Which process is most like copying and pasting?

Why is it easy to import XML data into an Access table?

The Recordset Type property determines whether Access locks or allows updates to records displayed by a query.

If a blank column of controls appears next to a column of fields in a control layout, you can _____ the columns to create a single column.

To create a _____, you add the Total row to the query design grid to specify how to group and perform calculations on the records.

What happens if you apply the Currency format to a Number field?