Question 1

You use the Insert Rows button on the Query Tools Design tab to _____.

Accepted Answer

A)   insert a row in the query design grid
B)   insert a row in the selected field list
C)   insert a row in the query datasheet
D)   insert a new query design gridE) A) and B)
F) All of the above

Question 2

Which VBA keyword(s)  do you use to declare the name and arguments that create a new function procedure?

Accepted Answer

A)   Start Function
B)   Function
C)   Option Function
D)   Declare FunctionE) B) and D)
F) None of the above

Question 3

If a SQL statement selects more than one field, which of the following characters do you use to separate the field names?

Accepted Answer

A)   comma (,) 
B)   period (.) 
C)   exclamation mark (!) 
D)   dash (-) E) A) and B)
F) All of the above

Question 4

Which common technique is used to fit more columns of data across a report?

Accepted Answer

A)   Move all the controls to the right.
B)   Remove the labels.
C)   Sort the data.
D)   Change the report to landscape orientation.E) None of the above
F) B) and C)

Question 5

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

Accepted Answer

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.E) A) and C)
F) All of the above

Exam 8: Access

You use the Insert Rows button on the Query Tools Design tab to _____.

Correct Answer
verified

Which VBA keyword(s) do you use to declare the name and arguments that create a new function procedure?

Correct Answer
verified

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

Correct Answer
verified

Which common technique is used to fit more columns of data across a report?

Correct Answer
verified

If a SQL statement selects more than one field, which of the following characters do you use to separate the field names?

Correct Answer
verified

Exam 8: Access

You use the Insert Rows button on the Query Tools Design tab to _____.

Correct AnswerverifiedShow Answer

Which VBA keyword(s) do you use to declare the name and arguments that create a new function procedure?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which common technique is used to fit more columns of data across a report?

Correct AnswerverifiedShow Answer

If a SQL statement selects more than one field, which of the following characters do you use to separate the field names?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified