Question 1

The purpose of using validation tests in the record definition of a database is to:

Accepted Answer

A) Make sure the database works properly 
B) Avoid data entry errors 
C) Ensure normalized data 
D) Verify that the user is authorized to enter data in the database 
A) Make sure the database works properly 
B) Avoid data entry errors 
C) Ensure normalized data 
D) Verify that the user is authorized to enter data in the database

Question 2

To perform a range test of the "hours worked" data field for an employee, you should store the term "Between 0 and 40" in which of these properties in Access?

Accepted Answer

A) Text 
B) Testing procedure 
C) Validation rule 
D) Validation text 
A) Text 
B) Testing procedure 
C) Validation rule 
D) Validation text

Question 3

Database management systems allow their users to create "input masks" which help to prevent input errors.

Accepted Answer

A) True 
 B)False

Question 4

Database management systems are important to accountants because:

Accepted Answer

A) They automate file storage tasks and enable managers to generate worthwhile financial reports 
B) They eliminate data redundancy 
C) They are unique data structures which accountants have never used before 
D) They are easy to develop and therefore save money 
E) They are energy efficient 
A) They automate file storage tasks and enable managers to generate worthwhile financial reports 
B) They eliminate data redundancy 
C) They are unique data structures which accountants have never used before 
D) They are easy to develop and therefore save money 
E) They are energy efficient

Question 5

A school administrator wishes to select the names of all students who have taken at least 130 units of credit at your university to see if they qualify for graduation.Which of these is the best type of query to use for this task?

Accepted Answer

A) Append query 
B) Update query 
C) Make table query 
D) Select query 
E) Make report query 
A) Append query 
B) Update query 
C) Make table query 
D) Select query 
E) Make report query

Question 6

An OR operation (query)in Microsoft Access requires you to use multiple Criteria lines to create the query.

Accepted Answer

A) True 
 B)False

Question 7

Using Microsoft Access, you create a "one-to-many" relationship between "Customers" records and "Customer Orders" records.When you view the Customers records in a datasheet view, Access indicates the presence of these customer order records using this symbol:

Accepted Answer

A) & 
B) N 
C) √ 
D) ∞ 
E) + 
A) & 
B) N 
C) √ 
D) ∞ 
E) +

Question 8

A dynaset is the total set of records in a database table.

Accepted Answer

A) True 
 B)False

Question 9

When Access links records to one another in different tables, the foreign key in one record refers to the _______ in another record.

Accepted Answer

A) Primary key 
B) Secondary key 
C) Foreign key 
D) Linkage key 
A) Primary key 
B) Secondary key 
C) Foreign key 
D) Linkage key

Question 10

An exclamation point in the design menu of an Access query means to "run the query."

Accepted Answer

A) True 
 B)False

Question 11

A plus sign to the left of a database record in Access means there are related records linked to it.

Accepted Answer

A) True 
 B)False

Question 12

A disadvantage of database management systems is that:

Accepted Answer

A) They are not flexible 
B) They cannot be implemented on microcomputers 
C) They rarely support file inquiries 
D) They are often machine dependent (e.g., not all DBMSs can run on all types of computers) 
A) They are not flexible 
B) They cannot be implemented on microcomputers 
C) They rarely support file inquiries 
D) They are often machine dependent (e.g., not all DBMSs can run on all types of computers)

Question 13

You can increase the prices of selected products systematically using Microsoft's:

Accepted Answer

A) Append query 
B) Update query 
C) Make table query 
D) Delete query 
E) Select query 
A) Append query 
B) Update query 
C) Make table query 
D) Delete query 
E) Select query

Question 14

Using Microsoft Access, "referential integrity" enables you to delete a record on the "one" side of a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 15

Using Microsoft Access to create a select query with multiple criteria (all of which you want satisfied at the same time), you should specify them on the same Criteria line of the query.

Accepted Answer

A) True 
 B)False

Question 16

Quotation marks that appear around a search criteria (e.g., "New York"), indicates an error.

Accepted Answer

A) True 
 B)False

Question 17

All of these are examples of action queries that you can create in Microsoft Access except:

Accepted Answer

A) Append query 
B) Update query 
C) Make table query 
D) Delete query 
E) Validation query 
A) Append query 
B) Update query 
C) Make table query 
D) Delete query 
E) Validation query

Question 18

Select queries are, by definition, multi-table queries.

Accepted Answer

A) True 
 B)False

Question 19

One way to create an OR condition in a query is to place the search criteria on different lines of the query.

Accepted Answer

A) True 
 B)False

The purpose of using validation tests in the record definition of a database is to:

To perform a range test of the "hours worked" data field for an employee, you should store the term "Between 0 and 40" in which of these properties in Access?

Database management systems allow their users to create "input masks" which help to prevent input errors.

Database management systems are important to accountants because:

A school administrator wishes to select the names of all students who have taken at least 130 units of credit at your university to see if they qualify for graduation.Which of these is the best type of query to use for this task?

An OR operation (query)in Microsoft Access requires you to use multiple Criteria lines to create the query.

Using Microsoft Access, you create a "one-to-many" relationship between "Customers" records and "Customer Orders" records.When you view the Customers records in a datasheet view, Access indicates the presence of these customer order records using this symbol:

A dynaset is the total set of records in a database table.

When Access links records to one another in different tables, the foreign key in one record refers to the _______ in another record.

An exclamation point in the design menu of an Access query means to "run the query."

A plus sign to the left of a database record in Access means there are related records linked to it.

A disadvantage of database management systems is that:

You can increase the prices of selected products systematically using Microsoft's:

Using Microsoft Access, "referential integrity" enables you to delete a record on the "one" side of a one-to-many relationship.

Using Microsoft Access to create a select query with multiple criteria (all of which you want satisfied at the same time), you should specify them on the same Criteria line of the query.

Quotation marks that appear around a search criteria (e.g., "New York"), indicates an error.

All of these are examples of action queries that you can create in Microsoft Access except:

Select queries are, by definition, multi-table queries.

One way to create an OR condition in a query is to place the search criteria on different lines of the query.

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

Database Forms and Reports

Filters

Exam 15: Organizing and Manipulating the Data in Databases

The purpose of using validation tests in the record definition of a database is to:

To perform a range test of the "hours worked" data field for an employee, you should store the term "Between 0 and 40" in which of these properties in Access?

Database management systems allow their users to create "input masks" which help to prevent input errors.

Database management systems are important to accountants because:

A school administrator wishes to select the names of all students who have taken at least 130 units of credit at your university to see if they qualify for graduation.Which of these is the best type of query to use for this task?

An OR operation (query)in Microsoft Access requires you to use multiple Criteria lines to create the query.

Using Microsoft Access, you create a "one-to-many" relationship between "Customers" records and "Customer Orders" records.When you view the Customers records in a datasheet view, Access indicates the presence of these customer order records using this symbol:

A dynaset is the total set of records in a database table.

When Access links records to one another in different tables, the foreign key in one record refers to the _______ in another record.

An exclamation point in the design menu of an Access query means to "run the query."

A plus sign to the left of a database record in Access means there are related records linked to it.

A disadvantage of database management systems is that:

You can increase the prices of selected products systematically using Microsoft's:

Using Microsoft Access, "referential integrity" enables you to delete a record on the "one" side of a one-to-many relationship.

Using Microsoft Access to create a select query with multiple criteria (all of which you want satisfied at the same time), you should specify them on the same Criteria line of the query.

Quotation marks that appear around a search criteria (e.g., "New York"), indicates an error.

All of these are examples of action queries that you can create in Microsoft Access except:

Select queries are, by definition, multi-table queries.

One way to create an OR condition in a query is to place the search criteria on different lines of the query.

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

Database Forms and Reports

Filters