FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Access: Querying a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

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.

A) New Report
B) Create
C) Query Report
D) Save as Report

E) A) and B)
F) None of the above

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Quick Access Toolbar
B) Home tab on the Ribbon
C) Create tab on the Ribbon
D) status bar

E) A) and C)
F) B) and C)

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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

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

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.

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

The arithmetic symbols for use in query calculations are ____.

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?

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

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

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

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

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

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

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

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.

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?

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

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

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