Question 1

Which of the following is NOT true regarding table formatting?
A)In a table design,you can define a Format field property that customizes how data is displayed and printed in tables,queries,reports,and forms.
B)The Format property tells Access how data is to be displayed.
C)You can define your own custom formats for Currency and Number fields.
D)Formatting does not affect the way the data is stored.

Accepted Answer

The answer of Which of the following is NOT true...

Question 2

Which of the following is NOT true regarding primary keys?
A)The primary key field is the field that identifies each record in a table.
B)When you define a primary key for a table,the field can be left blank until you have the opportunity to enter the data.
C)A common way of defining a primary key is to use a field specifically designed to identify the entity.
D)A numeric key is often assigned an AutoNumber data type that Access will fill as the data is entered.

Accepted Answer

When you define a primary key for a table, the field cannot be left blank until you have the opportunity to enter the data. The primary key field must have a unique value for each record and must be defined before data is entered into the table.

Question 3

A ________ relationship is a relationship between tables where a record in one table has only one matching record in the second table.
A)one-to-many
B)one-to-one
C)many-to-many
D)This doesn't apply to any relationship type.

Accepted Answer

A one-to-one relationship is a relationship between tables where a record in one table has only one matching record in the second table.

Question 4

Which of the following is NOT a step in creating a many-to-many relationship?
A)Create a junction table.
B)The junction table is on the many side of both relationships.
C)Populate the junction table after the relationships have been created.
D)Only add the keys to the junction table.

Accepted Answer

Adding only the keys to the junction table is not enough to create a many-to-many relationship. The junction table should also contain foreign keys that reference the primary keys of the related tables. Therefore, option D is not a step in creating a many-to-many relationship.

Question 5

Which of the following is NOT a step in creating a one-to-many relationship?
A)Make sure the two tables have a field in common.
B)Form the relationship in the Relationships window.
C)Populate the foreign key by adding data to the foreign key in the many side table.
D)Use the foreign key from the one side,and add it as a primary key in the many side table.

Accepted Answer

Using the foreign key from the one side and adding it as a primary key in the many side table is actually a step in creating a one-to-many relationship. Therefore, the correct answer is D.

Question 6

Which of the following is NOT true regarding redundancy?
A)Redundancy occurs when data is repeated several times in a database.
B)When you normalize a database,you eliminate redundancy.
C)Foreign keys are redundant,but no other data about the entity is repeated.
D)Normalization is the process of minimizing duplicate data.

Accepted Answer

The answer of Which of the following is NOT true...

Question 7

Which of the following is NOT true regarding normalization?
A)When you normalize a database,you will have larger tables,each representing a different thing.
B)If you know the primary key of an entity in a normalized database,each of the attributes will have just one value.
C)There will be no redundant data in the tables.
D)Normalization is the process of minimizing duplicate data.

Accepted Answer

Normalization involves breaking down a larger table into smaller tables with each representing a different theme or entity. Therefore, the statement "When you normalize a database, you will have larger tables, each representing a different thing" is not true.

Question 8

Which of the following is NOT true regarding keys?
A)Each table should have a primary key to uniquely identify each of the records in the table.
B)A foreign key is a value in a table that is the primary key of another table.
C)The primary and foreign keys form the common field between tables that allow you to form a relationship between the two tables.
D)To define a foreign key,select the foreign key field and then click the Key button on the Ribbon.

Accepted Answer

To define a foreign key, you do not click the Key button on the Ribbon. Instead, you define the foreign key using data validation or the Relationship tool.

Question 9

Two fields needed to uniquely identify a record are called a ________ key.
A)composite
B)natural primary
C)foreign
D)primary

Accepted Answer

Composite keys are made up of two or more fields which together uniquely identify a record. This is the best choice because it explicitly states that two fields are needed to uniquely identify a record. Natural primary keys may be unique but they are based on a single field, foreign keys are used to create relationships between tables, and primary keys may be made up of a single field which may not necessarily be unique.

Question 10

________ is an example of the General Date format.
A)11/9/2015 10:10:10 PM
B)Wednesday,November 9,2015
C)9-Nov-15 10:10:10 PM
D)Wednesday,November 9,2015 10:10 PM

Accepted Answer

The General Date format typically includes the date, time, and AM/PM indicator, separated by spaces. Option A includes all of these elements in the correct order. Option B is the Long Date format, option C is the Short Date format, and option D is a combination of the Long Date and Short Time formats.

Question 11

A ________ relationship is a relationship between tables in which one record in one table has many matching records in a second table,and one record in the related table has many matching records in the first table.
A)one-to-many
B)one-to-one
C)many-to-many
D)This doesn't apply to any relationship type.

Accepted Answer

A many-to-many relationship is where one record in a table can relate to many records in another table and vice versa.

Question 12

A university identifies a class by subject area and course number.The university has classes Math 101,Math 102,and MIS 101.It takes both subject and course number to identify a single course.The combination of the two fields is called a ________ key.
A)foreign
B)natural primary
C)composite
D)primary

Accepted Answer

A composite key is a combination of two or more columns in a table that can be used to uniquely identify each row in the table. In this case, the combination of subject area (Math or MIS) and course number (101 or 102) together uniquely identify each course, making them a composite key.

Question 13

The ________ format displays at least one digit after the decimal point.
A)Scientific
B)Fixed
C)Standard
D)Percent

Accepted Answer

The Fixed format allows for a specific number of digits after the decimal point, whereas the others may not.

Question 14

________ is the process of minimizing the duplication of information in a relational database through effective database design.
A)Formatting
B)Defining keys
C)Establishing relationships
D)Normalization

Accepted Answer

Normalization is the process of eliminating redundant data and minimizing data dependence. This is achieved by dividing large tables into smaller entities and defining relationships between them. By doing so, data is stored only once, which reduces storage space requirements and ensures that data is consistent and up-to-date. Defining keys and establishing relationships are important steps in achieving normalization, but they are not the same as normalization itself. Formatting, while important for data presentation, is not directly related to reducing information duplication in a relational database.

Question 15

A ________ relationship is a relationship between two tables where one record in the first table corresponds to many records in the second table.
A)one-to-many
B)one-to-one
C)many-to-many
D)This doesn't apply to any relationship type.

Accepted Answer

In a one-to-many relationship, one record in the first table can have multiple corresponding records in the second table, but each record in the second table can only correspond to one record in the first table. This is the most common type of relationship in relational databases.

Question 16

4.5E + 13 is an example of the ________ format.
A)Scientific
B)Fixed
C)Standard
D)Percent

Accepted Answer

This is because the format 4.5E + 13 is in scientific notation, which is commonly used to express very large or very small numbers. The "E" represents "times 10 to the power of" and the number after it indicates the exponent.

Question 17

Sometimes your data will have a unique identifier that is already a part of your data.When that is true,you can use the field as a ________ key.
A)foreign
B)natural primary
C)composite
D)primary

Accepted Answer

If the data already has a unique identifier that can be used as a primary key, it is known as a natural primary key. Using a natural primary key can simplify the database design process and can improve performance. Foreign keys are used to establish relationships between tables, composite keys involve using multiple fields as the primary key, and primary keys must be unique and cannot already be a part of the data.

Question 18

________ is an example of the Long Date format.
A)11/9/2015 10:10:10 PM
B)Wednesday,November 9,2015
C)9-Nov-15 10:10:10 PM
D)Wednesday,November 9,2015 10:10 PM

Accepted Answer

The Long Date format typically includes the full name of the weekday, the full name of the month, the day of the month, and the year. Option B is the only format that follows this convention.

Question 19

Which of the following is NOT true regarding a one-to-many relationship?
A)A one-to-many relationship is a relationship between two tables where one record in the first table corresponds to many records in the second table.
B)One-to-many is called the cardinality of the relationship.
C)Access uses the tilde and infinity symbols to indicate a one-to-many relationship.
D)Cardinality indicates the number of instances of one entity that relates to one instance of another entity.

Accepted Answer

Access uses the "1" and infinity symbols to indicate a one-to-many relationship, not the tilde.

Question 20

Which of the following is NOT true regarding foreign keys?
A)The AutoNumber data type is typically used for foreign key fields.
B)A foreign key is a field in a table that stores a value that is the primary key in another table.
C)It is called foreign because it identifies a record in another table.
D)Foreign keys do not need to be unique in the table.

Accepted Answer

The AutoNumber data type is typically used for primary keys, not foreign keys. Foreign keys are usually set to match the data type of the primary key they reference, which is often an integer or another compatible type.

Quiz 2: Workshop 2: Tables, Keys, and Relationships

Which of the following is NOT true regarding table formatting?

Which of the following is NOT true regarding primary keys?

A ________ relationship is a relationship between tables where a record in one table has only one matching record in the second table.

Which of the following is NOT a step in creating a many-to-many relationship?

Which of the following is NOT a step in creating a one-to-many relationship?

Which of the following is NOT true regarding redundancy?

Which of the following is NOT true regarding normalization?

Which of the following is NOT true regarding keys?

Two fields needed to uniquely identify a record are called a ________ key.

________ is an example of the General Date format.

A ________ relationship is a relationship between tables in which one record in one table has many matching records in a second table,and one record in the related table has many matching records in the first table.

A university identifies a class by subject area and course number.The university has classes Math 101,Math 102,and MIS 101.It takes both subject and course number to identify a single course.The combination of the two fields is called a ________ key.

The ________ format displays at least one digit after the decimal point.

________ is the process of minimizing the duplication of information in a relational database through effective database design.

A ________ relationship is a relationship between two tables where one record in the first table corresponds to many records in the second table.

4.5E + 13 is an example of the ________ format.

Sometimes your data will have a unique identifier that is already a part of your data.When that is true,you can use the field as a ________ key.

________ is an example of the Long Date format.

Which of the following is NOT true regarding a one-to-many relationship?

Which of the following is NOT true regarding foreign keys?