Exam 8: Access

Which of the following are changes you make when formatting a datasheet? Select all the options that apply.

To display the VBA code for a form, click the Build button in one of the form's event properties.

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

Which of the following are ways to run a query? Select all the options that apply.

If you want to find records in the table on the "one" side of a one-to-many relationship that do not have related records in the "many" side, which join do you use?

The two types of control layouts Access provides for forms are stacked and _____.

The _____ organizes all the arguments for an action in a rectangle with a gray background.

What could you do to clarify that the MonthlyRent field in a report contains dollar amounts?

When you create a form using the Blank Form tool, the _____ property is blank.

To total the values in a SalesPrice field in Table Datasheet view, you click the Total cell in the SalesPrice column, click the arrow, and then click _____.

Which of the following formatting changes can you make to report control text in Report Layout view? Select all the options that apply.

How do you create a macro in Access?

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

When you create a report using the _____, Access includes all the fields in the selected table.

If you set the _____ property for a field that is often used for sorting, you improve database performance.

What happens if you write VBA code in all lowercase letters? ?

The Lookup Source property stores the values that are provided in the list for a Lookup field.

____ makes a duplicate copy of the data in the Access database.

You can use the Format property to display dates in a report using a Short Date format.

Which of the following statistics can you calculate in the Total row for a Currency field in Table Datasheet view? Select all the options that apply.