Exam 1: Access 2019

When you click the first value in a column in Report Layout view, what are you actually selecting?

Which of the following pages numbers is displayed in the "Page N of M" format?

In Report Design view, you display a Number field value as a percentage using the _____ property.

When you _____ a macro, you determine why it is not running correctly.

A(n) _____ is a template for creating a table that contains fields and specifies their data types.

The term _____ describes a field value that does not exist because it has never been entered.

When you enter data in the rows of a table datasheet, you are entering _____.

Field _____ are the characteristics that describe each field, including Field Name and Data Type.

What is the result of selecting the first name in the City column in Report Layout view and then clicking the Center button on the Home tab?

How do you display the records in a subdatasheet?

To display the data in a table, you open the table in Table Design view.

Add a Number field to a table to store values that represent money.

In Table Datasheet view, a(n) _____ shows the records on the "many" side of a one-to-many relationship.

To apply the last filter you selected to a datasheet, you click the _____ button.

Of all the database objects, a table provides the most formatting, layout, and summary options.

To add a subform to a form in Form Design view, you use the Subform/Subreport control.

How can you remove a label from a control layout so you can move and resize the label separate from the other controls?

What happens when you apply a theme to a form?

You can add a command button to a form using the Command Button Wizard, one of many _____ Wizards Access offers.

A database in a trusted folder enables all database content, including all macros and VBA.