Question 1

To remove a total row that appears in a datasheet,tap or click the ____ button on the HOME tab.
A) Toggle
B) Remove
C) Statistics
D) Totals

Accepted Answer

The Totals button on the HOME tab allows you to add or remove a total row, which appears at the bottom of a datasheet and shows aggregate values for each column. By clicking the Totals button again, you can remove the total row from the datasheet.

Question 2

To create a validation rule for the State field to restrict entries to TN or TX,enter ____ in the Validation Rule property box.
A) T*
B) T%
C) T>
D) T?

Accepted Answer

The '?' wildcard character is used to match any single character, so 'T?' will match any two-character string starting with 'T', such as 'TN' or 'TX'.

Question 3

To find records in one table that have no matching records in another table,use the _____ Query Wizard.
A) No Matches
B) No Records
C) Find Unmatched
D) Find Records

Accepted Answer

The "Find Unmatched" Query Wizard specifically searches for records in one table that have no matching records in another table, making it the best choice for this task. The other options do not have this specific function.

Question 4

To order the records in the Customer table by city in alphabetical order,use the ____ button.
A) Order Ascending
B) Sort
C) Sort Ascending
D) Ascending

Accepted Answer

The answer of To order the records in the Customer...

Question 5

To use the shortcut menu to create an update query,press and hold or right-click any open area in the upper pane,point to ____ on the shortcut menu,and then tap or click Update Query on the submenu that appears.
A) Action
B) Query Type
C) Action Query
D) Run Query

Accepted Answer

The option to select the query type is necessary to choose the update query option from the shortcut menu. A) Action - does not refer to the creation of an update query. C) Action Query - update query is a type of action query, but it does not provide the option to select update query directly. D) Run Query - selecting this option does not provide the option to create an update query.

Question 6

To find duplicate records in a table,use the _____ Query Wizard.
A) Duplicate Records
B) Same Records
C) Duplicate Primary Key
D) Find Duplicates

Accepted Answer

The "Find Duplicates" Query Wizard is specifically designed to find and display records with duplicate values in one or more fields.

Question 7

To update records using an update query,enter the field to be updated in the design grid,enter any necessary criterion,and then tap or click the ____ button to update the records.
A) Run
B) View
C) Execute
D) Update

Accepted Answer

The correct choice is "Run" because in most database management systems, including Microsoft Access, the "Run" button is used to execute an update query to modify records in a database.

Question 8

To order the records in the Customer table in reverse alphabetical order by City,click the ____ button.
A) Order Descending
B) Descending
C) Sort Descending
D) Sort

Accepted Answer

The answer of To order the records in the Customer...

Question 9

To indicate that the only allowable values for the Customer Type field are HS,COM,and UNI,enter ____ in the Validation Rule property box.
A) =HS or =COM or =UNI
B) HS,COM,UNI
C) must be HS,COM,or UNI
D) =HS,=COM,=UNI

Accepted Answer

The validation rule needs to specify that the only allowable values are HS, COM, and UNI. The correct syntax in this case is using "OR" between the different values and a leading "=" sign before each value. Therefore, A is the correct choice as it specifies =HS or =COM or =UNI.

Question 10

To create an update query,create a new query and then tap or click the ____ button on the DESIGN tab.
A) Query Type
B) Action
C) Update
D) Data Definition

Accepted Answer

To create an update query, we need to use the "Update" button on the DESIGN tab.

Question 11

To change a query so that each item in a multivalued field occurs on a different row,use the ____ property.
A) Field
B) Value
C) Unique
D) Distinct

Accepted Answer

The "Value" property is used to display each item in a multivalued field on a separate row in a query.

Question 12

A(n)____ query adds records from an existing table to a new table,that is,a table that has not yet been created.
A) insert-table
B) new-table
C) add-table
D) make-table

Accepted Answer

A "make-table" query is used to create a new table and populate it with records from an existing table. The other options do not accurately describe this type of query.

Question 13

A(n)____ query adds a group of records from one table to the end of another table.
A) insert
B) append
C) add
D) supplement

Accepted Answer

An "append" query is used to add a group of records from one table to the end of another table. The other choices (insert, add, supplement) do not accurately describe this type of query.

Question 14

To save validation rules,default values,and formats,tap or click the Save button on the ____ to save the changes.
A) HOME tab
B) status bar
C) Quick Access Toolbar
D) DESIGN tab

Accepted Answer

The Quick Access Toolbar in Microsoft applications like Access allows users to save changes such as validation rules, default values, and formats quickly, without navigating through tabs.

Question 15

To exit Access,click the ____ button on the right side of the Access title bar.
A) Quit
B) Exit
C) Close
D) Done

Accepted Answer

The "Close" button on the right side of the Access title bar will close the current database and exit Access. The "Quit" and "Exit" options are not available in Access. The "Done" option is not typically used to exit programs.

Question 16

To specify that a field is to be required,change the value for the _____ property from No to Yes.
A) Required
B) No Blanks
C) Necessary
D) Completed

Accepted Answer

The Required property is specifically designed to indicate whether a field is required or not. By changing its value from No to Yes, we can mark a field as required. The other options ("No Blanks," "Necessary," and "Completed") are not standard properties and are not commonly used to indicate required fields.

Question 17

To specify that entries in the Returns field must be between $0.00 and $30,000.00,enter ____ in the Validation Rule property box. A) >=0,<=30,000 B) >=$0,<=$30,000 C) >=0 and <=30000 D) >=$0 and <=$30,000

Accepted Answer

The correct syntax for specifying a range in a Validation Rule property box does not include currency symbols and uses the word 'and' to combine the lower and upper limits.

Question 18

To include totals and other statistics at the bottom of a datasheet,tap or click the ____ button on the HOME tab to include the Total row in the datasheet.
A) Statistics
B) Add Total
C) Insert Total
D) Totals

Accepted Answer

The Totals button on the Home tab is used to include the Total row in the datasheet. This will allow you to see statistics and totals at the bottom of your data.

Question 19

A(n)____ field is a field that can be computed from other fields.
A) aggregate
B) combined
C) total
D) calculated

Accepted Answer

A calculated field is a field that is derived from other fields in the database through a mathematical equation or formula. This is different from an aggregate field, which is a field that performs calculations on a set of records, such as a sum or average. Therefore, option D, calculated, is the best choice.

Question 20

If the Customer Number field in a record always should display the three characters in the customer number in uppercase,then the correct format for this field is ____.
A) <
B) &
C) %
D) >

Accepted Answer

The ">" symbol is used to indicate that the data in the field should be displayed in uppercase format.

Quiz 17: Access: Maintaining a Database

To remove a total row that appears in a datasheet,tap or click the ____ button on the HOME tab.

To create a validation rule for the State field to restrict entries to TN or TX,enter ____ in the Validation Rule property box.

To find records in one table that have no matching records in another table,use the _____ Query Wizard.

To order the records in the Customer table by city in alphabetical order,use the ____ button.

To use the shortcut menu to create an update query,press and hold or right-click any open area in the upper pane,point to ____ on the shortcut menu,and then tap or click Update Query on the submenu that appears.

To find duplicate records in a table,use the _____ Query Wizard.

To update records using an update query,enter the field to be updated in the design grid,enter any necessary criterion,and then tap or click the ____ button to update the records.

To order the records in the Customer table in reverse alphabetical order by City,click the ____ button.

To indicate that the only allowable values for the Customer Type field are HS,COM,and UNI,enter ____ in the Validation Rule property box.

To create an update query,create a new query and then tap or click the ____ button on the DESIGN tab.

To change a query so that each item in a multivalued field occurs on a different row,use the ____ property.

A(n) ____ query adds records from an existing table to a new table,that is,a table that has not yet been created.

A(n) ____ query adds a group of records from one table to the end of another table.

To save validation rules,default values,and formats,tap or click the Save button on the ____ to save the changes.

To exit Access,click the ____ button on the right side of the Access title bar.

To specify that a field is to be required,change the value for the _____ property from No to Yes.

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

To include totals and other statistics at the bottom of a datasheet,tap or click the ____ button on the HOME tab to include the Total row in the datasheet.

A(n) ____ field is a field that can be computed from other fields.

If the Customer Number field in a record always should display the three characters in the customer number in uppercase,then the correct format for this field is ____.