Question 1

A database schema is a plan of the entire database.

Accepted Answer

A) True 
 B)False  True

Question 2

_________ is an Access tool that prohibits users from deleting parent records with child records (i.e.,records related in a one-to-many relationship).

Accepted Answer

A) Referential integrity 
B) Mnemonic naming 
C) Integrative relationships 
D) Data typing 
E) none of these is correct 
A) Referential integrity 
B) Mnemonic naming 
C) Integrative relationships 
D) Data typing 
E) none of these is correct A

Question 3

A good primary record key to use for a table of employee records that you might create in Access is the employee's last name.

Accepted Answer

A) True 
 B)False  False

Question 4

A template that you can create in Microsoft Access and that prompts users for expected values is called a "mask."

Accepted Answer

A) True 
 B)False

Question 5

An example of a data type for a database record field is "Memo."

Accepted Answer

A) True 
 B)False

Question 6

If you require a data entry in an Access database to fall between two dates (rather than between two numeric values):

Accepted Answer

A) You should use a select query using one line 
B) You should use a select query,using two lines 
C) You should use a validation rule and the word "between" 
D) This is impossible to require in Access 
A) You should use a select query using one line 
B) You should use a select query,using two lines 
C) You should use a validation rule and the word "between" 
D) This is impossible to require in Access

Question 7

Database designers typically store employee Social Security numbers as "Long Integer" data types.

Accepted Answer

A) True 
 B)False

Question 8

A DBMS is a type of software.

Accepted Answer

A) True 
 B)False

Question 9

A useful guideline to follow when creating data fields containing text is to limit data fields to reasonable lengths.

Accepted Answer

A) True 
 B)False

Question 10

Database management systems are important to accountants because:

Accepted Answer

A) They automate file storage tasks and enable accountants 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 accountants 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 11

Which of these types of databases might also store instructions that indicate how to compute an employee's net pay?

Accepted Answer

A) Multidimensional database 
B) Hierarchical database 
C) Object oriented database 
D) Data dictionary 
A) Multidimensional database 
B) Hierarchical database 
C) Object oriented database 
D) Data dictionary

Question 12

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 13

An append query in Microsoft Access is an example of an action query that enables you to systematically add the term "Jr." to individual names in a customer database.

Accepted Answer

A) True 
 B)False

Question 14

You could append the term "Jr." to selected names in a customer database using Microsoft's:

Accepted Answer

A) Append query 
B) Update query 
C) Make table query 
D) Select query 
E) none of these (this is not possible using an action query) 
A) Append query 
B) Update query 
C) Make table query 
D) Select query 
E) none of these (this is not possible using an action query)

Question 15

An example of an input mask for an Access data field is "000\-00\-0000."

Accepted Answer

A) True 
 B)False

Question 16

To create a relationship between two tables in Microsoft Access,you should use the Queries window.

Accepted Answer

A) True 
 B)False

Question 17

An example of a data type for a data field in the record of an Access table is "Number."

Accepted Answer

A) True 
 B)False

Question 18

A useful guideline to follow when creating data fields containing text is to assign at least 50 characters to it.

Accepted Answer

A) True 
 B)False

Question 19

Microsoft Access is an example of a database,not a database management system.

Accepted Answer

A) True 
 B)False

Question 20

Microsoft Access uses a key symbol to identify the primary record key in a database table.

Accepted Answer

A) True 
 B)False

A database schema is a plan of the entire database.

_________ is an Access tool that prohibits users from deleting parent records with child records (i.e.,records related in a one-to-many relationship).

A good primary record key to use for a table of employee records that you might create in Access is the employee's last name.

A template that you can create in Microsoft Access and that prompts users for expected values is called a "mask."

An example of a data type for a database record field is "Memo."

If you require a data entry in an Access database to fall between two dates (rather than between two numeric values):

Database designers typically store employee Social Security numbers as "Long Integer" data types.

A DBMS is a type of software.

A useful guideline to follow when creating data fields containing text is to limit data fields to reasonable lengths.

Database management systems are important to accountants because:

Which of these types of databases might also store instructions that indicate how to compute an employee's net pay?

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 append query in Microsoft Access is an example of an action query that enables you to systematically add the term "Jr." to individual names in a customer database.

You could append the term "Jr." to selected names in a customer database using Microsoft's:

An example of an input mask for an Access data field is "000\-00\-0000."

To create a relationship between two tables in Microsoft Access,you should use the Queries window.

An example of a data type for a data field in the record of an Access table is "Number."

A useful guideline to follow when creating data fields containing text is to assign at least 50 characters to it.

Microsoft Access is an example of a database,not a database management system.

Microsoft Access uses a key symbol to identify the primary record key in a database table.

Accounting Information Systems and the Accountant

Information Technology and Aiss

Data Modeling

Database Forms and Reports

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 4: Organizing and Manipulating the Data in Databases

A database schema is a plan of the entire database.

_________ is an Access tool that prohibits users from deleting parent records with child records (i.e.,records related in a one-to-many relationship).

A good primary record key to use for a table of employee records that you might create in Access is the employee's last name.

A template that you can create in Microsoft Access and that prompts users for expected values is called a "mask."

An example of a data type for a database record field is "Memo."

If you require a data entry in an Access database to fall between two dates (rather than between two numeric values):

Database designers typically store employee Social Security numbers as "Long Integer" data types.

A DBMS is a type of software.

A useful guideline to follow when creating data fields containing text is to limit data fields to reasonable lengths.

Database management systems are important to accountants because:

Which of these types of databases might also store instructions that indicate how to compute an employee's net pay?

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 append query in Microsoft Access is an example of an action query that enables you to systematically add the term "Jr." to individual names in a customer database.

You could append the term "Jr." to selected names in a customer database using Microsoft's:

An example of an input mask for an Access data field is "000\-00\-0000."

To create a relationship between two tables in Microsoft Access,you should use the Queries window.

An example of a data type for a data field in the record of an Access table is "Number."

A useful guideline to follow when creating data fields containing text is to assign at least 50 characters to it.

Microsoft Access is an example of a database,not a database management system.

Microsoft Access uses a key symbol to identify the primary record key in a database table.

Accounting Information Systems and the Accountant

Information Technology and Aiss

Data Modeling

Database Forms and Reports

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