Question 1

A useful guideline to follow when creating data fields containing text is to assign at least 50 characters to it.

Accepted Answer

False

Question 2

It is not possible to save a table in Microsoft Access unless you also identify a primary record key.

Accepted Answer

In Microsoft Access, you can save a table without defining a primary key, although it is recommended to have one for data integrity and efficient data management.

Question 3

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

Accepted Answer

Microsoft Access is a database management system (DBMS) that allows users to create and manage databases. It provides tools for creating tables, queries, forms, and reports. While it is also an example of a database, it is specifically designed to be a DBMS.

Question 4

The conventional prefix for the name of a table is "tbl."

Accepted Answer

Yes, the conventional prefix for the name of a table is "tbl." This convention helps to distinguish tables from other database objects, such as views or stored procedures.

Question 5

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

Accepted Answer

Microsoft Access is a software application that provides a user interface to a database management system, but it is not a database itself. It is used to create and manage databases, tables, queries, forms, reports, and macros.

Question 6

To create a relationship between two tables in Microsoft Access,you should use the Relationships window.

Accepted Answer

The Relationships window in Microsoft Access allows you to create, modify, and delete relationships between tables.

Question 7

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

Accepted Answer

Referential Integrity is a feature in relational databases that ensures that relationships between tables remain consistent. One aspect of referential integrity is preventing the deletion of a parent record if it has child records. In Microsoft Access, this is enforced by setting up a relationship between the tables and enabling "Cascade Delete Related Records" or "Restrict Delete Enforced".

Question 8

A good primary record key to use for a table of employee records that you might create in Access is the employee's last name.

Accepted Answer

While last name could be a candidate key, it is not always unique and there is always the possibility of two employees having the same last name. It is better to use a unique identifier such as an employee ID or social security number as the primary key for employee records.

Question 9

A template that you can create in Microsoft Access and that prompts users for expected values is called a "mask."

Accepted Answer

A mask is a template that can be created in Microsoft Access to prompt users for expected values. The mask can be designed to enforce specific formats, such as phone numbers or dates, and ensures that users enter data consistently.

Question 10

Microsoft Access uses a key symbol to identify the primary record key in a database table.

Accepted Answer

This statement is true. Microsoft Access does use a key symbol to identify the primary record key in a database table. The primary key is used to uniquely identify each record in the table, and it is usually displayed in a key symbol in the table design view.

Question 11

DDL is an acronym for "data definition language."

Accepted Answer

DDL is indeed an acronym for "data definition language." It is a category of SQL commands that are used to create, alter, and drop database objects such as tables, indexes, and views.

Question 12

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

In Microsoft Access, the inability to delete a parent record if it has child records is enforced by referential integrity, not "Parental Hierarchy."

Question 13

Databases are the same thing as database management systems.

Accepted Answer

Databases are collections of data that can be managed by database management systems (DBMS) which are software systems specifically designed for organizing and managing data. While databases are the collection of data, DBMS is the software program that is designed to create, maintain, and manage a database.

Question 14

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

Accepted Answer

"Number" is a valid data type in Access used to store numerical data such as integers, decimals, and currency values.

Question 15

The guideline recommending that you create "mnemonic names for data fields" means that you should name data fields that rhyme with their data types.

Accepted Answer

This guideline means that you should create names for data fields that are easy to remember and relate to the type of data they store, not necessarily that they should rhyme with their data types. For example, a data field that stores a customer's name could be named "customerName" instead of "stringName."

Question 16

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

Accepted Answer

Text is a valid data type for a data field in an Access table. Other examples include Number, Date/Time, and Yes/No.

Question 17

A DBMS is a type of hardware.

Accepted Answer

A DBMS (Database Management System) is not hardware, but rather software that is used to manage, organize, and access data stored in a database. It is typically installed on hardware such as a server or a computer.

Question 18

To create a relationship between two tables in Microsoft Access,you should use the Queries window.

Accepted Answer

To create a relationship between two tables in Microsoft Access, you should use the Relationships window. The Queries window is used to create and run queries to extract information from tables.

Question 19

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

Accepted Answer

It is recommended to limit data fields containing text to reasonable lengths as it can help prevent errors, improve performance, and make the data easier to read and analyze. Keeping the length of the text fields in check can also ensure that the database doesn't become too bloated with unnecessary data.

Question 20

A DBMS is a type of software.

Accepted Answer

A DBMS (Database Management System) is a type of software that is used to manage databases. It is designed to allow users to create, edit, update, and manage data in a database. Examples of DBMS software include Oracle, MySQL, and Microsoft SQL Server.

Quiz 4: Organizing and Manipulating the Data in Databases