Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

The inability to delete a parent record if it has subordinate or "child records" in a relational database is enforced by using "Referential Integrity" in Microsoft Access.

Accepted Answer

A) True 
 B)False

Question 3

A car parts inventory database that includes a picture of the part itself as a graphic would most likely be stored in which type of database?

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 4

These databases can include graphics, audio, and animation:

Accepted Answer

A) Multidimensional databases 
B) Hierarchical databases 
C) Object-oriented databases 
D) Multimedia databases 
A) Multidimensional databases 
B) Hierarchical databases 
C) Object-oriented databases 
D) Multimedia databases

Question 5

A database developer can require Access to display records in an ascending sequence using this data field property:

Accepted Answer

A) Organize 
B) Index 
C) Reorganize 
D) Sequencing 
A) Organize 
B) Index 
C) Reorganize 
D) Sequencing

Question 6

In Access, the terms "size," "data type," and "input mask" are mostly closely associated with:

Accepted Answer

A) A table 
B) A record 
C) A data field 
D) A database 
A) A table 
B) A record 
C) A data field 
D) A database

Question 7

Using Access, which of the following is not a recognized data type?

Accepted Answer

A) Yes/No 
B) Year 
C) Currency 
D) Date 
A) Yes/No 
B) Year 
C) Currency 
D) Date

Question 8

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 9

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

Accepted Answer

A) True 
 B)False

Question 10

_________ 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

Question 11

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

Question 12

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 13

A DBMS is a type of hardware.

Accepted Answer

A) True 
 B)False

Question 14

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 15

Sorting and Indexing database records are similar in that:

Accepted Answer

A) Neither require underlying table records 
B) Both require the user to first define data validation rules 
C) Both reorganize the way record data appear in outputs 
D) none of these 
A) Neither require underlying table records 
B) Both require the user to first define data validation rules 
C) Both reorganize the way record data appear in outputs 
D) none of these

Question 16

Multimedia databases have rendered traditional text databases useless.

Accepted Answer

A) True 
 B)False

Question 17

You can instruct Access to display a particular error message if you use this property:

Accepted Answer

A) Validation rule 
B) Validation text 
C) Validation message 
D) Validation error 
A) Validation rule 
B) Validation text 
C) Validation message 
D) Validation error

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

A DBMS is a type of software.

Accepted Answer

A) True 
 B)False

Question 20

Sorting records are unlike indexing records in that:

Accepted Answer

A) Sorting physically rewrites records on disks whereas indexing does not 
B) Sorting requires a primary key whereas indexing does not 
C) Indexing requires a separate database file whereas sorting does not 
D) none of these 
A) Sorting physically rewrites records on disks whereas indexing does not 
B) Sorting requires a primary key whereas indexing does not 
C) Indexing requires a separate database file whereas sorting does not 
D) none of these

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

The inability to delete a parent record if it has subordinate or "child records" in a relational database is enforced by using "Referential Integrity" in Microsoft Access.

A car parts inventory database that includes a picture of the part itself as a graphic would most likely be stored in which type of database?

These databases can include graphics, audio, and animation:

A database developer can require Access to display records in an ascending sequence using this data field property:

In Access, the terms "size," "data type," and "input mask" are mostly closely associated with:

Using Access, which of the following is not a recognized data type?

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

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

_________ 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.

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?

A DBMS is a type of hardware.

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

Sorting and Indexing database records are similar in that:

Multimedia databases have rendered traditional text databases useless.

You can instruct Access to display a particular error message if you use this property:

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

A DBMS is a type of software.

Sorting records are unlike indexing records in that:

Accounting Information Systems and the Accountant

Information Technology and Aiss

Data Modeling

Database Forms and Reports

Documenting Accounting Information Systems

Accounting Information Systems and Business Processes: Part I

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 and Enterprise Software

Filters

Exam 4: Organizing and Manipulating the Data in Databases

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

The inability to delete a parent record if it has subordinate or "child records" in a relational database is enforced by using "Referential Integrity" in Microsoft Access.

A car parts inventory database that includes a picture of the part itself as a graphic would most likely be stored in which type of database?

These databases can include graphics, audio, and animation:

A database developer can require Access to display records in an ascending sequence using this data field property:

In Access, the terms "size," "data type," and "input mask" are mostly closely associated with:

Using Access, which of the following is not a recognized data type?

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

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

_________ 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.

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?

A DBMS is a type of hardware.

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

Sorting and Indexing database records are similar in that:

Multimedia databases have rendered traditional text databases useless.

You can instruct Access to display a particular error message if you use this property:

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

A DBMS is a type of software.

Sorting records are unlike indexing records in that:

Accounting Information Systems and the Accountant

Information Technology and Aiss

Data Modeling

Database Forms and Reports

Documenting Accounting Information Systems

Accounting Information Systems and Business Processes: Part I

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 and Enterprise Software

Filters