Question 1

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 in Microsoft Access allows users to include the Total row at the bottom of a datasheet, which calculates various statistics such as sum, average, and count of selected fields in the datasheet.

Question 2

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 3

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 4

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 shortcut menu option to create an update query is under the "Query Type" submenu.

Question 5

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 creates a new table based on the data from an existing table. It is used to separate and organize data that may be related to a specific task or analysis. The new table can then be used for further analysis, reporting, or querying.

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 designed to specifically identify duplicate records in a table. The other options do not necessarily have this function.

Question 7

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 is typically used to exit a program or application, and clicking it will usually prompt a dialog box asking whether you want to save any unsaved changes before closing. The "Quit" button is not a common option in most applications, and "Exit" and "Done" are not typically used as exit buttons in Access.

Question 8

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 used to indicate if a field is mandatory or not, so changing its value from "No" to "Yes" is the correct way to specify that the field is required. The other options may also allude to the field being mandatory, but they are not commonly used properties for this purpose.

Question 9

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 adds a group of records from one table to the end of another table. Option A ("insert") is incorrect because it typically implies inserting a single record rather than a group of records, and may also result in overwriting existing records if not done carefully. Options C ("add") and D ("supplement") are not commonly used in database terminology for this specific action.

Question 10

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 answer of To create a validation rule for the...

Question 11

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 12

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

Option A uses the correct syntax to specify multiple acceptable values in the validation rule property box. It separates the values with "or" and includes an equal sign before each value.

Question 13

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 can be computed from other fields using a formula or expression. It does not exist in the original dataset but is created based on other existing fields. Examples of calculated fields include average, sum, maximum, minimum, etc.

Question 14

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 is specifically designed to identify records in one table that do not have a corresponding match in another table. This option is the best choice for finding records that exist in one table but not in another.

Question 15

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 Total Rows in a datasheet. Thus, to remove a Total Row, you need to click on the Totals button and then uncheck the box for the Total Row option.

Question 16

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.

Question 17

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 answer of To change a query so that each...

Question 18

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

The Update button on the DESIGN tab is used to create an update query. Choosing option C will allow the user to create an update query in order to update data in a table. The other options are not relevant for creating an update query.

Question 19

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 20

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.

Quiz 6: Access: Maintaining a Database

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.

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

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.

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

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

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.

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

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

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

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(n) ____ field is a field that can be computed from other fields.

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

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

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 ____.

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

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

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 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.