Question 1

In Access, you can create a "report" that displays the name and address of only a single vendor.

Accepted Answer

A) True 
 B)False  True

Question 2

When referencing data fields in queries using Access, square brackets around the field name indicate a reference to an existing data field.

Accepted Answer

A) True 
 B)False  True

Question 3

Which punctuation mark delineates the separation between a calculated field name and the formula for that field?

Accepted Answer

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

Question 4

Assume that your manager has asked you to improve the efficiency and effectiveness of data entry for sales invoices by adding capabilities to the firm's Access database.In order to allow data entry for each invoice and multiple items on each invoice, you should create a:

Accepted Answer

A) Table 
B) Query 
C) Form without a subform 
D) Form with a subform 
E) Report 
A) Table 
B) Query 
C) Form without a subform 
D) Form with a subform 
E) Report

Question 5

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, provided that all the values in the report are positive 
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, provided that all the values in the report are positive 
D) A report can contain a subform within it 
E) You can embed pictures or other icons in a report header

Question 6

It's usually easier to create a database form from scratch.

Accepted Answer

A) True 
 B)False

Question 7

When using the Form Wizard in Microsoft Access, which of these is not a step in creating a new form?

Accepted Answer

A) Entering design settings such as the layout of the form 
B) Identifying the underlying table or query to use for the form 
C) Designing data validation tests for the form to perform for data entries 
D) Naming the form 
A) Entering design settings such as the layout of the form 
B) Identifying the underlying table or query to use for the form 
C) Designing data validation tests for the form to perform for data entries 
D) Naming the form

Question 8

Existing paper-based forms can help guide the creation of electronic database forms.

Accepted Answer

A) True 
 B)False

Question 9

Which of these is likely to appear last in a report?

Accepted Answer

A) Page header 
B) Group header 
C) Detail lines 
D) Report header 
E) any of these could be last 
A) Page header 
B) Group header 
C) Detail lines 
D) Report header 
E) any of these could be last

Question 10

If you misspell a field name, Access will:

Accepted Answer

A) Correct you 
B) Indicate an error 
C) Assume you are creating a parameter query 
D) none of these 
A) Correct you 
B) Indicate an error 
C) Assume you are creating a parameter query 
D) none of these

Question 11

The name of a form may contain spaces and capitalized characters.

Accepted Answer

A) True 
 B)False

Question 12

The report wizard can create reports containing grouped data.

Accepted Answer

A) True 
 B)False

Question 13

A report must contain all the information found in the records of the underlying table on which it is based.

Accepted Answer

A) True 
 B)False

Question 14

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 15

The Access navigation bar in a form allows access to any stored record.

Accepted Answer

A) True 
 B)False

Question 16

The point at which a group changes from one type to the next in a report is referred to as:

Accepted Answer

A) Lucky break 
B) Lunch break 
C) Choke point 
D) Control break 
A) Lucky break 
B) Lunch break 
C) Choke point 
D) Control break

Question 17

One way to create a subform is to:

Accepted Answer

A) Simply create a new table 
B) Identify the subform when you use the Form Wizard 
C) Utilize MySQL databases 
D) Add a subform to a printed report 
A) Simply create a new table 
B) Identify the subform when you use the Form Wizard 
C) Utilize MySQL databases 
D) Add a subform to a printed report

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The first step in creating a report is actually planning the layout of the report.

Accepted Answer

A) True 
 B)False

Question 20

Forms are not capable of which of the following?

Accepted Answer

A) Read-only display 
B) Auto-complete features 
C) Validating input 
D) Preventing all entry errors 
A) Read-only display 
B) Auto-complete features 
C) Validating input 
D) Preventing all entry errors

In Access, you can create a "report" that displays the name and address of only a single vendor.

When referencing data fields in queries using Access, square brackets around the field name indicate a reference to an existing data field.

Which punctuation mark delineates the separation between a calculated field name and the formula for that field?

Assume that your manager has asked you to improve the efficiency and effectiveness of data entry for sales invoices by adding capabilities to the firm's Access database.In order to allow data entry for each invoice and multiple items on each invoice, you should create a:

Which of the following statements is not correct?

It's usually easier to create a database form from scratch.

When using the Form Wizard in Microsoft Access, which of these is not a step in creating a new form?

Existing paper-based forms can help guide the creation of electronic database forms.

Which of these is likely to appear last in a report?

If you misspell a field name, Access will:

The name of a form may contain spaces and capitalized characters.

The report wizard can create reports containing grouped data.

A report must contain all the information found in the records of the underlying table on which it is based.

What is the first step in creating a report?

The Access navigation bar in a form allows access to any stored record.

The point at which a group changes from one type to the next in a report is referred to as:

One way to create a subform is to:

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

The first step in creating a report is actually planning the layout of the report.

Forms are not capable of which of the following?

Accounting Information Systems and the Accountant

Information Technology and Aiss

Data Modeling

Organizing and Manipulating the Data in Databases

Documenting Accounting Information Systems

Accounting Information Systems and Business Processes: Part I

Accounting Information Systems and Business Processes: Part II

Introduction to Internal Control Systems

Computer Controls for Organizations and Accounting Information Systems

Computer Crime, Fraud, Ethics, and Privacy

Information Technology Auditing

Developing and Implementing Effective Accounting Information Systems

Accounting on the Internet

Accounting and Enterprise Software

Filters

Exam 5: Database Forms and Reports

In Access, you can create a "report" that displays the name and address of only a single vendor.

When referencing data fields in queries using Access, square brackets around the field name indicate a reference to an existing data field.

Which punctuation mark delineates the separation between a calculated field name and the formula for that field?

Assume that your manager has asked you to improve the efficiency and effectiveness of data entry for sales invoices by adding capabilities to the firm's Access database.In order to allow data entry for each invoice and multiple items on each invoice, you should create a:

Which of the following statements is not correct?

It's usually easier to create a database form from scratch.

When using the Form Wizard in Microsoft Access, which of these is not a step in creating a new form?

Existing paper-based forms can help guide the creation of electronic database forms.

Which of these is likely to appear last in a report?

If you misspell a field name, Access will:

The name of a form may contain spaces and capitalized characters.

The report wizard can create reports containing grouped data.

A report must contain all the information found in the records of the underlying table on which it is based.

What is the first step in creating a report?

The Access navigation bar in a form allows access to any stored record.

The point at which a group changes from one type to the next in a report is referred to as:

One way to create a subform is to:

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

The first step in creating a report is actually planning the layout of the report.

Forms are not capable of which of the following?

Accounting Information Systems and the Accountant

Information Technology and Aiss

Data Modeling

Organizing and Manipulating the Data in Databases

Documenting Accounting Information Systems

Accounting Information Systems and Business Processes: Part I

Accounting Information Systems and Business Processes: Part II

Introduction to Internal Control Systems

Computer Controls for Organizations and Accounting Information Systems

Computer Crime, Fraud, Ethics, and Privacy

Information Technology Auditing

Developing and Implementing Effective Accounting Information Systems

Accounting on the Internet

Accounting and Enterprise Software

Filters