Question 1

The F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane. _________________________

Accepted Answer

A) True 
 B)False  True

Question 2

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

Accepted Answer

A)   common
B)   primary 
C)   composite
D)   data A

Question 3

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut._________________________

Accepted Answer

A) True 
 B)False  True

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

A database system determines how to store,display,and process field values based on which of the following?

Accepted Answer

A)   field names
B)   field properties 
C)   field captions
D)   field size

Question 6

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/yy

Question 7

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

Accepted Answer

The answer of  Field value maximum storage size is defined...

Question 8

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

Accepted Answer

A)  Cascade Update Related Fields Option
B)  Cascade Delete Related Records Option
C)  Composite key
D)  data redundancy
E)  Data Type galleryF) DesignG) orphaned recordH) propagateI) Quick Start selectionJ) referential integrity

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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.

Accepted Answer

A)  Cascade Update Related Fields Option
B)  Cascade Delete Related Records Option
C)  Composite key
D)  data redundancy
E)  Data Type galleryF) DesignG) orphaned recordH) propagateI) Quick Start selectionJ) referential integrity

Question 11

A primary key field from one table that is also a field in another table and is used to create a relationship between the two tables is a(n) ____________________ in the second table.

Accepted Answer

The answer of  A primary key field from one table...

Question 12

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

The answer of  One rule of ____________________ is that Access...

Question 13

Access automatically assigns the Number data type to all new fields. _________________________

Accepted Answer

A) True 
 B)False

Question 14

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 15

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 16

Identify the letter of the choice that best matches the phrase or definition.
- A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.
A)Cascade Update Related Fields Option
B)Cascade Delete Related Records Option
C)Composite key
D)data redundancy
E)Data Type gallery
F)Design
G)orphaned record
H)propagate
I)Quick Start selection
J)referential integrity

Accepted Answer

The answer of Identify the letter of the choice that...

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. _________________________

Accepted Answer

A) True 
 B)False

Question 18

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-One

Question 19

In a single table,all ____________________ must be unique within that table.

Accepted Answer

The answer of  In a single table,all ____________________ must be...

Question 20

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

Accepted Answer

A)   Currency
B)   Number 
C)   Memo
D)   Date/Time

Exam 2: Building a Database and Defining Table Relationships

The F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane. _________________________

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

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut._________________________

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

A database system determines how to store,display,and process field values based on which of the following?

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

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

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

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

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.

A primary key field from one table that is also a field in another table and is used to create a relationship between the two tables is a(n) ____________________ in the second table.

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.

Access automatically assigns the Number data type to all new fields. _________________________

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

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

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. _________________________

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.

In a single table,all ____________________ must be unique within that table.

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