Access Actions

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

To create an initial report that can be modified in Layout view, tap or click ____ on the CREATE tab.

To add a record to a table, tap or click the ____ record button.

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu.

n the accompanying figure, the Book Rep table displays in ____.

When you create a table in Datasheet view, Access automatically adds a field called ____ as the first field in the table.

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

To save the changes to the layout of a table, tap or click the Save button on the ____.

In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.

Access is a ____.

To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

In the accompanying figure, the small box or bar to the left of each field is called the ____.

To open the Navigation Pane, tap or click the ____ Button.

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

A field whose data type is ____ can store text that can be used as a hyperlink address.

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

In the accompanying figure, the Book Rep table displays in ____.

A field with the ____ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar.

To delete a record, tap or click the record selector for the record, and then press the ____ key(s).

A(n) ____ contains information about a given person, product, or event.

To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet

In the accompanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.

A field whose data type is ____ can contain any characters.

To exit Access, tap or click the ____ button on the right side of the title bar.

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

To import data to a table, tap or click the ____ tab on the ribbon.

To create a query using the Query Wizard, tap or click ____ on the ribbon and then click the Query Wizard button.

To open a table in Design view, press and hold or right-click the table in the Navigation Pane and then tap or click ____ on the shortcut menu

To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

To delete a record, tap or click the record selector for the record, and then press the ____ key(s).

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table

When you create a table in Datasheet view, automatically adds a field called ___ as the first field in the table.

To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.

To find the largest amount paid amount for a client, select ____ as the entry in the Total row for the Amount Paid column.

In the accompanying figure, the Customer table was added to the query by selecting the table and tapping or clicking the Add button in the ____ dialog box.

To re-use saved export steps, tap or click the Saved Exports button on the ____ tab on the ribbon.

To view the results of a query, open it by pressing and holding or right-clicking the query in the Navigation Pane and tapping or clicking ____ on the shortcut menu.

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

If the criterion for Current Due field is 0, the query results for this query will display ____ in the Current Due field.

In the accompanying figure, press and hold or right-click the join line and tap or click ____ on the shortcut menu to display the Join Properties dialog box.

To create a new query in Design view, tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due column.

In the accompanying figure, you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.

To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box, and enter the new caption.