Question 1

____________________  is the name of the table in the figure above.

Accepted Answer

Customers

Question 2

____ properties allow you to supply a drop-down list of values for a field.

Accepted Answer

A) Key 
B) Relationship 
C) Lookup 
D) Junction 
A) Key 
B) Relationship 
C) Lookup 
D) Junction C

Question 3

Each field must be given an associated field description.

Accepted Answer

A) True 
 B)False  False

Question 4

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

Accepted Answer

A) True 
 B)False

Question 5

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

Accepted Answer

A) True 
 B)False

Question 6

The Validation Rule property is not used with Text or Date/Time fields.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is NOT true about field properties?

Accepted Answer

A) Modifying them helps ensure database accuracy 
B) Some are required, and some are optional 
C) They are the same for each data type 
D) They can be used to change the way data is displayed 
A) Modifying them helps ensure database accuracy 
B) Some are required, and some are optional 
C) They are the same for each data type 
D) They can be used to change the way data is displayed

Question 8

List three principles of relational database design.

Accepted Answer

1.Design each table to contain fields th

Question 9

Explain why using an employee's last name as the primary key field in an employee table does not constitute good database design.

Accepted Answer

A primary key field is a field that cont

Question 10

The Enforce Referential Integrity button is found on the Database toolbar.

Accepted Answer

A) True 
 B)False

Question 11

.j p g file extension is short for J P E G, an acronym for the Joint Photographic Experts Group.

Accepted Answer

A) True 
 B)False

Question 12

A Number data type is used to store values that represent money.

Accepted Answer

A) True 
 B)False

Question 13

In the figure above, item 1 points to a(n)____.

Accepted Answer

A) Primary key field 
B) Foreign key 
C) Field property 
D) Table name 
A) Primary key field 
B) Foreign key 
C) Field property 
D) Table name

Question 14

The file extension for a database created in Access 2010 is:

Accepted Answer

A) .acc 
B) .accdb 
C) .mdb 
D) .mda 
A) .acc 
B) .accdb 
C) .mdb 
D) .mda

Question 15

You can edit or delete a relationship once it has been created in the Relationships window.

Accepted Answer

A) True 
 B)False

Question 16

In the figure above, the "one" side of a one-to-many relationship is referenced by which item?

Accepted Answer

A) 1 
B) 2 
C) 3 
D) 4 
A) 1 
B) 2 
C) 3 
D) 4

Question 17

Anne Michael is working with the table in the figure above.Explain what will happen when she works with the FirstContact field in Datasheet View.

Accepted Answer

The FirstContact field has been given lo

Question 18

Which of the following is NOT defined in Table Design View?

Accepted Answer

A) Field names 
B) Field entries 
C) Data types 
D) Field properties 
A) Field names 
B) Field entries 
C) Data types 
D) Field properties

Question 19

Changing the Decimal Places property for a field does not change the actual data stored in the field.

Accepted Answer

A) True 
 B)False

Question 20

Grant enters a tour date of May 14, 2013 in the TourStartDate field pictured above. In what way will the date appear when he tabs out of the field in Datasheet View?

Accepted Answer

mm/dd/yyyy

____________________ is the name of the table in the figure above.

____ properties allow you to supply a drop-down list of values for a field.

Each field must be given an associated field description.

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

The Validation Rule property is not used with Text or Date/Time fields.

Which of the following is NOT true about field properties?

List three principles of relational database design.

Explain why using an employee's last name as the primary key field in an employee table does not constitute good database design.

The Enforce Referential Integrity button is found on the Database toolbar.

.j p g file extension is short for J P E G, an acronym for the Joint Photographic Experts Group.

A Number data type is used to store values that represent money.

In the figure above, item 1 points to a(n)____.

The file extension for a database created in Access 2010 is:

You can edit or delete a relationship once it has been created in the Relationships window.

In the figure above, the "one" side of a one-to-many relationship is referenced by which item?

Anne Michael is working with the table in the figure above.Explain what will happen when she works with the FirstContact field in Datasheet View.

Which of the following is NOT defined in Table Design View?

Changing the Decimal Places property for a field does not change the actual data stored in the field.

Grant enters a tour date of May 14, 2013 in the TourStartDate field pictured above. In what way will the date appear when he tabs out of the field in Datasheet View?

Getting Started With Microsoft Office 2010 Question

Building and Using Queries

Using Forms Question

Using Reports Question

Improving Queries Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Getting Started With Access 2.0

Filters

Exam 5: Modifying the Database Structure Question

____________________ is the name of the table in the figure above.

____ properties allow you to supply a drop-down list of values for a field.

Each field must be given an associated field description.

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

The Validation Rule property is not used with Text or Date/Time fields.

Which of the following is NOT true about field properties?

List three principles of relational database design.

Explain why using an employee's last name as the primary key field in an employee table does not constitute good database design.

The Enforce Referential Integrity button is found on the Database toolbar.

.j p g file extension is short for J P E G, an acronym for the Joint Photographic Experts Group.

A Number data type is used to store values that represent money.

In the figure above, item 1 points to a(n)____.

The file extension for a database created in Access 2010 is:

You can edit or delete a relationship once it has been created in the Relationships window.

In the figure above, the "one" side of a one-to-many relationship is referenced by which item?

Anne Michael is working with the table in the figure above.Explain what will happen when she works with the FirstContact field in Datasheet View.

Which of the following is NOT defined in Table Design View?

Changing the Decimal Places property for a field does not change the actual data stored in the field.

Grant enters a tour date of May 14, 2013 in the TourStartDate field pictured above. In what way will the date appear when he tabs out of the field in Datasheet View?

Getting Started With Microsoft Office 2010 Question

Building and Using Queries

Using Forms Question

Using Reports Question

Improving Queries Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Getting Started With Access 2.0

Filters