Exam 1: Access-2019

Sylvia wants to align the right edges of the labels on a form. After selecting the controls in Form Design view, what should she do?

An aggregate function is _____.

Sam created a self join between two copies of the Employees table and then renamed one copy Managers. When he adds the LastName field from the Managers table and the LastName field from the Employees table to the query grid, which of the following statements describes the results?

When you copy data from an Access query to a new delimited text file, you are _____ the data.

The Database Documenter provides step-by-step help for using an Access database.

How do you align the right edges of selected controls in Form Design view?

To view a list of the database objects that depend on the selected object, open the Object Dependencies pane.

You could use "Madison" as the criterion for a Yes/No field.

In a macro, a(n) _____ results in a true or false value.

If you want to manage lists of data about customers and the products they order, use _____ software.

_____ are properties of an action that provide additional information on how the action should execute.

To add a field to a report in Report Design view, you use the report's property sheet.

Characteristics, such as Field Name and Data Type, are_____ that define a field.

You can format a table datasheet by setting the alternate record color in Table Datasheet view.

Set the Append Only property to _____ to allow users to add data to a Long Text field but not to change or remove existing data.

The edit record symbol (a pencil icon) appears to the left of a table record when you are selecting the record.

To organize objects in the Navigation Pane, you can create a custom group.

What happens when you drag a tab on a Navigation form in Form Layout View?

When you add a field to a form in Form Layout view, Access creates a text box but not a label.

If a field contains the value 1.204 but displays the value 1.2, what can you do to show the entire value?