Exam 1: Access-2019

In Access macros, you can use conditional expressions in If statements.

To replace "coffee" with "beverage" in any part of a field, you click the _____ in the Find and Replace dialog box.

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

To move a field in the query design grid, click its_____, and then drag it left or right.

After running a Delete query, you cannot _____.

To move a field in Query Design view, you drag the field by its field selector .

What data type is most appropriate for a field named SquareFeet?

After you export report data to an HTML document, you can _____ the data in a browser.

To navigate records in Form view, you use the buttons on the _____.

Which argument of the MessageBox macro action determines the text in the title bar of the message dialog box?

Which control works best to display three choices-1, 2, or 3-for a Rating field?

If a field named Price displays values with three decimal places, what should you do to display the values accurately?

The _____ New Page property helps you start printing a section at the top of a new page.

What happens in a table if you change the font color of the primary key field for the first record to red?

To run macro actions based on the result of a conditional expression, you could add an If program flow to the macro.

You can use the _____ to copy data from Excel to Access.

When you convert a macro, you break it down, step by step, to observe the effect of each action.

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

On Click is an example of a(n) _____.

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