Question 1

A field used to connect one table logically with another table is called a ____ field.

Accepted Answer

A)   common
B)   primary
C)   composite
D)   dataE) A) and C)
F) B) and C)

Question 2

Performing a(n) ____________________ is the process of relating tables in a database based on a common field.

Accepted Answer

The answer of Performing a(n) ____________________ is the process of...

Question 3

All fields in a database should be contained in one table.

Accepted Answer

A) True 
 B)False  False

Question 4

A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a ____ relationship.

Accepted Answer

A)   One-to-One
B)   One-to-Many
C)   One-to-Most
D)   Many-to-OneE) All of the above
F) B) and D)

Question 5

Which of the following is the most logical data type to use if a field will contain long comments or explanations?

Accepted Answer

A)   Hyperlink
B)   Short Text
C)   Memo
D)   Long TextE) B) and C)
F) A) and D)

Question 6

____ is the default name for a new table in an Access database.

Accepted Answer

A)   My table
B)   Table1
C)   ADB Table
D)   TableAE) B) and D)
F) A) and B)

Question 7

One rule of ____________________ is that Access prevents the primary key from being changed in the primary table of a relationship if a matching record exists in a related table.

Accepted Answer

referentia...

Question 8

Field name display in database objects such as datasheets, forms, and reports is determined by the ____________________ property.

Accepted Answer

The answer of Field name display in database objects such...

Question 9

The data type that allows both sequential and random numbering is the ____ data type.

Accepted Answer

A)   Number
B)   Currency
C)   AutoNumber
D)   Long DateE) All of the above
F) None of the above

Question 10

Match between columns
                        Premises: The Access option that permits a change in the value of the primary key in a table and changes the appropriate foreign key values in the related table.
A primary key that consists of two or more fields in a table.
A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.
A record in a table that is related to a primary table but has no matching record established with the primary table.
The term used when the same data is stored in more than one place which can cause inconsistencies in the database.
The Access option that deletes a record in the primary table and also deletes all records in related tables that have matching foreign key values.
The Access database view that allows users to define or modify a table structure or field properties in a table.
An Access feature available from the FIELDS tab that allows the user to add a group of related fields to a table at the same time.
A group of fields added all at once using the Data Type gallery.
The process that occurs when the field Description (Optional) property is changed in Design View and the Property Update Options tool is used to update the entire database everywhere the field is used, including forms and reports.

Accepted Answer

The Answer of Quick Start selection and Data Type gallery is...

Question 11

Which symbols would be used to create a custom date format that would display July 4, 2016 as 7/04/16?

Accepted Answer

A)   mm/dd/yyyy
B)   m/ddd/yy
C)   mmm/d/yyyy
D)   m/dd/yyE) A) and D)
F) A) and C)

Question 12

Access does not require a table to have a(n) primary key .

Accepted Answer

A) True 
 B)False

Question 13

The ____________________ data type is not subject to round-off error when calculated, unlike the Number data type with decimal values.

Accepted Answer

The answer of The ____________________ data type is not subject...

Question 14

The way field values are stored, displayed, and processed in an Access database is determined by the ____________________.

Accepted Answer

The answer of The way field values are stored, displayed,...

Question 15

Which data type allows the designer to define the Field Size property?

Accepted Answer

A)   Long Text
B)   Hyperlink
C)   Memo
D)   AutoNumberE) A) and B)
F) B) and C)

Question 16

Access does not allow data to be imported from sources other than another Access database.

Accepted Answer

A) True 
 B)False  False

Question 17

A field in an Access database table that has no value is determined by Access to have a ____ value.

Accepted Answer

A)   custom
B)   zero
C)   null
D)   numberE) A) and B)
F) A) and C)

Question 18

In the Database Design grid , press the Enter key to move from one property to the next property.

Accepted Answer

A) True 
 B)False

Question 19

The Currency data type is accurate up to 4 digits on the right side of the decimal point.

Accepted Answer

A) True 
 B)False  True

Question 20

The ____ property specifies the number of decimal places displayed to the right of the decimal point.

Accepted Answer

A)   Decimal Places
B)   Input Mask
C)   Default Value
D)   FormatE) C) and D)
F) A) and C)

Exam 2: Access Module : Building a Database and Defining Table Relationships

A field used to connect one table logically with another table is called a ____ field.

Correct Answer
verified

Performing a(n) ____________________ is the process of relating tables in a database based on a common field.

Correct Answer
verified

All fields in a database should be contained in one table.

Correct Answer
verified
False

A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a ____ relationship.

Correct Answer
verified

Which of the following is the most logical data type to use if a field will contain long comments or explanations?

Correct Answer
verified

____ is the default name for a new table in an Access database.

Correct Answer
verified

One rule of ____________________ is that Access prevents the primary key from being changed in the primary table of a relationship if a matching record exists in a related table.

Correct Answer
verified
referentia...
View Answer

Field name display in database objects such as datasheets, forms, and reports is determined by the ____________________ property.

Correct Answer
verified

The data type that allows both sequential and random numbering is the ____ data type.

Correct Answer
verified

Identify the letter of the choice that best matches the phrase or definition.

Which symbols would be used to create a custom date format that would display July 4, 2016 as 7/04/16?

Correct Answer
verified

Access does not require a table to have a(n) primary key .

Correct Answer
verified

The ____________________ data type is not subject to round-off error when calculated, unlike the Number data type with decimal values.

Correct Answer
verified

The way field values are stored, displayed, and processed in an Access database is determined by the ____________________.

Correct Answer
verified

Which data type allows the designer to define the Field Size property?

Correct Answer
verified

Access does not allow data to be imported from sources other than another Access database.

Correct Answer
verified
False

A field in an Access database table that has no value is determined by Access to have a ____ value.

Correct Answer
verified

In the Database Design grid , press the Enter key to move from one property to the next property.

Correct Answer
verified

The Currency data type is accurate up to 4 digits on the right side of the decimal point.

Correct Answer
verified
True

The ____ property specifies the number of decimal places displayed to the right of the decimal point.

Correct Answer
verified

Exam 2: Access Module : Building a Database and Defining Table Relationships

A field used to connect one table logically with another table is called a ____ field.

Correct AnswerverifiedShow Answer

Performing a(n) ____________________ is the process of relating tables in a database based on a common field.

Correct AnswerverifiedShow Answer

All fields in a database should be contained in one table.

Correct AnswerverifiedFalse

A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a ____ relationship.

Correct AnswerverifiedShow Answer

Which of the following is the most logical data type to use if a field will contain long comments or explanations?

Correct AnswerverifiedShow Answer

____ is the default name for a new table in an Access database.

Correct AnswerverifiedShow Answer

One rule of ____________________ is that Access prevents the primary key from being changed in the primary table of a relationship if a matching record exists in a related table.

Correct Answerverifiedreferentia...View AnswerShow Answer

Field name display in database objects such as datasheets, forms, and reports is determined by the ____________________ property.

Correct AnswerverifiedShow Answer

The data type that allows both sequential and random numbering is the ____ data type.

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition.

Which symbols would be used to create a custom date format that would display July 4, 2016 as 7/04/16?

Correct AnswerverifiedShow Answer

Access does not require a table to have a(n) primary key .

Correct AnswerverifiedShow Answer

The ____________________ data type is not subject to round-off error when calculated, unlike the Number data type with decimal values.

Correct AnswerverifiedShow Answer

The way field values are stored, displayed, and processed in an Access database is determined by the ____________________.

Correct AnswerverifiedShow Answer

Which data type allows the designer to define the Field Size property?

Correct AnswerverifiedShow Answer

Access does not allow data to be imported from sources other than another Access database.

Correct AnswerverifiedFalse

A field in an Access database table that has no value is determined by Access to have a ____ value.

Correct AnswerverifiedShow Answer

In the Database Design grid , press the Enter key to move from one property to the next property.

Correct AnswerverifiedShow Answer

The Currency data type is accurate up to 4 digits on the right side of the decimal point.

Correct AnswerverifiedTrue

The ____ property specifies the number of decimal places displayed to the right of the decimal point.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
referentia...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified