Exam 4: Access: Querying a Database

To save a query, click the Save button on the ____.

To use the Report Wizard to create a report for a query, select the query in the Navigation Pane, click _____ on the Ribbon, and then click the Report Wizard button.

Camashaly Design has decided to add some additional validation rules to the Client table shown in Design view in the accompanying figure.They have asked you to create these validation rules. Camashaly would like to make sure that if an employee enters the letters nc in the State field that it displays in the database as NC.What property do you need to change and what would you enter in the property box?

The relationship in the accompanying figure was created by clicking the ____________________ check box in the Edit Relationships dialog box.

Use a query to _____ tables; that is, to find records in two tables that have identical values in matching fields.

A lookup field allows the user to select from a list of values when updating the contents of a field.

To move from Layout view to Form view, click the ____ button on the Access Status bar.

To specify that entries in the Amount Paid field must be between $0.00 and $50,000.00, enter ____ in the Validation Rule property box.

A property sheet is a window containing the various properties of the object.

When you use Filter By Form to restrict records that appear, you create the filter and then click the ____ button to apply the filter.

When you specify referential integrity, you need to decide how to handle the update of the primary key.What decisions do you need to make?

The arithmetic symbols for use in query calculations are ____.

When you enter text data in a criterion, you must enclose the text in quotation marks.

If you add a field to a table and later realize the field is in the wrong location, you can move the field.To move the field, click the ____________________ for the field and then drag the field to the new location.

To show the Navigation Pane if it is hidden, click the ____ Button.

To create a lookup field, select ____________________ from the menu of available data types.

To move to the first record using the form shown in the accompanying figure, click the ____ button on the Navigation bar.

A default value is a value that Access will display on the screen in a particular field before the user begins adding a record.

To print a copy of a relationship, click the _____________________ button shown on the accompanying figure.

Less than ( ), and NOT (not equal to)are examples of _____.