Question 1

Use the Subform/ Subreport button to launch the SubReport Wizard to add the subreport.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following statements is not true about append queries?

Accepted Answer

A)  An append query moves records from one table to another. 
B)  An append query puts a copy of the records into a destination table. 
C)  An append query adds records into an existing table in a database. 
D)  Using an append query,you can copy records from one or multiple tables into the destination table. 
A)  An append query moves records from one table to another. 
B)  An append query puts a copy of the records into a destination table. 
C)  An append query adds records into an existing table in a database. 
D)  Using an append query,you can copy records from one or multiple tables into the destination table.

Question 3

Which of the following formatting properties of a control sets the fill color of a control?

Accepted Answer

A)  Decimal Places 
B)  Visible 
C)  Back Color 
D)  Fore Color 
A)  Decimal Places 
B)  Visible 
C)  Back Color 
D)  Fore Color

Question 4

An action query makes a temporary change to the data in the database and the Undo button is available to reverse the action.

Accepted Answer

A) True 
 B)False

Question 5

How many types of action queries are there in Access?

Accepted Answer

A)  two 
B)  three 
C)  four 
D)  five 
A)  two 
B)  three 
C)  four 
D)  five

Question 6

What steps are involved in create a report that includes a subreport?

Accepted Answer

A)  Create the main report. 
B)  Create the subreport. 
C)  Add the subreport to the main report. 
D)  all of the above 
A)  Create the main report. 
B)  Create the subreport. 
C)  Add the subreport to the main report. 
D)  all of the above

Question 7

The report from the "one" side of the relationship is the main report,while the report from the "many" side of the relationship is the subreport.

Accepted Answer

A) True 
 B)False

Question 8

When the report is in Design view,the expression is visible inside of the control.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following would you use to create a history table,which you could then use to store old records?

Accepted Answer

A)  update query 
B)  append query 
C)  delete query 
D)  make table query 
A)  update query 
B)  append query 
C)  delete query 
D)  make table query

Question 10

Which of the following formatting properties of a control sets the font color?

Accepted Answer

A)  Decimal Places 
B)  Visible 
C)  Back Color 
D)  Fore Color 
A)  Decimal Places 
B)  Visible 
C)  Back Color 
D)  Fore Color

Question 11

Which of the following can you use to compare records in two tables and determine which ones are not matched?

Accepted Answer

A)  Query Wizard 
B)  crosstab query 
C)  find duplicates query 
D)  unmatched records query 
A)  Query Wizard 
B)  crosstab query 
C)  find duplicates query 
D)  unmatched records query

Question 12

It is a good practice to make a backup copy of your database before you run any action query.

Accepted Answer

A) True 
 B)False

Question 13

A calculated control contains an expression in the Control Source property.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following would you use to combine the first and last name fields to produce a more readable report?

Accepted Answer

A)  concatenation 
B)  running total 
C)  one-to-many relationship 
D)  SQL 
A)  concatenation 
B)  running total 
C)  one-to-many relationship 
D)  SQL

Question 15

Which of the following deletes records from a table in a database?

Accepted Answer

A)  update query 
B)  append query 
C)  delete query 
D)  make table query 
A)  update query 
B)  append query 
C)  delete query 
D)  make table query

Question 16

Which of the following report sections prints column headings,page numbers,or dates at the top of every page?

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 17

Which of the following regulates which database fields are available in a report?

Accepted Answer

A)  Top Values query 
B)  Record Source property 
C)  Structured Query Language 
D)  Query Wizard 
A)  Top Values query 
B)  Record Source property 
C)  Structured Query Language 
D)  Query Wizard

Question 18

To number rows using a running total,which of the following should you type in the Control Source property?

Accepted Answer

A)  =1 
B)  =2 
C)  =3 
D)  =4 
A)  =1 
B)  =2 
C)  =3 
D)  =4

Question 19

In a crosstab query,what is the maximum number of fields that you can include as row headings?

Accepted Answer

A)  two 
B)  three 
C)  four 
D)  five 
A)  two 
B)  three 
C)  four 
D)  five

Question 20

Which of the following operators is used to concatenate data?

Accepted Answer

A)  [ 
B)  + 
C)  & 
D)  ( 
A)  [ 
B)  + 
C)  & 
D)  (

Use the Subform/ Subreport button to launch the SubReport Wizard to add the subreport.

Which of the following statements is not true about append queries?

Which of the following formatting properties of a control sets the fill color of a control?

An action query makes a temporary change to the data in the database and the Undo button is available to reverse the action.

How many types of action queries are there in Access?

What steps are involved in create a report that includes a subreport?

The report from the "one" side of the relationship is the main report,while the report from the "many" side of the relationship is the subreport.

When the report is in Design view,the expression is visible inside of the control.

Which of the following would you use to create a history table,which you could then use to store old records?

Which of the following formatting properties of a control sets the font color?

Which of the following can you use to compare records in two tables and determine which ones are not matched?

It is a good practice to make a backup copy of your database before you run any action query.

A calculated control contains an expression in the Control Source property.

Which of the following would you use to combine the first and last name fields to produce a more readable report?

Which of the following deletes records from a table in a database?

Which of the following report sections prints column headings,page numbers,or dates at the top of every page?

Which of the following regulates which database fields are available in a report?

To number rows using a running total,which of the following should you type in the Control Source property?

In a crosstab query,what is the maximum number of fields that you can include as row headings?

Which of the following operators is used to concatenate data?

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

Use the Subform/ Subreport button to launch the SubReport Wizard to add the subreport.

Which of the following statements is not true about append queries?

Which of the following formatting properties of a control sets the fill color of a control?

An action query makes a temporary change to the data in the database and the Undo button is available to reverse the action.

How many types of action queries are there in Access?

What steps are involved in create a report that includes a subreport?

The report from the "one" side of the relationship is the main report,while the report from the "many" side of the relationship is the subreport.

When the report is in Design view,the expression is visible inside of the control.

Which of the following would you use to create a history table,which you could then use to store old records?

Which of the following formatting properties of a control sets the font color?

Which of the following can you use to compare records in two tables and determine which ones are not matched?

It is a good practice to make a backup copy of your database before you run any action query.

A calculated control contains an expression in the Control Source property.

Which of the following would you use to combine the first and last name fields to produce a more readable report?

Which of the following deletes records from a table in a database?

Which of the following report sections prints column headings,page numbers,or dates at the top of every page?

Which of the following regulates which database fields are available in a report?

To number rows using a running total,which of the following should you type in the Control Source property?

In a crosstab query,what is the maximum number of fields that you can include as row headings?

Which of the following operators is used to concatenate data?

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