Question 1

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 (-) 
A)  comma (,) 
B)  period (.) 
C)  exclamation mark (!) 
D)  dash (-)

Question 2

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. 
A)  Move all the controls to the right. 
B)  Remove the labels. 
C)  Sort the data. 
D)  Change the report to landscape orientation.

Question 3

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 Function 
A)  Start Function 
B)  Function 
C)  Option Function 
D)  Declare Function

Question 4

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

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

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

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

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

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

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

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters

Exam 8: Access

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

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

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

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

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

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters