Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

The button with symbol "►│" on the navigation bar gets you to the first form in the table.

Accepted Answer

A) True 
 B)False

Question 5

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 6

In Access,forms allow users only to view database information,but not change it.

Accepted Answer

A) True 
 B)False

Question 7

Suppose an employee's date of hire is changed in an employee table.When a database user subsequently runs a report showing the number of years the employee has worked for the company (a calculated field),what will happen?

Accepted Answer

A) Nothing.The same value that was calculated in any prior report will continue to show in the new report 
B) The new report will show a new calculated value 
C) The new report will show the average of the original value and the new value 
D) This depends upon other settings not indicated in the statement 
A) Nothing.The same value that was calculated in any prior report will continue to show in the new report 
B) The new report will show a new calculated value 
C) The new report will show the average of the original value and the new value 
D) This depends upon other settings not indicated in the statement

Question 8

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 9

Grouping like data together is a useful guideline to follow when creating usable forms.

Accepted Answer

A) True 
 B)False

Question 10

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 11

A report can combine the information from various tables in a database.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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 14

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 create a:

Accepted Answer

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

Question 15

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 16

Which of these sections of a database report is likely to occupy the most room on a report?

Accepted Answer

A) Report Header 
B) Page Header 
C) Detail lines 
D) Page Footer 
E) Report Footer 
A) Report Header 
B) Page Header 
C) Detail lines 
D) Page Footer 
E) Report Footer

Question 17

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

Question 18

Calculated fields in reports use the information in external files exclusively.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Using Microsoft Access,the "PgUp" key on the computer's keyboard can be used to access the previous record in a form.

Accepted Answer

A) True 
 B)False

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

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

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

The button with symbol "►│" on the navigation bar gets you to the first form in the table.

One way to create a subform is to:

In Access,forms allow users only to view database information,but not change it.

Suppose an employee's date of hire is changed in an employee table.When a database user subsequently runs a report showing the number of years the employee has worked for the company (a calculated field),what will happen?

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.

Grouping like data together is a useful guideline to follow when creating usable forms.

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

A report can combine the information from various tables in a database.

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

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?

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 create a:

Which of the following statements is not correct?

Which of these sections of a database report is likely to occupy the most room on a report?

Forms are not capable of which of the following?

Calculated fields in reports use the information in external files exclusively.

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

Using Microsoft Access,the "PgUp" key on the computer's keyboard can be used to access the previous record in a form.

Accounting Information Systems and the Accountant

Information Technology and Aiss

Data Modeling

Organizing and Manipulating the Data in Databases

Documenting Accounting Information Systems

Documenting Accounting Information Systems

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 on the Internet

Filters

Exam 5: Database Forms and Reports

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

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

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

The button with symbol "►│" on the navigation bar gets you to the first form in the table.

One way to create a subform is to:

In Access,forms allow users only to view database information,but not change it.

Suppose an employee's date of hire is changed in an employee table.When a database user subsequently runs a report showing the number of years the employee has worked for the company (a calculated field),what will happen?

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.

Grouping like data together is a useful guideline to follow when creating usable forms.

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

A report can combine the information from various tables in a database.

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

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?

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 create a:

Which of the following statements is not correct?

Which of these sections of a database report is likely to occupy the most room on a report?

Forms are not capable of which of the following?

Calculated fields in reports use the information in external files exclusively.

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

Using Microsoft Access,the "PgUp" key on the computer's keyboard can be used to access the previous record in a form.

Accounting Information Systems and the Accountant

Information Technology and Aiss

Data Modeling

Organizing and Manipulating the Data in Databases

Documenting Accounting Information Systems

Documenting Accounting Information Systems

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 on the Internet

Filters