Question 1

Of all the database objects, a table provides the most formatting, layout, and summary options.

Accepted Answer

A) True 
 B)False

Question 2

To relate two fields in a one-to-many relationship, you connect them using a _____.

Accepted Answer

A)   subdatasheet
B)   common field
C)   field key
D)   data typeE) None of the above
F) All of the above

Question 3

In Query Design view, the _____ shows you the field names, sort orders, and criteria used with a query.

Accepted Answer

A)   Query Tools Design tab on the ribbon
B)   upper pane
C)   Navigation Pane
D)   query design gridE) C) and D)
F) A) and C)

Question 4

If a form displays data from the Clients table, you could change the form's Record Source property to _____ to display different data.

Accepted Answer

A)   another form
B)   a list of values that you enter
C)   a different table
D)   a spreadsheetE) A) and C)
F) All of the above

Question 5

Which of the following are types of advice the Performance Analyzer gives regarding performance? Select all the options that apply.

Accepted Answer

A)   Suggestion
B)   Idea
C)   Issue
D)   RecommendationE) A) and B)
F) A) and C)

Question 6

To perform calculations on field values in Table Datasheet view, you click the Totals button in the Records group on the Home tab.

Accepted Answer

A) True 
 B)False

Question 7

In a Jobs database that contains an Employers table related to a Positions table, what do you expect to find in the subdatasheets of the Employers table?

Accepted Answer

A)   the company name of each employer
B)   the positions offered by each employer
C)   details about the employer with the most positions
D)   the names of employers offering no positionsE) A) and D)
F) None of the above

Question 8

How do you rename a table?

Accepted Answer

A)   Right-click the object tab in the Access window, and then click Rename.
B)   Right-click the table in the Navigation Pane, and then click Rename.
C)   Click the table in the Navigation Pane, and then click the Rename button.
D)   Open the table in Table Datasheet view, and then click the Rename button.E) None of the above
F) B) and C)

Question 9

When you add a field with an Attachment data type to a form, it appears as a(n) Photo control.

Accepted Answer

A) True 
 B)False

Question 10

The outer join is the default join operation in Access.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following commands can you use to add a picture to a form? Select all the options that apply.

Accepted Answer

A)   Insert Image
B)   Logo
C)   Online Pictures
D)   Background ImageE) All of the above
F) B) and D)

Question 12

In Access macros, you can use conditional expressions in If statements.
​

Accepted Answer

A) True 
 B)False

Question 13

A common way to run a macro is to assign it to a command button.
​

Accepted Answer

A) True 
 B)False

Question 14

What should you do when you are finished working a database?

Accepted Answer

A)   Open and then save each object in the database.
B)   Close the Navigation Pane.
C)   Sign out so other people can use the database.
D)   Close the database.E) A) and B)
F) A) and C)

Question 15

Which of the following are default grouping options for the Navigation Pane? Select all the options that apply.

Accepted Answer

A)   Theme
B)   Created Date
C)   Object Type
D)   Tables and Related ViewsE) A) and C)
F) A) and B)

Question 16

What does the criterion <=200 mean?

Accepted Answer

A)   less than or equal to 200
B)   less than 200
C)   greater than or equal to 200
D)   not equal to 200E) C) and D)
F) A) and B)

Question 17

When you split a database, the back-end database contains all of the queries, forms, and reports in the database.

Accepted Answer

A) True 
 B)False

Question 18

If you delete the text box for the State field on a report, Access removes _____.

Accepted Answer

A)   the State names from the report
B)   the State names from the underlying record source
C)   the label associated with the State text box
D)   the State field from the Field ListE) A) and D)
F) B) and C)

Question 19

When you click the Delete button in the Query Type group, Access adds the Update row to the query design grid.

Accepted Answer

A) True 
 B)False

Question 20

To display a field list for the Employees table with the name "Managers" in Query Design view, you change the _____ property for the field list. ​

Accepted Answer

A)   Description
B)   Source
C)   Lookup
D)   AliasE) B) and D)
F) All of the above

Exam 9: Access

When you add a field with an Attachment data type to a form, it appears as a(n) Photo control.

Correct AnswerverifiedShow Answer

The outer join is the default join operation in Access.

Correct AnswerverifiedShow Answer

If a form displays data from the Clients table, you could change the form's Record Source property to _____ to display different data.

Correct AnswerverifiedShow Answer

When you click the Delete button in the Query Type group, Access adds the Update row to the query design grid.

Correct AnswerverifiedShow Answer

In Access macros, you can use conditional expressions in If statements. ​

Correct AnswerverifiedShow Answer

What does the criterion <=200 mean?

Correct AnswerverifiedShow Answer

Of all the database objects, a table provides the most formatting, layout, and summary options.

Correct AnswerverifiedShow Answer

To display a field list for the Employees table with the name "Managers" in Query Design view, you change the _____ property for the field list. ​

Correct AnswerverifiedShow Answer

In a Jobs database that contains an Employers table related to a Positions table, what do you expect to find in the subdatasheets of the Employers table?

Correct AnswerverifiedShow Answer

A common way to run a macro is to assign it to a command button. ​

Correct AnswerverifiedShow Answer

How do you rename a table?

Correct AnswerverifiedShow Answer

In Query Design view, the _____ shows you the field names, sort orders, and criteria used with a query.

Correct AnswerverifiedShow Answer

If you delete the text box for the State field on a report, Access removes _____.

Correct AnswerverifiedShow Answer

When you split a database, the back-end database contains all of the queries, forms, and reports in the database.

Correct AnswerverifiedShow Answer

Which of the following are default grouping options for the Navigation Pane? Select all the options that apply.

Correct AnswerverifiedShow Answer

What should you do when you are finished working a database?

Correct AnswerverifiedShow Answer

To perform calculations on field values in Table Datasheet view, you click the Totals button in the Records group on the Home tab.

Correct AnswerverifiedShow Answer

Which of the following commands can you use to add a picture to a form? Select all the options that apply.

Correct AnswerverifiedShow Answer

To relate two fields in a one-to-many relationship, you connect them using a _____.

Correct AnswerverifiedShow Answer

Which of the following are types of advice the Performance Analyzer gives regarding performance? Select all the options that apply.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

In Access macros, you can use conditional expressions in If statements.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

To display a field list for the Employees table with the name "Managers" in Query Design view, you change the _____ property for the field list.

Correct Answer
verified

Correct Answer
verified

A common way to run a macro is to assign it to a command button.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified