Question 1

When selecting a particular data field to include in a report using the report wizard,you should click on the ► button.

Accepted Answer

A) True 
 B)False

Question 2

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 3

A report may be created that is based on a query instead of a table.

Accepted Answer

A) True 
 B)False

Question 4

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 5

Reports enable users to:

Accepted Answer

A) See a paper output of database information 
B) Change information in the underlying database tables 
C) Limit the distribution of the information 
D) Tab from one data field to another at run time 
A) See a paper output of database information 
B) Change information in the underlying database tables 
C) Limit the distribution of the information 
D) Tab from one data field to another at run time

Question 6

Data field masks help prevent users from entering incorrect values.

Accepted Answer

A) True 
 B)False

Question 7

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 8

Which of these is not an example of a control break?

Accepted Answer

A) Changing a name of a client 
B) Change in department in an employee listing 
C) Change in service classification in a phone book listing 
D) Change in zip code in an address listing 
E)  none of these 
A) Changing a name of a client 
B) Change in department in an employee listing 
C) Change in service classification in a phone book listing 
D) Change in zip code in an address listing 
E)  none of these

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

The report wizard can create reports containing grouped data.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

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 14

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 15

The conventional naming prefix for report is "rept".

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

Which of these is not an example of a calculated field?

Accepted Answer

A) Unit cost of an item 
B) Grand total 
C) Sales tax 
D) Profit 
A) Unit cost of an item 
B) Grand total 
C) Sales tax 
D) Profit

Question 19

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

Accepted Answer

A) True 
 B)False

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

When selecting a particular data field to include in a report using the report wizard,you should click on the ► button.

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

A report may be created that is based on a query instead of a table.

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

Reports enable users to:

Data field masks help prevent users from entering incorrect values.

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.

Which of these is not an example of a control break?

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

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

The report wizard can create reports containing grouped data.

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

Which of these features is desirable in database form design?

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

The conventional naming prefix for report is "rept".

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

If you misspell a field name,Access will:

Which of these is not an example of a calculated field?

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

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

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

When selecting a particular data field to include in a report using the report wizard,you should click on the ► button.

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

A report may be created that is based on a query instead of a table.

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

Reports enable users to:

Data field masks help prevent users from entering incorrect values.

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.

Which of these is not an example of a control break?

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

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

The report wizard can create reports containing grouped data.

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

Which of these features is desirable in database form design?

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

The conventional naming prefix for report is "rept".

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

If you misspell a field name,Access will:

Which of these is not an example of a calculated field?

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

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

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