Question 1

All of the following are data types that you can assign to data fields when creating records in Microsoft Access except:

Accepted Answer

A) Short Text 
B) Number 
C) Long Text 
D) Percent 
E) all of these are legitimate data types 
A) Short Text 
B) Number 
C) Long Text 
D) Percent 
E) all of these are legitimate data types

Question 2

A dynaset is the set of records that results from a query.

Accepted Answer

A) True 
 B)False

Question 3

A DBMS is a type of software.

Accepted Answer

A) True 
 B)False

Question 4

If you want to 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 5

To create a query that calculates the total amount for a sale, you would likely need to include the following tables in your query:

Accepted Answer

A) Customers, Employees, and Cash Receipts 
B) Customers, Employees, and Sales 
C) Sales, Inventory, and Cash Receipts 
D) Sales, Inventory, and the relationship table Sales/Inventory 
A) Customers, Employees, and Cash Receipts 
B) Customers, Employees, and Sales 
C) Sales, Inventory, and Cash Receipts 
D) Sales, Inventory, and the relationship table Sales/Inventory

Question 6

Which of these is a desirable guideline to follow when creating queries with Microsoft Access?

Accepted Answer

A) Spell accurately 
B) Don't worry about capitalization 
C) Join each table at least twice to ensure their connectivity 
D) Name each query you create "Query" 
A) Spell accurately 
B) Don't worry about capitalization 
C) Join each table at least twice to ensure their connectivity 
D) Name each query you create "Query"

Question 7

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 8

Sorting records is 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

Question 9

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 10

A "default value" for an Access data field is:

Accepted Answer

A) The value of last resort 
B) A value that Access will assume if the user does not enter one 
C) A value that Access will take from the last record entered into the system 
D) none of these 
A) The value of last resort 
B) A value that Access will assume if the user does not enter one 
C) A value that Access will take from the last record entered into the system 
D) none of these

Question 11

The value that a database will use if the user does not provide an alternate value is called a(n):

Accepted Answer

A) Asset value 
B) Text value 
C) Control value 
D) Default value 
A) Asset value 
B) Text value 
C) Control value 
D) Default value

Question 12

DML stands for:

Accepted Answer

A) Distributed management logic 
B) Data management logic 
C) Data management language 
D) Data manipulation language 
A) Distributed management logic 
B) Data management logic 
C) Data management language 
D) Data manipulation language

Question 13

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 14

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 15

Foreign keys are necessary in a database because every record must have a foreign key.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Using Access, which of these terms is not associated with defining a data field within a record?

Accepted Answer

A) Field name 
B) Data type 
C) Currency value 
D) Description 
A) Field name 
B) Data type 
C) Currency value 
D) Description

Question 18

You could add 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 19

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 20

DDL is an acronym for "data definition language."

Accepted Answer

A) True 
 B)False

All of the following are data types that you can assign to data fields when creating records in Microsoft Access except:

A dynaset is the set of records that results from a query.

A DBMS is a type of software.

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

To create a query that calculates the total amount for a sale, you would likely need to include the following tables in your query:

Which of these is a desirable guideline to follow when creating queries with Microsoft Access?

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.

Sorting records is unlike indexing records in that:

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

A "default value" for an Access data field is:

The value that a database will use if the user does not provide an alternate value is called a(n):

DML stands for:

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

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

Foreign keys are necessary in a database because every record must have a foreign key.

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

Using Access, which of these terms is not associated with defining a data field within a record?

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

One purpose of a data manipulation language is to:

DDL is an acronym for "data definition language."

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

All of the following are data types that you can assign to data fields when creating records in Microsoft Access except:

A dynaset is the set of records that results from a query.

A DBMS is a type of software.

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

To create a query that calculates the total amount for a sale, you would likely need to include the following tables in your query:

Which of these is a desirable guideline to follow when creating queries with Microsoft Access?

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.

Sorting records is unlike indexing records in that:

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

A "default value" for an Access data field is:

The value that a database will use if the user does not provide an alternate value is called a(n):

DML stands for:

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

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

Foreign keys are necessary in a database because every record must have a foreign key.

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

Using Access, which of these terms is not associated with defining a data field within a record?

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

One purpose of a data manipulation language is to:

DDL is an acronym for "data definition language."

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