Exam 8: Access

You can right-click the status bar to display the _____.

A command button in a report typically appears in the _____ section.

To modify the number of items displayed in a combo box, use the List Rows property.

Sorting records in ascending order based on a Short Text field arranges them in alphabetic order from Z to A.

A function created in a standard module can be used in any query in the database.

You can right-click a macro in the Navigation Pane to copy and paste it to create a backup.

When working in Table Datasheet view, which button on the Table Tools Fields tab can you use to change the expression in a calculated field?

AutoType is a data type that numbers each record automatically.

Access sets the number of decimal places in a Number field, and you cannot change it.

If you create a blank form, you must set the _____ property to display data on the form.

Using the Report Wizard, you can select the _____ for the report.

If you add Is Null as the criterion for the Advisor field in the Students table, what are the results?

You can create a mail merge in Word using name and address data stored in Access.

Which of the following describe Access reports? Select all the options that apply .

When does Access save changes you make to a record?

The Enabled property specifies whether you can edit a control in Form view.

Which of the following layouts can you use to arrange form controls?

If you want Access to create a top-to-bottom and left-to-right tab order, click _____ in the Tab Order dialog box.

The _____ property indicates which field serves the link between the main form and subform.

A SharePoint list is a collection of data that you can share with other people who use the SharePoint site.