Exam 1: Access-2019

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

The difference between importing and exporting data is largely based on the type of data that is being copied.

A Make-Table query is a type of _____.

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

What can you add to a query datasheet to display statistics for a group of records?

Which of the following form controls can you format by applying a style to it?

Phil created a report based on a query named NewClients. What report property should he use to add a calculated field to the query?

A Make-Table query is a type of action query that creates a new table of data.

You can drag a report from the Navigation Pane to an [Add New] button to add the report to the navigation form in Form Layout view.

To _____ a query, you right-click it in the Navigation Pane, and then click Copy on the shortcut menu.

A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single datasheet.

A _____ chart typically shows trends over time.

In Form Design view, you can align controls and their contents.

To delete a field from a query, drag the field out of its field list.

For a field that contains more than 256 characters of comments or notes, use the _____ data type.

If users must enter data in a LastName field, what property should you set for the field?

A join line is also called a _____ line.

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

You use _____ to document and explain the statements in VBA code.

In Query Design view, the _____ shows you the field names, sort orders, and criteria used with a query.