Exam 1: Access-2019

Access creates fields with _____ properties as combo boxes on new forms.

If you are displaying values from two fields in a combo box, you can change the _____ property of the combo box control to display both values in the list.

If you want to remove records for discontinued products from a Products table, create a(n) Update query.

When you edit a record, pressing ESC once removes the changes to the field. What happens if you press ESC a second time?

Which of the following is a startup command-line option?

To create an Update query in Query Design view, you use the Add to row in the query design grid.

What kind of criteria would you use to find records with no OrderDate values?

What button do you use on the Query Tools Design tab to add a field list to a query?

Comment lines start with an exclamation point (!) and are red in the Visual Basic Editor.

A form control with its Focus Stop property set to Yes will receive the focus in Form view.

When you change a select query to an Update query, Access displays the _____ row in the query design grid.

What do you click to perform the actions in a macro?

To add a title to a report in Report Layout view, you click the _____ button on the Design tab.

You use a toggle button on a form to _____.

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

In which object can you rename a field?

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

A(n) self join selects all the records from the "one" table regardless of whether there is a related record in the "many" table.

If the _____ property for a form control is set to No, you cannot edit data in the control in Form view.

A(n) _____ is an image that fills the entire form, appearing "behind" the other controls.