Question 1

Which of the following Access date functions determines a specific piece,or interval,of a date?

Accepted Answer

A)  DateSerial() 
B)  DateAdd() 
C)  DateDiff() 
D)  DatePart() 
A)  DateSerial() 
B)  DateAdd() 
C)  DateDiff() 
D)  DatePart()

Question 2

Why is it sometimes necessary to change the height of a report section?

Accepted Answer

Many times the initial size of a section

Question 3

Which of the following report sections prints the group title/ value at the top of each group?

Accepted Answer

A)  Report Footer 
B)  Page Header 
C)  Page Footer 
D)  Group Header 
A)  Report Footer 
B)  Page Header 
C)  Page Footer 
D)  Group Header

Question 4

You can place calculated controls in any section of a report.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following lets you select more than one control at once?

Accepted Answer

A)  Ctrl 
B)  Alt 
C)  Shift 
D)  Esc 
A)  Ctrl 
B)  Alt 
C)  Shift 
D)  Esc

Question 6

Which of the following would you use to hide repeated values in a report?

Accepted Answer

A)  concatenation formulas 
B)  calculated controls 
C)  Hide Duplicates property 
D)  Delete query 
A)  concatenation formulas 
B)  calculated controls 
C)  Hide Duplicates property 
D)  Delete query

Question 7

Access evaluates expressions with the standard order of operations.

Accepted Answer

A) True 
 B)False

Question 8

While you could modify each record individually in a table,an update query allows you to make the change to all records using one command.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following must you use to view the expression inside a calculated control?

Accepted Answer

A)  Layout view 
B)  Design view 
C)  Print Preview view 
D)  Page Layout view 
A)  Layout view 
B)  Design view 
C)  Print Preview view 
D)  Page Layout view

Question 10

What is a subreport? How do they work?

Accepted Answer

A subreport is a report inserted within

Question 11

While displaying a report in Design view,which of the following opens the Property Sheet?

Accepted Answer

A)  F2 
B)  F4 
C)  F6 
D)  F8 
A)  F2 
B)  F4 
C)  F6 
D)  F8

Question 12

To change the size of a control on a report,simply select the control and use the sizing handles to adjust the size.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is not a fixed number choice provided by the Top Values query?

Accepted Answer

A)  5 
B)  25 
C)  75 
D)  100 
A)  5 
B)  25 
C)  75 
D)  100

Question 14

A parameter report asks the user to enter the specific criteria value for a field when the report is run.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following statements is true about queries?

Accepted Answer

A)  As the number of records in your database increases,you can use query properties to limit the number of records that display in a result. 
B)  As the processing of your database becomes more sophisticated,you may need to write queries that use more complex functions. 
C)  Queries provide a great deal of power and flexibility to help you accomplish many tasks in your database. 
D)  all of the above 
A)  As the number of records in your database increases,you can use query properties to limit the number of records that display in a result. 
B)  As the processing of your database becomes more sophisticated,you may need to write queries that use more complex functions. 
C)  Queries provide a great deal of power and flexibility to help you accomplish many tasks in your database. 
D)  all of the above

Question 16

In a report that shows data from a one-to-many relationship,which of the following is a report from the "one" side of the relationship?

Accepted Answer

A)  subreport 
B)  main report 
C)  separate object 
D)  SQL object 
A)  subreport 
B)  main report 
C)  separate object 
D)  SQL object

Question 17

Which of the following might you use when you have a common starting point (the original query)but want to customize it for additional purposes (the additional query)?

Accepted Answer

A)  parameter report 
B)  subquery 
C)  wildcard 
D)  control 
A)  parameter report 
B)  subquery 
C)  wildcard 
D)  control

Question 18

Creating a report in Layout view provides you with the most flexibility.

Accepted Answer

A) True 
 B)False

Question 19

In an update query,unlike the Criteria row,the Update To row is not case sensitive.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following can you use in your criteria to look for partial matches?

Accepted Answer

A)  parameter reports 
B)  subqueries 
C)  wildcards 
D)  controls 
A)  parameter reports 
B)  subqueries 
C)  wildcards 
D)  controls

Which of the following Access date functions determines a specific piece,or interval,of a date?

Why is it sometimes necessary to change the height of a report section?

Which of the following report sections prints the group title/ value at the top of each group?

You can place calculated controls in any section of a report.

Which of the following lets you select more than one control at once?

Which of the following would you use to hide repeated values in a report?

Access evaluates expressions with the standard order of operations.

While you could modify each record individually in a table,an update query allows you to make the change to all records using one command.

Which of the following must you use to view the expression inside a calculated control?

What is a subreport? How do they work?

While displaying a report in Design view,which of the following opens the Property Sheet?

To change the size of a control on a report,simply select the control and use the sizing handles to adjust the size.

Which of the following is not a fixed number choice provided by the Top Values query?

A parameter report asks the user to enter the specific criteria value for a field when the report is run.

Which of the following statements is true about queries?

In a report that shows data from a one-to-many relationship,which of the following is a report from the "one" side of the relationship?

Which of the following might you use when you have a common starting point (the original query)but want to customize it for additional purposes (the additional query)?

Creating a report in Layout view provides you with the most flexibility.

In an update query,unlike the Criteria row,the Update To row is not case sensitive.

Which of the following can you use in your criteria to look for partial matches?

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters

Exam 5: Templates, Advanced Relationships, and Macros

Which of the following Access date functions determines a specific piece,or interval,of a date?

Why is it sometimes necessary to change the height of a report section?

Which of the following report sections prints the group title/ value at the top of each group?

You can place calculated controls in any section of a report.

Which of the following lets you select more than one control at once?

Which of the following would you use to hide repeated values in a report?

Access evaluates expressions with the standard order of operations.

While you could modify each record individually in a table,an update query allows you to make the change to all records using one command.

Which of the following must you use to view the expression inside a calculated control?

What is a subreport? How do they work?

While displaying a report in Design view,which of the following opens the Property Sheet?

To change the size of a control on a report,simply select the control and use the sizing handles to adjust the size.

Which of the following is not a fixed number choice provided by the Top Values query?

A parameter report asks the user to enter the specific criteria value for a field when the report is run.

Which of the following statements is true about queries?

In a report that shows data from a one-to-many relationship,which of the following is a report from the "one" side of the relationship?

Which of the following might you use when you have a common starting point (the original query)but want to customize it for additional purposes (the additional query)?

Creating a report in Layout view provides you with the most flexibility.

In an update query,unlike the Criteria row,the Update To row is not case sensitive.

Which of the following can you use in your criteria to look for partial matches?

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Queries

Creating and Using Forms and Reports

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters