Question 1

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 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 data entries 
D) Naming the form

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

It's usually easier to create a database form from scratch instead of using the Wizard.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is not a part of a form?

Accepted Answer

A) A heading section 
B) A detail section 
C) A design section 
D) A navigation bar 
A) A heading section 
B) A detail section 
C) A design section 
D) A navigation bar

Question 5

Assume that salespeople at your firm make many errors when inputting sales data to the firm's Access database.Your manager has asked you to find a way to reduce data input errors.A good approach for reducing data entry errors would be to:

Accepted Answer

A) create one or more validation rules 
B) create one or more validation texts 
C) make sure that none of the data fields are required 
D) define several primary keys for each of the data fields containing errors 
E) make sure that every data field is a "short text" data type 
A) create one or more validation rules 
B) create one or more validation texts 
C) make sure that none of the data fields are required 
D) define several primary keys for each of the data fields containing errors 
E) make sure that every data field is a "short text" data type

Question 6

Which of the following is not an advantage of form data entry over datasheet data entry?

Accepted Answer

A) It is fast and efficient for data entry 
B) Accidental modification of adjacent records is not possible 
C) In Access, all the fields for a record are usually displayed on the same screen 
D) The forms are customizable by end users at run time 
A) It is fast and efficient for data entry 
B) Accidental modification of adjacent records is not possible 
C) In Access, all the fields for a record are usually displayed on the same screen 
D) The forms are customizable by end users at run time

Question 7

Which of the following would best minimize the vertical space used by a report?

Accepted Answer

A) Reduce vertical space between lines in the report header 
B) Reduce vertical space between lines in the detail portion 
C) Use smaller fonts in Text boxes 
D) all of these are equally efficient for this task 
A) Reduce vertical space between lines in the report header 
B) Reduce vertical space between lines in the detail portion 
C) Use smaller fonts in Text boxes 
D) all of these are equally efficient for this task

Question 8

Forms are the only method of entering data in a database.

Accepted Answer

A) True 
 B)False

Question 9

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 10

When referencing data fields in queries using Access, bracket symbols indicate a reference to an existing field.

Accepted Answer

A) True 
 B)False

Question 11

The changes that a user makes to the data in a form at run time do not alter the data in the underlying database table.

Accepted Answer

A) True 
 B)False

Question 12

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 13

Which of the following is not a guideline for creating professional data reports?

Accepted Answer

A) Plan before you program 
B) Provide different output formats for different languages 
C) Avoid garish colors and fonts 
D) Fit on one sheet of paper 
A) Plan before you program 
B) Provide different output formats for different languages 
C) Avoid garish colors and fonts 
D) Fit on one sheet of paper

Question 14

Which of these features is desirable in database form design?

Accepted Answer

A) Use garish colors to attract the user's attention 
B) Create forms that require several screens for display purposes 
C) Use unique fonts for different fields in the same form 
D) Resize data fields to ensure they display all the data in the underlying table 
A) Use garish colors to attract the user's attention 
B) Create forms that require several screens for display purposes 
C) Use unique fonts for different fields in the same form 
D) Resize data fields to ensure they display all the data in the underlying table

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

An invoice could be created with Microsoft Access by creating a form for the sales data and a subform for the items sold data.

Accepted Answer

A) True 
 B)False

Question 17

If you change an underlying value used in the calculated field of a report, the value of this calculated field in any subsequent copy of the report will also change.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Manual forms, in terms of database form design, are:

Accepted Answer

A) Archaic 
B) Used to guide the development of electronic forms 
C) Used to collect information electronically 
D) Used by many offices already 
A) Archaic 
B) Used to guide the development of electronic forms 
C) Used to collect information electronically 
D) Used by many offices already

Question 20

Which of these is not a section of a database report?

Accepted Answer

A) Report Header 
B) Page Header 
C) Detail lines 
D) Page Footer 
E) all of these are common sections of a database report 
A) Report Header 
B) Page Header 
C) Detail lines 
D) Page Footer 
E) all of these are common sections of a database report

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.

It's usually easier to create a database form from scratch instead of using the Wizard.

Which of the following is not a part of a form?

Assume that salespeople at your firm make many errors when inputting sales data to the firm's Access database.Your manager has asked you to find a way to reduce data input errors.A good approach for reducing data entry errors would be to:

Which of the following is not an advantage of form data entry over datasheet data entry?

Which of the following would best minimize the vertical space used by a report?

Forms are the only method of entering data in a database.

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:

When referencing data fields in queries using Access, bracket symbols indicate a reference to an existing field.

The changes that a user makes to the data in a form at run time do not alter the data in the underlying database table.

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

Which of the following is not a guideline for creating professional data reports?

Which of these features is desirable in database form design?

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

An invoice could be created with Microsoft Access by creating a form for the sales data and a subform for the items sold data.

If you change an underlying value used in the calculated field of a report, the value of this calculated field in any subsequent copy of the report will also change.

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

Manual forms, in terms of database form design, are:

Which of these is not a section of a database report?

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

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.

It's usually easier to create a database form from scratch instead of using the Wizard.

Which of the following is not a part of a form?

Assume that salespeople at your firm make many errors when inputting sales data to the firm's Access database.Your manager has asked you to find a way to reduce data input errors.A good approach for reducing data entry errors would be to:

Which of the following is not an advantage of form data entry over datasheet data entry?

Which of the following would best minimize the vertical space used by a report?

Forms are the only method of entering data in a database.

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:

When referencing data fields in queries using Access, bracket symbols indicate a reference to an existing field.

The changes that a user makes to the data in a form at run time do not alter the data in the underlying database table.

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

Which of the following is not a guideline for creating professional data reports?

Which of these features is desirable in database form design?

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

An invoice could be created with Microsoft Access by creating a form for the sales data and a subform for the items sold data.

If you change an underlying value used in the calculated field of a report, the value of this calculated field in any subsequent copy of the report will also change.

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

Manual forms, in terms of database form design, are:

Which of these is not a section of a database report?

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