Question 1

The . J p g file extension is short for JPEG , an acronym for the Joint Photographic Experts Group.

Accepted Answer

A) True 
 B)False

Question 2

A subdatasheet is used to modify field properties.

Accepted Answer

A) True 
 B)False

Question 3

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 4

Which of the following is a clue that a database needs to be redesigned?

Accepted Answer

A)  Key fields are defined for each table. 
B)  One-to-many relationships are defined for each table. 
C)  There are multiple tables in the database. 
D)  There is redundant data in one or more tables. 
A)  Key fields are defined for each table. 
B)  One-to-many relationships are defined for each table. 
C)  There are multiple tables in the database. 
D)  There is redundant data in one or more tables.

Question 5

In the accompanying figure, how does the Enforce Referential Integrity option relate to the creation of orphan records?

Accepted Answer

Enforce Referential Integrity is a set o

Question 6

Which of the following is NOT a problem with duplicated data?

Accepted Answer

A)  It is error-prone. 
B)  It limits query capabilities. 
C)  It limits reporting capabilities. 
D)  It creates its own one-to-many relationships. 
A)  It is error-prone. 
B)  It limits query capabilities. 
C)  It limits reporting capabilities. 
D)  It creates its own one-to-many relationships.

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

Which of the following is NOT a good candidate for a primary key field for a Customer table?

Accepted Answer

A)  Last Name 
B)  Customer Number 
C)  Employee Identification Number 
D)  Customer ID 
A)  Last Name 
B)  Customer Number 
C)  Employee Identification Number 
D)  Customer ID

Question 9

What data type sequences each new record with the next available integer?

Accepted Answer

A)  Yes/No 
B)  Memo 
C)  Attachment 
D)  AutoNumber 
A)  Yes/No 
B)  Memo 
C)  Attachment 
D)  AutoNumber

Question 10

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 11

Which of the following is NOT a possible entry for the Field Size property of a Number field?

Accepted Answer

A)  Currency 
B)  Byte 
C)  Long Integer 
D)  Single 
A)  Currency 
B)  Byte 
C)  Long Integer 
D)  Single

Question 12

The Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

Accepted Answer

The answer of The Row ____________________ Lookup property stores the...

Question 13

For a Date/Time field, use the Format property to display the date 1/17/2015 as January 17, 2015.

Accepted Answer

A) True 
 B)False

Question 14

In the accompanying figure, explain how two tables are being joined. Mention which tables are being joined, the relationship that is being created, and the fields used to make the connection.

Accepted Answer

The Customers and Sales tables

Question 15

Using the accompanying figure, list three principles of relational database design. Use the specific table and field names in your explanation.

Accepted Answer

1. Design each table to contain fields t

Question 16

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

Accepted Answer

A)  Row Source 
B)  Limit to List 
C)  Allow Value List Edits 
D)  Display Control 
A)  Row Source 
B)  Limit to List 
C)  Allow Value List Edits 
D)  Display Control

Question 17

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

Accepted Answer

A)  Format 
B)  Caption 
C)  Default Value 
D)  Input Mask 
A)  Format 
B)  Caption 
C)  Default Value 
D)  Input Mask

Question 18

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

Accepted Answer

A)  indexes 
B)  tables 
C)  links 
D)  properties 
A)  indexes 
B)  tables 
C)  links 
D)  properties

Question 19

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

Accepted Answer

The PaymentNo field is an Auto

Question 20

Kelsey wants to create queries to answer management questions from a relational database she does not have much experience with. Why might a Relationships report help her create the queries?

Accepted Answer

A Relationship report would show her how

The . J p g file extension is short for JPEG , an acronym for the Joint Photographic Experts Group.

A subdatasheet is used to modify field properties.

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

Which of the following is a clue that a database needs to be redesigned?

In the accompanying figure, how does the Enforce Referential Integrity option relate to the creation of orphan records?

Which of the following is NOT a problem with duplicated data?

Which of the following is NOT true about field properties?

Which of the following is NOT a good candidate for a primary key field for a Customer table?

What data type sequences each new record with the next available integer?

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

Which of the following is NOT a possible entry for the Field Size property of a Number field?

The Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

For a Date/Time field, use the Format property to display the date 1/17/2015 as January 17, 2015.

In the accompanying figure, explain how two tables are being joined. Mention which tables are being joined, the relationship that is being created, and the fields used to make the connection.

Using the accompanying figure, list three principles of relational database design. Use the specific table and field names in your explanation.

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

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

Kelsey wants to create queries to answer management questions from a relational database she does not have much experience with. Why might a Relationships report help her create the queries?

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Forms

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters

Exam 5: Using Reports

The . J p g file extension is short for JPEG , an acronym for the Joint Photographic Experts Group.

A subdatasheet is used to modify field properties.

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

Which of the following is a clue that a database needs to be redesigned?

In the accompanying figure, how does the Enforce Referential Integrity option relate to the creation of orphan records?

Which of the following is NOT a problem with duplicated data?

Which of the following is NOT true about field properties?

Which of the following is NOT a good candidate for a primary key field for a Customer table?

What data type sequences each new record with the next available integer?

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

Which of the following is NOT a possible entry for the Field Size property of a Number field?

The Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

For a Date/Time field, use the Format property to display the date 1/17/2015 as January 17, 2015.

In the accompanying figure, explain how two tables are being joined. Mention which tables are being joined, the relationship that is being created, and the fields used to make the connection.

Using the accompanying figure, list three principles of relational database design. Use the specific table and field names in your explanation.

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

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

Kelsey wants to create queries to answer management questions from a relational database she does not have much experience with. Why might a Relationships report help her create the queries?

Getting Started With Microsoft Office 2013

Getting Started With Access 2013

Building and Using Queries

Using Forms

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters