Question 1

What is a parameter report? Why are parameter reports useful?

Accepted Answer

Using parameter queries can increase the efficiency and flexibility of your database.By creating a parameter report,you can also apply those benefits to the reports in your database.A parameter report asks the user to enter the specific criteria value for a field when the report is run.This allows you to create one report but have the contents displayed vary based on the value of the parameter that is entered.Also,the parameter text is enclosed inside of square brackets in the criteria row of the desired field.

Question 2

In a Top Values query,which of the following is necessary to return the bottom values?

Accepted Answer

A)  sorting the results in ascending order 
B)  sorting the results in descending order 
C)  sorting on the primary key 
D)  the top values will be returned automatically 
A)  sorting the results in ascending order 
B)  sorting the results in descending order 
C)  sorting on the primary key 
D)  the top values will be returned automatically B

Question 3

Which of the following is inserted within another report?

Accepted Answer

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

Question 4

Which of the following does Access automatically include when you create a report in Design view?

Accepted Answer

A)  Page Header section 
B)  Detail section 
C)  Page Footer section 
D)  all of the above 
A)  Page Header section 
B)  Detail section 
C)  Page Footer section 
D)  all of the above

Question 5

The serial number is designated by the number of days the date is from January 1,2000.

Accepted Answer

A) True 
 B)False

Question 6

A delete query deletes the entire record.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following statements is true about duplicate records?

Accepted Answer

A)  All duplicated data is not bad. 
B)  Even when you practice good database design,you still may end up with duplicated data. 
C)  If duplicate records are present,two or more records in a table share the same values. 
D)  all of the above 
A)  All duplicated data is not bad. 
B)  Even when you practice good database design,you still may end up with duplicated data. 
C)  If duplicate records are present,two or more records in a table share the same values. 
D)  all of the above

Question 8

The Top Values query property limits the number of records that display in a query answer.

Accepted Answer

A) True 
 B)False

Question 9

What is a subquery? Why are subqueries helpful?

Accepted Answer

The query examples used so far have all

Question 10

Which of the following would you use to give all employees a 2% pay raise?

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 11

When using an aggregate function in a report,where should you place the calculation?

Accepted Answer

A)  Report Header section 
B)  Report Footer section 
C)  Detail section 
D)  both A and B 
A)  Report Header section 
B)  Report Footer section 
C)  Detail section 
D)  both A and B

Question 12

Which of the following statement is true about action queries?

Accepted Answer

A)  An action query makes a permanent change to the data in the database. 
B)  You can use the Undo button to reverse the action. 
C)  It is not recommended to make a backup copy of your database before you run an action query. 
D)  all of the above 
A)  An action query makes a permanent change to the data in the database. 
B)  You can use the Undo button to reverse the action. 
C)  It is not recommended to make a backup copy of your database before you run an action query. 
D)  all of the above

Question 13

After you create a crosstab query with the Crosstab Query Wizard,you can edit it in Design view and make changes to any of the selections made during the wizard.

Accepted Answer

A) True 
 B)False

Question 14

The serial number Access assigns to a date is designated by the number of days the date is from _______________.

Accepted Answer

A)  January 1,1900 
B)  January 1,2000 
C)  December 31,1900 
D)  December 31,2000 
A)  January 1,1900 
B)  January 1,2000 
C)  December 31,1900 
D)  December 31,2000

Question 15

When you are viewing a report in Layout or Print Preview view,the sections are not as obvious as they are in Design view.

Accepted Answer

A) True 
 B)False

Question 16

Action queries do not display confirmation messages after the action is complete.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following displays query results in a row/ column format,which makes the data easier to read and understand?

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 18

Which of the following report sections prints report totals or other information at the end of the report?

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 19

If duplicate records are present,two or more records in a table share the same values.

Accepted Answer

A) True 
 B)False

Question 20

Unlike the resulting datasheet from a regular select query,you can edit the results from a crosstab query.

Accepted Answer

A) True 
 B)False

What is a parameter report? Why are parameter reports useful?

In a Top Values query,which of the following is necessary to return the bottom values?

Which of the following is inserted within another report?

Which of the following does Access automatically include when you create a report in Design view?

The serial number is designated by the number of days the date is from January 1,2000.

A delete query deletes the entire record.

Which of the following statements is true about duplicate records?

The Top Values query property limits the number of records that display in a query answer.

What is a subquery? Why are subqueries helpful?

Which of the following would you use to give all employees a 2% pay raise?

When using an aggregate function in a report,where should you place the calculation?

Which of the following statement is true about action queries?

After you create a crosstab query with the Crosstab Query Wizard,you can edit it in Design view and make changes to any of the selections made during the wizard.

The serial number Access assigns to a date is designated by the number of days the date is from _______________.

When you are viewing a report in Layout or Print Preview view,the sections are not as obvious as they are in Design view.

Action queries do not display confirmation messages after the action is complete.

Which of the following displays query results in a row/ column format,which makes the data easier to read and understand?

Which of the following report sections prints report totals or other information at the end of the report?

If duplicate records are present,two or more records in a table share the same values.

Unlike the resulting datasheet from a regular select query,you can edit the results from a crosstab query.

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

What is a parameter report? Why are parameter reports useful?

In a Top Values query,which of the following is necessary to return the bottom values?

Which of the following is inserted within another report?

Which of the following does Access automatically include when you create a report in Design view?

The serial number is designated by the number of days the date is from January 1,2000.

A delete query deletes the entire record.

Which of the following statements is true about duplicate records?

The Top Values query property limits the number of records that display in a query answer.

What is a subquery? Why are subqueries helpful?

Which of the following would you use to give all employees a 2% pay raise?

When using an aggregate function in a report,where should you place the calculation?

Which of the following statement is true about action queries?

After you create a crosstab query with the Crosstab Query Wizard,you can edit it in Design view and make changes to any of the selections made during the wizard.

The serial number Access assigns to a date is designated by the number of days the date is from _______________.

When you are viewing a report in Layout or Print Preview view,the sections are not as obvious as they are in Design view.

Action queries do not display confirmation messages after the action is complete.

Which of the following displays query results in a row/ column format,which makes the data easier to read and understand?

Which of the following report sections prints report totals or other information at the end of the report?

If duplicate records are present,two or more records in a table share the same values.

Unlike the resulting datasheet from a regular select query,you can edit the results from a crosstab query.

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