Question 1

Match between columns
                        Premises: Double
Integer
Byte
Long Integer
Single

Accepted Answer

The Answer of For large numbers with up to seven is...

Question 2

The terms null and zero are synonymous.

Accepted Answer

A) True 
 B)False  False

Question 3

An appropriate example of the type of data that could be stored in a Short Text data type field is ________.

Accepted Answer

A)  name and addresses 
B)  customer ID 
C)  salary 
D)  quantity 
A)  name and addresses 
B)  customer ID 
C)  salary 
D)  quantity A

Question 4

The ________ property in the Design view of a table defines how Access should display the data.

Accepted Answer

A)  Default Value 
B)  Input Mask 
C)  Data Type 
D)  Format 
A)  Default Value 
B)  Input Mask 
C)  Data Type 
D)  Format

Question 5

A phone number is an example of a(n)________.

Accepted Answer

A)  attribute 
B)  entity 
C)  relationship 
D)  property 
A)  attribute 
B)  entity 
C)  relationship 
D)  property

Question 6

To help Access determine what can be entered and stored in a field,select an appropriate ________ in Design view.

Accepted Answer

The answer of To help Access determine what can be...

Question 7

Which of the following is NOT true about undoing in Access?

Accepted Answer

A)  If you have made changes to several fields in a single record, you can click Undo to undo each of them. 
B)  Just like in other Office applications, there is a great deal of undo/redo functionality in Access. 
C)  Pressing Esc gets you out of an error. 
D)  Until the design of an object is saved, you can click Undo to undo design changes. 
A)  If you have made changes to several fields in a single record, you can click Undo to undo each of them. 
B)  Just like in other Office applications, there is a great deal of undo/redo functionality in Access. 
C)  Pressing Esc gets you out of an error. 
D)  Until the design of an object is saved, you can click Undo to undo design changes.

Question 8

An entity stores data about people,places,or things.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A)  1:N 
B)  M:N 
C)  1:1 
D)  There would not be a relationship between the two tables. 
A)  1:N 
B)  M:N 
C)  1:1 
D)  There would not be a relationship between the two tables.

Question 10

In Excel,a group of cells that has been renamed is known as a named ________.

Accepted Answer

The answer of In Excel,a group of cells that has...

Question 11

The ________ Time Format field property formats the time as 22:10.

Accepted Answer

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

Question 12

Which of the following is NOT true regarding compound fields?

Accepted Answer

A)  Break product information into StyleNumber, Color, and Size fields. 
B)  Break addresses into fields such as StreetAddress, City, State, and ZipCode. 
C)  Break names into FirstName and LastName fields. 
D)  Break dates into Month, Day, and Year fields. 
A)  Break product information into StyleNumber, Color, and Size fields. 
B)  Break addresses into fields such as StreetAddress, City, State, and ZipCode. 
C)  Break names into FirstName and LastName fields. 
D)  Break dates into Month, Day, and Year fields.

Question 13

In the United States,the ________ data type displays the data with a dollar sign and two decimal places.

Accepted Answer

The answer of In the United States,the ________ data type...

Question 14

The ________ data type generates the value by automatically incrementing the value for each new record to produce unique keys.

Accepted Answer

A)  Short Text 
B)  Calculated 
C)  Number 
D)  AutoNumber 
A)  Short Text 
B)  Calculated 
C)  Number 
D)  AutoNumber

Question 15

The power of Access can be seen when relationships are created between tables.

Accepted Answer

A) True 
 B)False

Question 16

The upper part of a table's Design view has four columns.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is NOT true about referential integrity?

Accepted Answer

A)  The matching fields on both sides of the relationship have the same data types. 
B)  You cannot enter a value in the foreign key field on the many side table that is not a primary key on the one side table. 
C)  The primary key field values on the one side of the relationship must be unique. 
D)  All foreign key fields and primary key fields must have values entered and cannot remain null. 
A)  The matching fields on both sides of the relationship have the same data types. 
B)  You cannot enter a value in the foreign key field on the many side table that is not a primary key on the one side table. 
C)  The primary key field values on the one side of the relationship must be unique. 
D)  All foreign key fields and primary key fields must have values entered and cannot remain null.

Question 18

Participants' first and last names will be stored in the Putt for Paws tournament.This is an example of a(n)________.

Accepted Answer

The answer of Participants' first and last names will be...

Question 19

Relationships between tables must be based on common fields.

Accepted Answer

A) True 
 B)False

Question 20

A person's phone number would serve as a good primary key.

Accepted Answer

A) True 
 B)False

The terms null and zero are synonymous.

An appropriate example of the type of data that could be stored in a Short Text data type field is ________.

The ________ property in the Design view of a table defines how Access should display the data.

A phone number is an example of a(n)________.

To help Access determine what can be entered and stored in a field,select an appropriate ________ in Design view.

Which of the following is NOT true about undoing in Access?

An entity stores data about people,places,or things.

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

In Excel,a group of cells that has been renamed is known as a named ________.

The ________ Time Format field property formats the time as 22:10.

Which of the following is NOT true regarding compound fields?

In the United States,the ________ data type displays the data with a dollar sign and two decimal places.

The ________ data type generates the value by automatically incrementing the value for each new record to produce unique keys.

The power of Access can be seen when relationships are created between tables.

The upper part of a table's Design view has four columns.

Which of the following is NOT true about referential integrity?

Participants' first and last names will be stored in the Putt for Paws tournament.This is an example of a(n)________.

Relationships between tables must be based on common fields.

A person's phone number would serve as a good primary key.

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

The terms null and zero are synonymous.

An appropriate example of the type of data that could be stored in a Short Text data type field is ________.

The ________ property in the Design view of a table defines how Access should display the data.

A phone number is an example of a(n)________.

To help Access determine what can be entered and stored in a field,select an appropriate ________ in Design view.

Which of the following is NOT true about undoing in Access?

An entity stores data about people,places,or things.

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

In Excel,a group of cells that has been renamed is known as a named ________.

The ________ Time Format field property formats the time as 22:10.

Which of the following is NOT true regarding compound fields?

In the United States,the ________ data type displays the data with a dollar sign and two decimal places.

The ________ data type generates the value by automatically incrementing the value for each new record to produce unique keys.

The power of Access can be seen when relationships are created between tables.

The upper part of a table's Design view has four columns.

Which of the following is NOT true about referential integrity?

Participants' first and last names will be stored in the Putt for Paws tournament.This is an example of a(n)________.

Relationships between tables must be based on common fields.

A person's phone number would serve as a good primary key.

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