Exam 1: Access 2019

To resize a control in Report Layout view, you format an edge of the selected control.

Before closing a form in Form view, you must save changes you made to the data.

You can make formatting changes to a table, such as font color and font size, in Table Design view.

What must you do before renaming a table in the Navigation Pane?

Which report section is most commonly used for dates and page numbers?

How can you list the records in a query datasheet in A-Z order by CustomerName?

What is the first step to convert a report's macros to VBA code?

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

When building an action query, you do not change data until you click the _____ button.

Which tab contains options for aligning the text in a report control?

To rename a form, open the form, and then use the Rename command on the Home tab.

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

If a City field displays the value "Chicago" for a new record, that means the Default Value property for the City field has been set.

To expand an action in a macro, click the action name in the Action Catalog.

To add a field to a report in Report Design view, you use the report's property sheet.

If you move the source of a linked table, you must update its location using the Linked Table Manager.

Each page of a(n) _____ control is a container for other controls, such as text boxes or command buttons.

To relate two fields in a one-to-many relationship, you connect them using a _____.

When you enter a record in a table, you are working in navigation mode.

In which of the following circumstances would you copy an entire table?