Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

One purpose of a data manipulation language is to:

Accepted Answer

A) Create data fields 
B) Define the record structure 
C) Create queries on the data 
D) all of these 
A) Create data fields 
B) Define the record structure 
C) Create queries on the data 
D) all of these

Question 4

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 5

A delete query in Microsoft Access is an example of an action query that enables you to delete all those records in a table satisfying specific criteria.

Accepted Answer

A) True 
 B)False

Question 6

Database management systems can be implemented on:

Accepted Answer

A) Mainframe computers only 
B) Mainframe and minicomputers only 
C) Mainframes, minicomputers, and microcomputers 
D) Microcomputers only 
A) Mainframe computers only 
B) Mainframe and minicomputers only 
C) Mainframes, minicomputers, and microcomputers 
D) Microcomputers only

Question 7

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 8

As a general rule, creating data warehouses is:

Accepted Answer

A) Easy 
B) Habit forming 
C) Challenging but often worth the cost 
D) Challenging, and historically rarely worth the cost 
A) Easy 
B) Habit forming 
C) Challenging but often worth the cost 
D) Challenging, and historically rarely worth the cost

Question 9

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 10

All of the following are advantages of drop-down boxes in Access except:

Accepted Answer

A) It limits users to valid input choices 
B) It takes a small amount of room, even if the number of choices is large 
C) It always limits users to numeric entries 
D) The entries for the combo box can be stored in a separate table 
A) It limits users to valid input choices 
B) It takes a small amount of room, even if the number of choices is large 
C) It always limits users to numeric entries 
D) The entries for the combo box can be stored in a separate table

Question 11

Pivot tables are powerful statistical tools, but allow the user little flexibility in selecting what data can be analyzed.

Accepted Answer

A) True 
 B)False

Question 12

Another word for "cleaning" the data in preparation for storing it in a data warehouse in order to ensure uniform accuracy is:

Accepted Answer

A) Scrubbing 
B) Sanitizing 
C) Validating 
D) Coding 
A) Scrubbing 
B) Sanitizing 
C) Validating 
D) Coding

Question 13

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 14

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 15

If creating a data mart is not cost effective, management should consider creating a data warehouse, which typically uses less money and time to design.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

A DBMS is an efficient database table in third normal form.

Accepted Answer

A) True 
 B)False

Question 18

When purchasing a new database management system, managers should focus on the system's technological capabilities rather than its compatibility with current systems.

Accepted Answer

A) True 
 B)False

Question 19

Using Microsoft Access, you can delete a record from the "many" side of a one-to-many relationship, even if referential integrity is enforced.

Accepted Answer

A) True 
 B)False

Question 20

A database management system is:

Accepted Answer

A) A set of computer files 
B) A set of one or more computer programs 
C) A set of data to be processed by a computer 
D) A manual accounting information system 
A) A set of computer files 
B) A set of one or more computer programs 
C) A set of data to be processed by a computer 
D) A manual accounting information system

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

One purpose of a data manipulation language is to:

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

A delete query in Microsoft Access is an example of an action query that enables you to delete all those records in a table satisfying specific criteria.

Database management systems can be implemented on:

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

As a general rule, creating data warehouses is:

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.

All of the following are advantages of drop-down boxes in Access except:

Pivot tables are powerful statistical tools, but allow the user little flexibility in selecting what data can be analyzed.

Another word for "cleaning" the data in preparation for storing it in a data warehouse in order to ensure uniform accuracy is:

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.

If creating a data mart is not cost effective, management should consider creating a data warehouse, which typically uses less money and time to design.

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

A DBMS is an efficient database table in third normal form.

When purchasing a new database management system, managers should focus on the system's technological capabilities rather than its compatibility with current systems.

Using Microsoft Access, you can delete a record from the "many" side of a one-to-many relationship, even if referential integrity is enforced.

A database management system is:

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

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

One purpose of a data manipulation language is to:

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

A delete query in Microsoft Access is an example of an action query that enables you to delete all those records in a table satisfying specific criteria.

Database management systems can be implemented on:

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

As a general rule, creating data warehouses is:

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.

All of the following are advantages of drop-down boxes in Access except:

Pivot tables are powerful statistical tools, but allow the user little flexibility in selecting what data can be analyzed.

Another word for "cleaning" the data in preparation for storing it in a data warehouse in order to ensure uniform accuracy is:

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.

If creating a data mart is not cost effective, management should consider creating a data warehouse, which typically uses less money and time to design.

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

A DBMS is an efficient database table in third normal form.

When purchasing a new database management system, managers should focus on the system's technological capabilities rather than its compatibility with current systems.

Using Microsoft Access, you can delete a record from the "many" side of a one-to-many relationship, even if referential integrity is enforced.

A database management system is:

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