Exam 1: Access-2019

How do you display the records in a subdatasheet?

What is the difference between entering a record using a form and entering a record using a datasheet?

When you start Access, the first screen that appears is one showing a blank database.

To select more than one control in Form Design view, you _____ and then click each control.

You modify the Set New Page property of a section to force each section to start printing at the top of a new page.

What data type should you assign to a field that stores postal codes?

When you use the Chart Wizard to add a chart to a report, your first step is to select _____.

You typically increase the decimal places from 1 to 2 for a(n) _____ field.

You use a subdatasheet to modify a field's properties.

How can you display the title of a report in green?

You can make formatting changes to a table, such as font color and font size, in Table Design view.

To use HTML tags to format text in a text box, first set the Text Format property of the text box to _____.

If you used D*n as the criterion in a Short Text field called FirstName, what would appear in that field in the query results?

Which of the following tools can you use to create a query?

You use the _____ button in the Sort & Filter group to use features such as Save As Query and Clear All Filters.

To copy a table, you right-click it in _____ and then click Copy on the shortcut menu.

A report that contains a subreport is called the main report.

A parameter query displays a dialog box that prompts you for field criteria.

When using the Chart Wizard, you can drag a Number field to the Data area of a chart to have the wizard automatically _____ the values in the field.

To change an inner join relationship between tables for one query only to an outer join, you double-click the join line in Relationship Design view.