Exam 1: Access-2019

When you enter new records, you add them to the end of the datasheet.

To navigate to a record in a table, switch to Table Design view.

A(n) _____ is an individual step that a macro performs.

The lower pane of a split form displays a(n) datasheet view.

You can copy and paste any object in Access except for tables.

What property do you use to set the Graduated text box in a form to display "Yes" in each new record?

What property should you set to have the Department header section appear at the top of every printed page?

If you set the _____ property to Yes for the CustEmail field, that means users can enter two quotation marks ("") in the field to mean no entry.

You use the _____ control when you want to link two reports together in the same report.

When you delete a record containing an AutoNumber field, Access discards the value in the AutoNumber field and _____.

To navigate to the first record in a form, first switch to Form Design view.

A _____ allows you to arrange the fields of a record in any layout so a database user can quickly and easily find, enter, edit, and analyze data.

An Access query can be the _____ for a mail merge in Word.

How do you select a row in a control layout in Report Layout view?

The Display Control property of a _____ field is set to Combo Box by default.

What criterion should you use in the Bedrooms field to select records of houses for sale with exactly four bedrooms?

To add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane.

To share form data among two or more programs, export the form as a(n) _____ file.

You can use the Chart Wizard to add a chart to a form or query .

If you export a report as a PDF file, other people can edit the report.