Exam 2: Building a Database and Defining Table Relationships

Identify the letter of the choice that best matches the phrase or definition. -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.

Free

(Multiple Choice)

4.8/5

(37)

Question 1

Correct Answer:

Verified

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

Free

(True/False)

4.8/5

(23)

Question 2

Correct Answer:

Verified

False

Which data type would be the best logical data type for a field named PaidDate?

Free

(Multiple Choice)

4.8/5

(35)

Question 3

Correct Answer:

Verified

A database management system is a useful tool only if it meets which of the following criteria?

(Multiple Choice)

4.8/5

(32)

Question 4

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

(Short Answer)

4.9/5

(32)

Question 5

By choosing the Definition Only option in the Import Objects dialog box,the of a table is imported,but not the .

(Multiple Choice)

4.9/5

(23)

Question 6

List six guidelines for designing databases.

(Essay)

4.9/5

(39)

Question 7

Identify the letter of the choice that best matches the phrase or definition. -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.

(Multiple Choice)

4.8/5

(27)

Question 8

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

(True/False)

4.8/5

(32)

Question 9

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

(Multiple Choice)

4.9/5

(39)

Question 10

Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail?

(Multiple Choice)

4.8/5

(39)

Question 11

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

(Short Answer)

4.8/5

(33)

Question 12

The common field between two tables in the Relationship window is indicated by a(n)____.

(Multiple Choice)

4.7/5

(36)

Question 13

Identify the letter of the choice that best matches the phrase or definition. -The Access database view that allows users to define or modify a table structure or field properties in a table.

(Multiple Choice)

4.9/5

(36)

Question 14

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

(True/False)

4.8/5

(33)

Question 15

Field value maximum storage size is defined by the Field Size property for the data types including Short Text,Number,and ____________________ only.

(Short Answer)

4.9/5

(41)

Question 16

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.

(Multiple Choice)

4.9/5

(39)

Question 17

When text is used as the Default Value for a field property,it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message._________________________

(True/False)

4.8/5

(41)

Question 18

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.

(Short Answer)

4.8/5

(40)

Question 19

Discuss at least three advantages of including a primary key in a table.

(Essay)

4.8/5

(40)

Question 20

Showing 1 - 20 of 75

Identify the letter of the choice that best matches the phrase or definition. -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.

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

Which data type would be the best logical data type for a field named PaidDate?

A database management system is a useful tool only if it meets which of the following criteria?

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

By choosing the Definition Only option in the Import Objects dialog box,the of a table is imported,but not the .

List six guidelines for designing databases.

Identify the letter of the choice that best matches the phrase or definition. -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.

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

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail?

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

The common field between two tables in the Relationship window is indicated by a(n)____.

Identify the letter of the choice that best matches the phrase or definition. -The Access database view that allows users to define or modify a table structure or field properties in a table.

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

Field value maximum storage size is defined by the Field Size property for the data types including Short Text,Number,and ____________________ only.

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.

When text is used as the Default Value for a field property,it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message._________________________

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.

Discuss at least three advantages of including a primary key in a table.

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 2: Building a Database and Defining Table Relationships

Identify the letter of the choice that best matches the phrase or definition. -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.

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

Which data type would be the best logical data type for a field named PaidDate?

A database management system is a useful tool only if it meets which of the following criteria?

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

By choosing the Definition Only option in the Import Objects dialog box,the ____ of a table is imported,but not the ____.

List six guidelines for designing databases.

Identify the letter of the choice that best matches the phrase or definition. -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.

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

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail?

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

The common field between two tables in the Relationship window is indicated by a(n)____.

Identify the letter of the choice that best matches the phrase or definition. -The Access database view that allows users to define or modify a table structure or field properties in a table.

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

Field value maximum storage size is defined by the Field Size property for the data types including Short Text,Number,and ____________________ only.

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.

When text is used as the Default Value for a field property,it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message._________________________

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.

Discuss at least three advantages of including a primary key in a table.

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

By choosing the Definition Only option in the Import Objects dialog box,the of a table is imported,but not the .