Exam 1: Access-2019

The Performance Analyzer recommends how you can improve database performance.

When you apply the Currency format to a field, Access displays a currency symbol and two values after the decimal point, but it does not change the field's data type.

The Record Source property for a form identifies the fields and records to display on the form.

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

To modify the number of items displayed in a combo box list, you use the ____ property.

Number fields store values that represent quantities, measurements, and scores, for example.

The chart type that uses slices to show parts of a whole is a _____ chart.

Changing the _____ property for a field does not change the actual data stored in the field.

After setting up a Delete query, you delete selected records by clicking the _____ button.

You use the _____ property of a query to document the purpose or author of the query.

On a form, you use Edit view to enter, edit, and delete records.

_____ is a standardized language that all major relational database software uses.

A(n) _____ allows you to run macro actions based on the result of a conditional expression.

Each item on a form is called a _____.

When you add fields to a table in Table Design view, the _____ is optional.

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

If you change the font size of a report control in Report _____ View, you can see the effects of the change immediately.

If you do not enter a Caption property for a field, Access uses the field name to label the field.

For a Date/Time field, use the _____ property to display the date 1/17/2017 as January 17, 2017.

You can add a line to a report to indicate a subtotal.