Deck 5: Generating Reports From Multiple Worksheets and Workbooks

Question 1

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.

A) Add
B) Yes
C) Edit
D) No

Answer 1

B

Question 2

Which of the following describes the Caption property? Select all the options that apply.

A) It must match the field name.
B) It is used as the default field name in labels that describe fields on forms and reports.
C) It is an optional property.
D) It is used as the default field name at the top of the field column in datasheets.

Answer 2

B,C,D

Question 3

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

Answer 3

True

Question 4

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

A) use the Field Properties pane in Table Design view
B) use the Conditional Formatting Rules Manager dialog box
C) open the property sheet for the field list in the Relationships window
D) open the property sheet for the table

Question 5

To change the _____ displayed in a query datasheet,you modify the field's Caption property in Query Design view.

A) record number
B) field description
C) field name
D) criterion

Question 6

Create a Top Values query to find the highest values in set of unsorted records.

Question 7

An aggregate function is _____.

A) a function that calculates a statistic such as a subtotal or average
B) a mathematical expression,such as [Qty]*[UnitsSold]
C) a way to group records,such as by state or postal code
D) a way to test the accuracy of data

Question 8

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

A) Date
B) Format
C) Data Type
D) Field Size

Question 9

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.

A) select
B) grouped
C) crosstab
D) calculated

Question 10

If you do not enter a Caption property for a field,Access uses the field name to label the field.

Question 11

Which of the following are settings you specify in the Crosstab row of the query design grid when you create a crosstab query? Select all the options that apply.

A) Row heading
B) Value
C) Sort order
D) Column heading

Question 12

Which of the following statements apply to Long Text fields? Select all the options that apply.

A) Set the Append Only property to let users add but not change data in a Long Text field.
B) Use Long Text fields when you need to store more than 256 characters in a field.
C) Set the Indexed property of Long Text fields to Yes because they are often used for sorting.
D) Fields that store comments,reviews,or notes are good candidates for Long Text fields.

Question 13

If you set the Caption property of a form,where does the caption text appear?

A) in the Navigation Pane
B) in the form header
C) on the form tab in Form view
D) in the Details section in Form Design view

Question 14

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

A) AND criteria
B) row headings
C) sort order
D) parameter prompt

Question 15

The only way to create a Crosstab query is to use the Crosstab Query Wizard.

Question 16

For a field that contains more than 256 characters of comments or notes,use the _____ data type.

A) Short Text
B) Lookup
C) Long Text
D) Hyperlink

Question 17

When you create a(n)_____ query,the value the user enters in the dialog box determines which records the query displays in the results.

A) parameter
B) summary
C) action
D) crosstab

Question 18

In Query Design view,you enter parameter criteria within curly brackets,as in {Enter department:}.

Question 19

You can retain a history of changes to a _____ field.

A) Date/Time
B) Yes/No
C) Long Text
D) Number

Question 20

How can you display "Product Description" in a table datasheet for a field named "ProdDesc" without renaming the field?

A) Enter "Product Description" in the Caption property for the field.
B) Edit the column heading in Table Layout view.
C) Change the Format property to Separate Words.
D) Change the Default Value property to "Production Description".

Question 21

If you select 25 in the Top Values list,Access displays _____ in the query results.

A) the top 25% of the records
B) 25 randomly selected records
C) 25 fields
D) the top 25 records

Question 22

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

A) Validation
B) Property Sheet
C) Message
D) Required

Question 23

You use the _____ to create a query that finds records in one table that do not have related records in another table.

A) Find Duplicates Query Wizard
B) Find Unmatched Query Wizard
C) Crosstab Query Wizard
D) Select Orphans Query Wizard

Question 24

You use the Explanation property to display a message when a user tries to enter data that break the validation rule.

Question 25

Which of the following are properties you can set for a query? Select all the options that apply.

A) Description
B) Recordset Type
C) Default View
D) Field Size

Question 26

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

Question 27

Dynaset is the default value of the _____ property in a query; it lets you update data in the query recordset.

A) Snapshot
B) Recordset Type
C) Description
D) Caption

Question 28

To create a single-value lookup field in Table Design view,you use the _____ in the Field Properties pane.

A) Lookup tab
B) Input Mask property
C) Lookup button
D) List property

Question 29

In a Date/Time field named HireDate,the validation rule expression >#7/1/21# means _____.

A) the date must be after 7/1/21
B) the date must be before 7/1/21
C) the date must be in July of 2021
D) the date must be 7/1/21

Question 30

Which of the following are options you can select in the Top Values list for a query? Select all the options that apply.

A) 5
B) None
C) 25%
D) All

Question 31

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

A) Click the arrow in the column heading,and then click an option.
B) Press an arrow key
C) Click the Lookup arrow on the Home tab.
D) Click the arrow in the field,and then click an item on the list.

Question 32

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

A) criterion
B) data type
C) validation rule
D) relationship

Question 33

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

Question 34

If the Quantity field has "< 50" as its validation rule,and a user tries to enter "100" in the field,Access displays the message in the _____ property.

A) Explanatory Message
B) Validation Text
C) Violation Message
D) Error Text

Question 35

Use a Long Text field when you need to store more than 256 characters in a field,such as for comments,reviews,or notes.

Question 36

If you want users to enter a positive Currency value in a Price field,enter _____ as the validation rule expression.

A) <= 0
B) > 0
C) '+ 1
D) "Positive"

Question 37

To set the properties for an entire table,open the table's property sheet in Table Design view.

Question 38

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

A) Validation Text
B) Format
C) Caption
D) Validation Error

Question 39

To set a validation rule in the Employees table specifying that the DateHired field value must be greater than the DateBorn field value,you set the Validation Rule property for the _____.

A) DateHired field
B) Employees table
C) DateBorn field
D) database

Question 40

Which of the following fields are good candidates for a single-value lookup field? Select all the options that apply.

A) OrderDate
B) Gender
C) State
D) Department

Question 41

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

A) >0
B) <=0
C) Is Not Null
D) <0>

Question 42

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

Question 43

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

A) Insert a column.
B) Apply a cell style.
C) Remove a control.
D) Merge cells.

Question 44

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

A) freeze
B) hide
C) duplicate
D) format

Question 45

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

A) Input Mask
B) Format
C) Visual Guide
D) Caption

Question 46

You can freeze one or more fields in a datasheet so they remain visible at all times.

Question 47

(999)000-000;1;_ would be a possible entry for which field property?

A) Input Mask
B) Format
C) Required
D) Field Size

Question 48

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

A) 4
B) >=4
C) <>4
D) "Is 4"

Question 49

In Query Design view,how can you add a field to the query design grid?

A) Right-click the query design grid,and then click the field's name.
B) Double-click the field in the field list.
C) Click the field in the field list,and then click the Add to Grid button.
D) Double-click the first available field in the query design grid.

Question 50

After you freeze a field in a query datasheet,you must run the query again before you can unfreeze the field.

Question 51

The _____ is the wildcard character that stands for any single character in criteria.

A) question mark (?)
B) asterisk (*)
C) quotation mark (")
D) exclamation mark (!)

Question 52

If you used D*n as the criterion in a Short Text field called FirstName,what would appear in that field in the query results?

A) names that start with D and include n anywhere else,such as Donald
B) names that start with D,such as Drew
C) names that end with n,such as Leon
D) names that start with D and end with n,such as Dean

Question 53

A common place to use the Input Mask property is for a FirstName field.

Question 54

To set the Validation Text property for a table in Table Design view,you use the _____.

A) Validation Text property for any field in the table
B) Object dialog box
C) Expression dialog box
D) property sheet for the table

Question 55

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

A) Purpose
B) Object
C) Miscellaneous
D) Description

Question 56

In the criterion 8/*/2021,the asterisk (*)is called a wildcard.

Question 57

The Recordset Type property determines whether Access locks or allows updates to records displayed by a query.

Question 58

The _____ property creates an easy-to-use visual guide to help users enter accurate data.

A) Phone Number
B) Pattern
C) Input Mask
D) Default Value

Question 59

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

A) add the field to the query design grid
B) delete the field from the query
C) sort the query based on that field
D) set the field as the primary key

Question 60

For a Date/Time field,use the _____ property to display the date 1/17/2017 as January 17,2017.

A) Input Mask
B) Caption
C) Lookup
D) Format

Question 61

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

A) Descending
B) Ascending
C) Toggle Filter
D) Refresh All

Question 62

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

A) RTF
B) HTML
C) Plain Text
D) Enhanced Text

Question 63

Fields that are good candidates for Lookup properties are those that contain a limited set of values such as State,Gender,or Department.

Question 64

To display the contents of a text box in more than one font size or color,set the _____ property of the text box to RTF.

A) HTML
B) Font Tags
C) Text Format
D) CSS

Question 65

A parameter query displays a dialog box that prompts you for field criteria.