Exam 5: Generating Reports From Multiple Worksheets and Workbooks

In which of the following ways can you change the arrangement of a control layout? Select all the options that apply.

To use HTML tags to format text in a text box,first set the Text Format property of the text box to _____.

In large datasheets,you can ____ certain fields so that they remain on the screen at all times.

You use the Find Unmatched Query Wizard to find records in one table that do not have related records in another table.

In a SaleDate field,you can display dates as 03-Jan-21,for example,by selecting Medium Date as the _____ property.

The Input Mask property provides a pattern for data to be entered,such as for a phone number.

The Crosstab Query Wizard asks you to select fields for the _____,column headings,and values.

A _____ query in a real estate database could list property types as row headings,number of bedrooms as column headings,and the count of each property type as values.

To set a validation rule for an entire table,you _____.

The Validation Rule and _____ properties help prevent users from entering unreasonable data in the database.

To list values in a Number field in order from lowest to highest,you use the _____ button.

You cannot use the Validation Rule property with Short Text or Date/Time fields.

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.

What criterion should you use in the Bedrooms field to select records of houses for sale with exactly four bedrooms?

When you set a _____ for a table,you create an expression that restricts the values that users can enter into a record.

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

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

To set the validation text for a table in Table Datasheet view,you use the _____ button on the Table Tools Fields tab.

When you double-click a field in a field list in Query Design view,you _____.

You use the _____ property of a query to document the purpose or author of the query.