Question 1

Forms do not allow customized organization of the data they display.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is not a possible way to customize a form?

Accepted Answer

A) Adding information to the Header of a form 
B) Adding artwork to a form 
C) Adding control buttons to the Title Bar of the form 
D) Using more complete names for fields 
A) Adding information to the Header of a form 
B) Adding artwork to a form 
C) Adding control buttons to the Title Bar of the form 
D) Using more complete names for fields

Question 3

When designing a form for an Access database, the term "Inheritance" refers to:

Accepted Answer

A) The propagation of properties and restrictions from the data field in the underlying table to the field in the form 
B) The propagation of properties and restrictions from the underlying table itself 
C) The ability of all the fields of the form to assume the same color 
D) none of these 
A) The propagation of properties and restrictions from the data field in the underlying table to the field in the form 
B) The propagation of properties and restrictions from the underlying table itself 
C) The ability of all the fields of the form to assume the same color 
D) none of these

Question 4

Using Microsoft Access, the "PgUp" button can be used to access the previous record in a form.
5.In Access, forms allow users only to view database information, but not change it.
Renumber all questions below and adjust solutions accordingly

Accepted Answer

A) True 
 B)False

Question 5

Using Microsoft Access, an accountant could include internal controls in the tables and in forms.

Accepted Answer

A) True 
 B)False

Question 6

Clicking the ▌◄ button on the navigation bar of a form causes Access to display:

Accepted Answer

A) The last record 
B) The record with the lowest primary key 
C) The record with the highest primary key 
D) The first record 
A) The last record 
B) The record with the lowest primary key 
C) The record with the highest primary key 
D) The first record

Question 7

A drop down menu on a form that allows the user to select a customer's state of residence is an example of:

Accepted Answer

A) A validation rule 
B) A bound control 
C) An unbound control 
D) A form's run mode 
A) A validation rule 
B) A bound control 
C) An unbound control 
D) A form's run mode

Question 8

Which of the following statements is not correct?

Accepted Answer

A) You can avoid using Access' Form Wizard and create a form from scratch 
B) A form can contain a subform 
C) A total value in a report footer will always be at least as large as any group footer value for the same data field 
D) A report can contain a subform within it 
E) You can embed pictures or other icons in a report header 
A) You can avoid using Access' Form Wizard and create a form from scratch 
B) A form can contain a subform 
C) A total value in a report footer will always be at least as large as any group footer value for the same data field 
D) A report can contain a subform within it 
E) You can embed pictures or other icons in a report header

Question 9

The problem with Access forms is that they cannot be customized.

Accepted Answer

A) True 
 B)False

Question 10

Reports can be modified after they are created.

Accepted Answer

A) True 
 B)False

Question 11

A report can only reference the data found in a single table-not the data from multiple tables.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following cannot be defined when using the Report Wizard in Microsoft Access?

Accepted Answer

A) Data source selection 
B) Grouping 
C) Sorting 
D) Format design 
E) all of these can be defined by the Report Wizard 
A) Data source selection 
B) Grouping 
C) Sorting 
D) Format design 
E) all of these can be defined by the Report Wizard

Question 13

Which punctuation mark separates the user-defined caption and the formula for a calculated field?

Accepted Answer

A) Colon 
B) Space 
C) Asterisk 
D) Dash 
A) Colon 
B) Space 
C) Asterisk 
D) Dash

Question 14

A rule of thumb in industry is that the cost to correct an error in a database is approximately how many times the cost of entering the data initially?

Accepted Answer

A) 3 
B) 5 
C) 7 
D) 10 
A) 3 
B) 5 
C) 7 
D) 10

Question 15

Which of the following is an example of a valid calculated field entry?

Accepted Answer

A) MyField = field1\field2 
B) MyField = field1/field2 
C) MyField: thisField/ThatField 
D) MyField: thisField\ThatField 
A) MyField = field1\field2 
B) MyField = field1/field2 
C) MyField: thisField/ThatField 
D) MyField: thisField\ThatField

Question 16

The Report Wizard can create reports containing grouped data.

Accepted Answer

A) True 
 B)False

Question 17

What is the first step in creating a report?

Accepted Answer

A) Determining what information to display 
B) Analyzing the available information 
C) Restructuring the database 
D) Analyzing the database 
A) Determining what information to display 
B) Analyzing the available information 
C) Restructuring the database 
D) Analyzing the database

Question 18

Formatting a report is usually a trivial task in Microsoft Access, requiring little time or effort.
Renumber all questions below and adjust solutions accordingly
Renumber all questions below and adjust solutions accordingly

Accepted Answer

A) True 
 B)False

Question 19

The Format menu in Access allows users to:

Accepted Answer

A) Resize objects 
B) Edit objects 
C) Align objects 
D) all of the above 
A) Resize objects 
B) Edit objects 
C) Align objects 
D) all of the above

Question 20

Assume that your manager has asked you to prepare a budget for your firm using data stored in an Access database.The best approach for creating the budget would be to use a:

Accepted Answer

A) Table 
B) Query 
C) Form 
D) Report 
E) SQL 
A) Table 
B) Query 
C) Form 
D) Report 
E) SQL

Forms do not allow customized organization of the data they display.

Which of the following is not a possible way to customize a form?

When designing a form for an Access database, the term "Inheritance" refers to:

Using Microsoft Access, the "PgUp" button can be used to access the previous record in a form. 5.In Access, forms allow users only to view database information, but not change it. Renumber all questions below and adjust solutions accordingly

Using Microsoft Access, an accountant could include internal controls in the tables and in forms.

Clicking the ▌◄ button on the navigation bar of a form causes Access to display:

A drop down menu on a form that allows the user to select a customer's state of residence is an example of:

Which of the following statements is not correct?

The problem with Access forms is that they cannot be customized.

Reports can be modified after they are created.

A report can only reference the data found in a single table-not the data from multiple tables.

Which of the following cannot be defined when using the Report Wizard in Microsoft Access?

Which punctuation mark separates the user-defined caption and the formula for a calculated field?

A rule of thumb in industry is that the cost to correct an error in a database is approximately how many times the cost of entering the data initially?

Which of the following is an example of a valid calculated field entry?

The Report Wizard can create reports containing grouped data.

What is the first step in creating a report?

Formatting a report is usually a trivial task in Microsoft Access, requiring little time or effort. Renumber all questions below and adjust solutions accordingly Renumber all questions below and adjust solutions accordingly

The Format menu in Access allows users to:

Assume that your manager has asked you to prepare a budget for your firm using data stored in an Access database.The best approach for creating the budget would be to use a:

Accounting Information Systems and the Accountant

Accounting on the Internet

Information Technology and Aiss

Accounting and Data Analytics

Integrated Accounting and Enterprise Software

Introduction to Internal Control Systems and Risk Management

Computer Controls for Organizations and Accounting Information Systems

Accounting Information Systems and Business Processes: Part I

Accounting Information Systems and Business Processes: Part II

Cybercrime, Fraud, and Ethics

Information Technology Auditing

Documenting Accounting Information Systems

Developing and Implementing Effective Accounting Information Systems

Database Design

Organizing and Manipulating the Data in Databases

Filters

Exam 16: Database Forms and Reports

Forms do not allow customized organization of the data they display.

Which of the following is not a possible way to customize a form?

When designing a form for an Access database, the term "Inheritance" refers to:

Using Microsoft Access, the "PgUp" button can be used to access the previous record in a form. 5.In Access, forms allow users only to view database information, but not change it. Renumber all questions below and adjust solutions accordingly

Using Microsoft Access, an accountant could include internal controls in the tables and in forms.

Clicking the ▌◄ button on the navigation bar of a form causes Access to display:

A drop down menu on a form that allows the user to select a customer's state of residence is an example of:

Which of the following statements is not correct?

The problem with Access forms is that they cannot be customized.

Reports can be modified after they are created.

A report can only reference the data found in a single table-not the data from multiple tables.

Which of the following cannot be defined when using the Report Wizard in Microsoft Access?

Which punctuation mark separates the user-defined caption and the formula for a calculated field?

A rule of thumb in industry is that the cost to correct an error in a database is approximately how many times the cost of entering the data initially?

Which of the following is an example of a valid calculated field entry?

The Report Wizard can create reports containing grouped data.

What is the first step in creating a report?

Formatting a report is usually a trivial task in Microsoft Access, requiring little time or effort. Renumber all questions below and adjust solutions accordingly Renumber all questions below and adjust solutions accordingly

The Format menu in Access allows users to:

Assume that your manager has asked you to prepare a budget for your firm using data stored in an Access database.The best approach for creating the budget would be to use a:

Accounting Information Systems and the Accountant

Accounting on the Internet

Information Technology and Aiss

Accounting and Data Analytics

Integrated Accounting and Enterprise Software

Introduction to Internal Control Systems and Risk Management

Computer Controls for Organizations and Accounting Information Systems

Accounting Information Systems and Business Processes: Part I

Accounting Information Systems and Business Processes: Part II

Cybercrime, Fraud, and Ethics

Information Technology Auditing

Documenting Accounting Information Systems

Developing and Implementing Effective Accounting Information Systems

Database Design

Organizing and Manipulating the Data in Databases

Filters