Exam 1: Access-2019

Create a Top Values query to find the highest values in set of unsorted records.

How can you create a backup of a macro?

A(n) event is a procedure that returns a value.

To arrange form controls in a layout of rows and columns like a spreadsheet, select the controls to group together, and then click the _____ button on the Form Layout Tools Arrange tab.

To create a _____, you add the Total row to the query design grid to specify how to group and perform calculations on the records.

What data type should you assign to a WeeklySalary field?

You use the Insert Rows button on the Query Tools Design tab to _____.

You click the _____ button to execute the selected Access macro.

The Input Mask property provides a pattern for data to be entered, such as for a phone number.

In Query Design view, use the COUNT aggregate function when you want to find the number of values in a field.

AutoType is a data type that numbers each record automatically.

Access adds # signs around text criteria in Date/Time fields.

A check box control usually displays a "yes" or "no" answer for a field.

To display the contents of a text box in more than one font size or color, set the _____ property of the text box to RTF.

To resize a control in Report Layout view, you format an edge of the selected control.

After you split a database, what does the back-end database contain?

_____ fields allow you to make more than one choice from a field's lookup list.

A(n) data macro is a collection of actions within a single macro object.

The Import Spreadsheet Wizard can help you import data from Excel into a new Access table.

The Enabled property specifies whether you can edit a control in Form view.