Question 1

A database management system is:
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

Accepted Answer

A database management system (DBMS) is a software system that enables users to define, create, maintain and control access to a database. It is a set of one or more computer programs designed specifically to manage databases.

Question 2

A dynaset is the total set of records in a database table.

Accepted Answer

A dynaset is a subset of records from a database table that meet a specific criteria, such as a query or filter. It is not the total set of records in the table.

Question 3

Using Access, which of the following is not a recognized data type?
A)Yes/No
B)Year
C)Currency
D)Date

Accepted Answer

Year is not a recognized data type in Access.

Question 4

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

The answer of Using Microsoft Access to create a select...

Question 5

Database management systems are important to accountants because:
A)They automate file storage tasks and enable accountants to generate worthwhile financial reports
B)They eliminate data redundancy
C)They are unique data structures which accountants have never used before
D)They are easy to develop and therefore save money
E)They are energy efficient

Accepted Answer

Database management systems automate file storage tasks and enable accountants to generate worthwhile financial reports, making them an important tool for accountants in managing and analyzing financial data. Option B is also partially correct as database management systems eliminate data redundancy, but it is not the main reason why they are important to accountants. Options C, D, and E are incorrect as they are not relevant reasons for why database management systems are important to accountants.

Question 6

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

When specifying multiple criteria that must all be satisfied at the same time, they should be listed on the same Criteria line separated by the word "AND".

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

The answer of An append query in Microsoft Access is...

Question 8

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

Accepted Answer

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

Question 9

A disadvantage of database management systems is that:
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)

Accepted Answer

DBMSs are often designed for specific hardware and may not be compatible with all types of computers.

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).
A)Referential integrity
B)Mnemonic naming
C)Integrative relationships
D)Data typing
E)none of these is correct

Accepted Answer

Referential integrity is a feature in Access that helps to maintain the consistency of data by ensuring that relationships between tables are valid and that the rules governing these relationships are not violated. It also prevents users from deleting parent records if there are related child records in other tables, thereby protecting the integrity of the data. Mnemonic naming, integrative relationships, and data typing are not related to this Access feature.

Question 11

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

Microsoft Access allows for multi-table queries using its built-in Query Design tool or by writing SQL queries that join multiple tables together based on common fields or relationships.

Question 12

All of the following are data types that you can assign to data fields when creating records in Microsoft Access except:
A)Text
B)Number
C)Memo
D)Percent
E)all of these are legitimate data types

Accepted Answer

All of the data types listed (Text, Number, Memo, Percent) can be assigned to data fields when creating records in Microsoft Access.

Question 13

If you wish to create a select query with alternate criteria using Microsoft Access e.g., you wish to see a list of all customers living in zip codes 12345 or 12366), you should specify them on separate Criteria lines of the query.

Accepted Answer

The correct answer is true because in Microsoft Access, you can specify multiple criteria on separate lines of the query's Criteria row to create a select query with alternate criteria.

Question 14

An OR operation query)in Microsoft Access requires you to use multiple Criteria lines to create the query.

Accepted Answer

To create an OR operation query in Microsoft Access, you need to use multiple criteria lines.

Question 15

An update query in Microsoft Access is an example of an action query that enables you to increase the prices by ten percent for all those products starting with product code "123."

Accepted Answer

An update query in Microsoft Access can be used to modify data in a table. In this case, it can be used to increase the prices by ten percent for products with a specific product code.

Question 16

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 delete query in Microsoft Access is indeed an action query that enables you to delete records in a table based on specific criteria.

Question 17

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

It is recommended to spell accurately and correctly when creating queries in Microsoft Access as the spell checker may not catch all errors, particularly if the word is spelled correctly but used in the wrong context.

Question 18

Database management systems can be implemented on:
A)Mainframe computers only
B)Mainframe and minicomputers only
C)Mainframes, minicomputers, and microcomputers
D)Microcomputers only

Accepted Answer

Database management systems can be implemented on mainframes, minicomputers, and microcomputers. With the advancement of technology, it is now possible to implement database management systems on various types of computers, and not just mainframe and minicomputers. Microcomputers can be used for smaller databases, while mainframes and minicomputers can be used for larger databases that require more processing power. Therefore, the best choice would be C, as it encompasses all available options.

Question 19

The proper prefix to use when naming a table in Microsoft Access is:
A)tab
B)table
C)tbl
D)tb
E)none of these

Accepted Answer

The standard convention in Microsoft Access is to use "tbl" as the prefix for table names. This helps to easily distinguish tables from other database objects and also ensures that the table name is not a reserved word.

Question 20

Which one of these is not a good guideline to follow when creating tables in a relational database?
A)Design first, create tables later
B)Name tables systematically, using conventional "tbl" prefixes
C)Use mnemonic names for data fields
D)Assign at least 50 characters to each text field
E)Use consistent data types for primary and foreign key fields

Accepted Answer

Assigning at least 50 characters to each text field may result in unnecessary storage usage and may also affect query performance. The appropriate length of a text field should be determined based on the expected maximum length of the data it will hold.

Quiz 4: Organizing and Manipulating the Data in Databases

A database management system is:

A dynaset is the total set of records in a database table.

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

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.

Database management systems are important to accountants because:

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.

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.

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

A disadvantage of database management systems is that:

_________ is an Access tool that prohibits users from deleting parent records with child records i.e., records related in 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.

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

If you wish to create a select query with alternate criteria using Microsoft Access e.g., you wish to see a list of all customers living in zip codes 12345 or 12366), you should specify them on separate Criteria lines of the query.

An OR operation query)in Microsoft Access requires you to use multiple Criteria lines to create the query.

An update query in Microsoft Access is an example of an action query that enables you to increase the prices by ten percent for all those products starting with product code "123."

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.

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.

Database management systems can be implemented on:

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

Which one of these is not a good guideline to follow when creating tables in a relational database?