Question 1

SQL is an example of a database query language.

Accepted Answer

A) True 
 B)False

Question 2

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 3

A disadvantage of database management systems is that:

Accepted Answer

A) They are not flexible 
B) They cannot be implemented on microcomputers 
C) They rarely support file inquiries 
D) They are often machine dependent (e.g.,not all DBMSs can run on all types of computers) 
A) They are not flexible 
B) They cannot be implemented on microcomputers 
C) They rarely support file inquiries 
D) They are often machine dependent (e.g.,not all DBMSs can run on all types of computers)

Question 4

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 5

A school administrator wishes to select the names of all students who live in a certain city.That city has exactly two zip codes in it.Which of these would be the best approach to use for this task?

Accepted Answer

A) Perform two separate select queries,using only one zip code for each task 
B) Perform a single select query,placing the zip codes on the same Criteria line of the query 
C) Perform a single select query,placing the zip codes on separate Criteria lines of the query 
D) Perform a single,update query 
E) none of these (this is not possible using Microsoft Access) 
A) Perform two separate select queries,using only one zip code for each task 
B) Perform a single select query,placing the zip codes on the same Criteria line of the query 
C) Perform a single select query,placing the zip codes on separate Criteria lines of the query 
D) Perform a single,update query 
E) none of these (this is not possible using Microsoft Access)

Question 6

Which tool enables a DBMS to extract only a subset of records from a database?

Accepted Answer

A) Table 
B) Query 
C) Validation test 
D) none of these 
A) Table 
B) Query 
C) Validation test 
D) none of these

Question 7

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 8

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 9

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 10

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

When Access links records to one another in different tables,the foreign key in one record refers to the _______ in another record.

Accepted Answer

A) Primary key 
B) Secondary key 
C) Foreign key 
D) Linkage key 
A) Primary key 
B) Secondary key 
C) Foreign key 
D) Linkage key

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

Databases are the same thing as database management systems.

Accepted Answer

A) True 
 B)False

Question 18

The proper prefix to use when naming a table in Microsoft Access is:

Accepted Answer

A) tab 
B) table 
C) tbl 
D) tb 
E) none of these 
A) tab 
B) table 
C) tbl 
D) tb 
E) none of these

Question 19

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

Question 20

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

SQL is an example of a database query language.

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

A disadvantage of database management systems is that:

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

A school administrator wishes to select the names of all students who live in a certain city.That city has exactly two zip codes in it.Which of these would be the best approach to use for this task?

Which tool enables a DBMS to extract only a subset of records from a database?

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

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

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

Database management systems can be implemented on:

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

When Access links records to one another in different tables,the foreign key in one record refers to the _______ in another record.

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

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

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

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

Databases are the same thing as database management systems.

The proper prefix to use when naming a table in Microsoft Access is:

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:

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

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

SQL is an example of a database query language.

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

A disadvantage of database management systems is that:

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

A school administrator wishes to select the names of all students who live in a certain city.That city has exactly two zip codes in it.Which of these would be the best approach to use for this task?

Which tool enables a DBMS to extract only a subset of records from a database?

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

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

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

Database management systems can be implemented on:

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

When Access links records to one another in different tables,the foreign key in one record refers to the _______ in another record.

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

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

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

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

Databases are the same thing as database management systems.

The proper prefix to use when naming a table in Microsoft Access is:

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:

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

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