Question 1

Databases are the same thing as database management systems.

Accepted Answer

A) True 
 B)False  False

Question 2

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 C

Question 3

A DBMS is a type of hardware.

Accepted Answer

A) True 
 B)False  False

Question 4

A database subschema is a plot that can often be discovered with forensic accounting.

Accepted Answer

A) True 
 B)False

Question 5

In the Relationships window, Access uses this symbol to represent the "many" side of a "one-to-many" relationship:

Accepted Answer

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

Question 6

It is not possible to conduct multi-table queries using Microsoft Access because each table in the system is independent of the others.

Accepted Answer

A) True 
 B)False

Question 7

Microsoft Access can create a well-functioning database for you using Wizards, and there is no need to understand database design or normalization.

Accepted Answer

A) True 
 B)False

Question 8

The purpose of an input mask is to:

Accepted Answer

A) Disguise data when they are first input into a database 
B) Transform data from alphabetic to numeric formats 
C) Help users avoid data entry errors 
D) Hide sensitive data such as passwords onscreen 
A) Disguise data when they are first input into a database 
B) Transform data from alphabetic to numeric formats 
C) Help users avoid data entry errors 
D) Hide sensitive data such as passwords onscreen

Question 9

Which of these is an example of a data query language?

Accepted Answer

A) ABC 
B) SQL 
C) DDL 
D) JPG 
A) ABC 
B) SQL 
C) DDL 
D) JPG

Question 10

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 11

It is not necessary to spell accurately or correctly when creating queries in Microsoft Access because such matters as case or spelling are corrected automatically by the system's spell checker.

Accepted Answer

A) True 
 B)False

Question 12

If there are multiple search criteria on the criteria row of a query, this is the equivalent of an AND requirement.

Accepted Answer

A) True 
 B)False

Question 13

An example of an input mask for an Access data field is 999\-00\-0000;;??_.

Accepted Answer

A) True 
 B)False

Question 14

When creating queries in Access:

Accepted Answer

A) It is necessary to include all data fields from an underlying record. 
B) It is not necessary to include all data fields from an underlying record. 
C) Data fields must be listed in alphabetical order. 
D) Numeric fields must precede short text fields. 
A) It is necessary to include all data fields from an underlying record. 
B) It is not necessary to include all data fields from an underlying record. 
C) Data fields must be listed in alphabetical order. 
D) Numeric fields must precede short text fields.

Question 15

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 16

A database schema is a plan of the entire database.

Accepted Answer

A) True 
 B)False

Question 17

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 separate Criteria lines of the query.

Accepted Answer

A) True 
 B)False

Question 18

In Access, a validation rule triggers at the time that:

Accepted Answer

A) The user first enters data into the database 
B) The DBMS first uses the data in a report 
C) The user first requests the database to test data with a menu command 
D) The user powers up Access and loads that particular database 
A) The user first enters data into the database 
B) The DBMS first uses the data in a report 
C) The user first requests the database to test data with a menu command 
D) The user powers up Access and loads that particular database

Question 19

SQL is an example of a database query language.

Accepted Answer

A) True 
 B)False

Question 20

To perform a range test on the hours worked data field in an Access database that requires the entry to be at least 0 and no more than 40, you should express this requirement as:

Accepted Answer

A) At least 0; Not more than 40 
B) 0<= X <= 40 
C) Between 0 And 40 
D) none of these 
A) At least 0; Not more than 40 
B) 0<= X <= 40 
C) Between 0 And 40 
D) none of these

Databases are the same thing as database management systems.

Sorting and Indexing database records are similar in that:

A DBMS is a type of hardware.

A database subschema is a plot that can often be discovered with forensic accounting.

In the Relationships window, Access uses this symbol to represent the "many" side of a "one-to-many" relationship:

It is not possible to conduct multi-table queries using Microsoft Access because each table in the system is independent of the others.

Microsoft Access can create a well-functioning database for you using Wizards, and there is no need to understand database design or normalization.

The purpose of an input mask is to:

Which of these is an example of a data query language?

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

It is not necessary to spell accurately or correctly when creating queries in Microsoft Access because such matters as case or spelling are corrected automatically by the system's spell checker.

If there are multiple search criteria on the criteria row of a query, this is the equivalent of an AND requirement.

An example of an input mask for an Access data field is 999\-00\-0000;;??_.

When creating queries in Access:

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.

A database schema is a plan of the entire database.

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 separate Criteria lines of the query.

In Access, a validation rule triggers at the time that:

SQL is an example of a database query language.

To perform a range test on the hours worked data field in an Access database that requires the entry to be at least 0 and no more than 40, you should express this requirement as:

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

Databases are the same thing as database management systems.

Sorting and Indexing database records are similar in that:

A DBMS is a type of hardware.

A database subschema is a plot that can often be discovered with forensic accounting.

In the Relationships window, Access uses this symbol to represent the "many" side of a "one-to-many" relationship:

It is not possible to conduct multi-table queries using Microsoft Access because each table in the system is independent of the others.

Microsoft Access can create a well-functioning database for you using Wizards, and there is no need to understand database design or normalization.

The purpose of an input mask is to:

Which of these is an example of a data query language?

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

It is not necessary to spell accurately or correctly when creating queries in Microsoft Access because such matters as case or spelling are corrected automatically by the system's spell checker.

If there are multiple search criteria on the criteria row of a query, this is the equivalent of an AND requirement.

An example of an input mask for an Access data field is 999\-00\-0000;;??_.

When creating queries in Access:

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.

A database schema is a plan of the entire database.

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 separate Criteria lines of the query.

In Access, a validation rule triggers at the time that:

SQL is an example of a database query language.

To perform a range test on the hours worked data field in an Access database that requires the entry to be at least 0 and no more than 40, you should express this requirement as:

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