Exam 8: Access

Although Access saves the queries you create in Structured Query Language (SQL), you cannot view the SQL code from within Access.

When you delete a record containing an AutoNumber field, Access discards the value in the AutoNumber field and _____.

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

To close a macro, you click the Run button.

Which procedure is triggered after a field is updated?

The _____ key field is the linking field on the "many" side of the relationship.

Which of the following join types can you create by double-clicking a join line in Query Design View? Select all the options that apply.

Change a form's Navigation Buttons property to No to remove the navigation bar from the form.

You can use a _____ to add, change, or delete table data based on conditions you specify.

Which of the following are form events? Select all the options that apply.

The Action Catalog lists all of the macro actions organized by category.

You click the _____ button to close the Filter by Form grid.

Which of the following could you use as a criterion in a Number field? Select all the options that apply.

You can select a particular form, such as a Navigation form, to display when Access starts.

What is the first step to convert a report's macros to VBA code?

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

How do you enter a value in a lookup field in Table Datasheet view?

You can import data into Access from which of the following sources? Select all the options that apply.

Exception mode means that you are the only person who has the database open, and others cannot open the file during this time.

To run macro actions based on the result of a conditional expression, you could add an If program flow to the macro.