Question 1

Once you add a subreport,it still exists as a ____________________.

Accepted Answer

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

Question 2

Which of the following Access date functions determines the difference between two dates?

Accepted Answer

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

Question 3

Which of the following are controls that you can add to a report?

Accepted Answer

A)  text boxes 
B)  labels 
C)  lines 
D)  all of the above 
A)  text boxes 
B)  labels 
C)  lines 
D)  all of the above

Question 4

Unmatched records are records in one table that do not contain any matching records in a related table.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following font characteristics of a control can you change in the Property Sheet of that control?

Accepted Answer

A)  Font Name 
B)  Font Size 
C)  Font Underline 
D)  all of the above 
A)  Font Name 
B)  Font Size 
C)  Font Underline 
D)  all of the above

Question 6

Which of the following makes changes to the data 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 7

The Now()function retrieves the current date,including the time,from your computer.

Accepted Answer

A) True 
 B)False

Question 8

Provide some examples of when you might need to use an action query.

Accepted Answer

When creating action queries,it is impor

Question 9

When you open the main report,the subreport opens automatically because the objects are now attached.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following Access date functions converts values into a date value?

Accepted Answer

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

Question 11

Which of the following is a tool that makes it easier to build four different types of queries?

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

Which of the following is always used to surround parameter text in a parameter report?

Accepted Answer

A)  square brackets 
B)  plus signs 
C)  parentheses 
D)  dollar signs 
A)  square brackets 
B)  plus signs 
C)  parentheses 
D)  dollar signs

Question 13

What is a crosstab query? Why are crosstab queries useful?

Accepted Answer

A crosstab query summarizes data on two

Question 14

Which of the following can a running total field show?

Accepted Answer

A)  running balance 
B)  cumulative total 
C)  counting 
D)  all of the above 
A)  running balance 
B)  cumulative total 
C)  counting 
D)  all of the above

Question 15

Which of the following views will you want to use when you work to edit a report?

Accepted Answer

A)  Design view 
B)  Layout view 
C)  Print Preview view 
D)  all of the above 
A)  Design view 
B)  Layout view 
C)  Print Preview view 
D)  all of the above

Question 16

You can build the main report and the subreport in any order,but the most common approach is to build the main report first.

Accepted Answer

A) True 
 B)False

Question 17

In a concatenation formula,how would you insert a comma and a blank space between two fields?

Accepted Answer

A)  &" "& 
B)  &","& 
C)  =","& 
D)  [","] 
A)  &" "& 
B)  &","& 
C)  =","& 
D)  [","]

Question 18

Which of the following formatting properties of a control determines whether a control shows in Report view or Print Preview view?

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 19

Which of the following can you use calculated controls for?

Accepted Answer

A)  mathematical equations 
B)  aggregate functions 
C)  text-based equations 
D)  all of the above 
A)  mathematical equations 
B)  aggregate functions 
C)  text-based equations 
D)  all of the above

Question 20

What is concatenation and why might you want to use it?

Accepted Answer

Concatenation combines different parts o

Once you add a subreport,it still exists as a ____________________.

Which of the following Access date functions determines the difference between two dates?

Which of the following are controls that you can add to a report?

Unmatched records are records in one table that do not contain any matching records in a related table.

Which of the following font characteristics of a control can you change in the Property Sheet of that control?

Which of the following makes changes to the data in a database?

The Now()function retrieves the current date,including the time,from your computer.

Provide some examples of when you might need to use an action query.

When you open the main report,the subreport opens automatically because the objects are now attached.

Which of the following Access date functions converts values into a date value?

Which of the following is a tool that makes it easier to build four different types of queries?

Which of the following is always used to surround parameter text in a parameter report?

What is a crosstab query? Why are crosstab queries useful?

Which of the following can a running total field show?

Which of the following views will you want to use when you work to edit a report?

You can build the main report and the subreport in any order,but the most common approach is to build the main report first.

In a concatenation formula,how would you insert a comma and a blank space between two fields?

Which of the following formatting properties of a control determines whether a control shows in Report view or Print Preview view?

Which of the following can you use calculated controls for?

What is concatenation and why might you want to use it?

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

Once you add a subreport,it still exists as a ____________________.

Which of the following Access date functions determines the difference between two dates?

Which of the following are controls that you can add to a report?

Unmatched records are records in one table that do not contain any matching records in a related table.

Which of the following font characteristics of a control can you change in the Property Sheet of that control?

Which of the following makes changes to the data in a database?

The Now()function retrieves the current date,including the time,from your computer.

Provide some examples of when you might need to use an action query.

When you open the main report,the subreport opens automatically because the objects are now attached.

Which of the following Access date functions converts values into a date value?

Which of the following is a tool that makes it easier to build four different types of queries?

Which of the following is always used to surround parameter text in a parameter report?

What is a crosstab query? Why are crosstab queries useful?

Which of the following can a running total field show?

Which of the following views will you want to use when you work to edit a report?

You can build the main report and the subreport in any order,but the most common approach is to build the main report first.

In a concatenation formula,how would you insert a comma and a blank space between two fields?

Which of the following formatting properties of a control determines whether a control shows in Report view or Print Preview view?

Which of the following can you use calculated controls for?

What is concatenation and why might you want to use it?

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