Question 1

Match between columns
                        Premises: Long Text
Calculated
OLE Object
Lookup Wizard
AutoNumber

Accepted Answer

The Answer of Used for keys and Allows for cross-application is...

Question 2

Which of the following is NOT a design objective when creating tables?

Accepted Answer

A)  Minimize the file size 
B)  Ensure that there is a way to import data 
C)  Minimize any errors 
D)  Encourage data consistency 
A)  Minimize the file size 
B)  Ensure that there is a way to import data 
C)  Minimize any errors 
D)  Encourage data consistency

Question 3

A(n)________ helps to enter data in a consistent manner.

Accepted Answer

The answer of A(n)________ helps to enter data in a...

Question 4

If you accidentally delete the wrong record,you can click Undo to restore it.

Accepted Answer

A) True 
 B)False

Question 5

Participants in the Putt for Paws tournament will be stored in the database.This is an example of a(n)________.

Accepted Answer

The answer of Participants in the Putt for Paws tournament...

Question 6

In a customer table,a(n)________ field would serve as a good primary key.

Accepted Answer

A)  phone number 
B)  customer ID 
C)  address 
D)  date of birth 
A)  phone number 
B)  customer ID 
C)  address 
D)  date of birth

Question 7

When a database is ________,redundancy is minimized.

Accepted Answer

A)  shared 
B)  normalized 
C)  joined 
D)  delimited 
A)  shared 
B)  normalized 
C)  joined 
D)  delimited

Question 8

Match between columns
                        Premises: Foreign key
Natural primary key
Null
Numeric key
Composite key

Accepted Answer

The Answer of Empty and When more than one field is...

Question 9

In a database,a table or entity represents ________.

Accepted Answer

A)  adverbs 
B)  adjectives 
C)  verbs 
D)  nouns 
A)  adverbs 
B)  adjectives 
C)  verbs 
D)  nouns

Question 10

All of the following fields would have a Short Text data type EXCEPT:

Accepted Answer

A)  email address. 
B)  zip code. 
C)  phone number. 
D)  student ID number. 
A)  email address. 
B)  zip code. 
C)  phone number. 
D)  student ID number.

Question 11

The ________ data type lists either values retrieved from a table or query or a set of values that you entered when the field was created.

Accepted Answer

The answer of The ________ data type lists either values...

Question 12

The field ________ defines the maximum length of data within a field.

Accepted Answer

A)  row height 
B)  size 
C)  piece 
D)  section 
A)  row height 
B)  size 
C)  piece 
D)  section

Question 13

In Datasheet view,the ________ icon that appears in the record selector indicates that the record is being modified.

Accepted Answer

A)  arrow 
B)  pointer 
C)  eraser 
D)  pencil 
A)  arrow 
B)  pointer 
C)  eraser 
D)  pencil

Question 14

The process of normalization causes multiple smaller tables to be created.

Accepted Answer

A) True 
 B)False

Question 15

In order to minimize duplicate information in a database,you would go through the process of ________.

Accepted Answer

The answer of In order to minimize duplicate information in...

Question 16

The OLE Object data type allows for cross-application editing.

Accepted Answer

A) True 
 B)False

Question 17

Data can be entered into a database using one of two methods: entering the data directly into the table or entering it in ________.

Accepted Answer

A)  a query 
B)  a report 
C)  a form 
D)  the relationship window 
A)  a query 
B)  a report 
C)  a form 
D)  the relationship window

Question 18

The ________ Date Format field property formats the date as 9-Nov-15.

Accepted Answer

A)  Short 
B)  General 
C)  Medium 
D)  Long 
A)  Short 
B)  General 
C)  Medium 
D)  Long

Question 19

The ________ data type displays checked box.

Accepted Answer

The answer of The ________ data type displays checked box....

Question 20

A(n)________ is created when a relationship between two tables based on a common field is established.

Accepted Answer

The answer of A(n)________ is created when a relationship between...

Which of the following is NOT a design objective when creating tables?

A(n)________ helps to enter data in a consistent manner.

If you accidentally delete the wrong record,you can click Undo to restore it.

Participants in the Putt for Paws tournament will be stored in the database.This is an example of a(n)________.

In a customer table,a(n)________ field would serve as a good primary key.

When a database is ________,redundancy is minimized.

In a database,a table or entity represents ________.

All of the following fields would have a Short Text data type EXCEPT:

The ________ data type lists either values retrieved from a table or query or a set of values that you entered when the field was created.

The field ________ defines the maximum length of data within a field.

In Datasheet view,the ________ icon that appears in the record selector indicates that the record is being modified.

The process of normalization causes multiple smaller tables to be created.

In order to minimize duplicate information in a database,you would go through the process of ________.

The OLE Object data type allows for cross-application editing.

Data can be entered into a database using one of two methods: entering the data directly into the table or entering it in ________.

The ________ Date Format field property formats the date as 9-Nov-15.

The ________ data type displays checked box.

A(n)________ is created when a relationship between two tables based on a common field is established.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Cell References, Named Ranges, and Functions

Effective Charts

The Four Main Database Objects

Queries and Data Access

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters

Exam 12: Tables,Keys,and Relationships

Which of the following is NOT a design objective when creating tables?

A(n)________ helps to enter data in a consistent manner.

If you accidentally delete the wrong record,you can click Undo to restore it.

Participants in the Putt for Paws tournament will be stored in the database.This is an example of a(n)________.

In a customer table,a(n)________ field would serve as a good primary key.

When a database is ________,redundancy is minimized.

In a database,a table or entity represents ________.

All of the following fields would have a Short Text data type EXCEPT:

The ________ data type lists either values retrieved from a table or query or a set of values that you entered when the field was created.

The field ________ defines the maximum length of data within a field.

In Datasheet view,the ________ icon that appears in the record selector indicates that the record is being modified.

The process of normalization causes multiple smaller tables to be created.

In order to minimize duplicate information in a database,you would go through the process of ________.

The OLE Object data type allows for cross-application editing.

Data can be entered into a database using one of two methods: entering the data directly into the table or entering it in ________.

The ________ Date Format field property formats the date as 9-Nov-15.

The ________ data type displays checked box.

A(n)________ is created when a relationship between two tables based on a common field is established.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Cell References, Named Ranges, and Functions

Effective Charts

The Four Main Database Objects

Queries and Data Access

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters