Question 1

-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 of rules to help ensure that no orphan records are created in the database.An orphan record is a record in the "many" table that has no match in the "one" table.Checking the Enforce Referential Integrity option prevents this possibility for new records entered into the database.

Question 2

-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 AutoNumber data type.Access automatically provides a unique,sequential value for each record.Anne will not be able to edit that value.

Question 3

The goal of building one-to-many relationships between tables is to minimize ____ data.

Accepted Answer

A)  redundant 
B)  textual 
C)  numeric 
D)  rarely used 
A)  redundant 
B)  textual 
C)  numeric 
D)  rarely used A

Question 4

-In the accompanying figure,the data type for the PaymentAmt field is ____________________.

Accepted Answer

The answer of  
-In the accompanying figure,the data type...

Question 5

The Field Size property is not available for Currency fields.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

-In the accompanying figure,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 9

The Input Mask property provides a pattern for data to be entered using three parts.

Accepted Answer

A) True 
 B)False

Question 10

Where do you modify field properties?

Accepted Answer

A)  In Table Layout View. 
B)  In Table Design View. 
C)  In Database Design View 
D)  As you are entering data in a form. 
A)  In Table Layout View. 
B)  In Table Design View. 
C)  In Database Design View 
D)  As you are entering data in a form.

Question 11

A(n)____________________ record is a record in the "many" table that doesn't have a matching entry in the linking field of the "one" table.

Accepted Answer

The answer of A(n)____________________ record is a record in the...

Question 12

Which Short Text field property should you use to specify whether an entry was required for the field?

Accepted Answer

A)  Default Value 
B)  Default 
C)  Required 
D)  Test 
A)  Default Value 
B)  Default 
C)  Required 
D)  Test

Question 13

You can enter optional field descriptions in Table ____ View.

Accepted Answer

A)  SQL 
B)  Query 
C)  Design 
D)  Layout 
A)  SQL 
B)  Query 
C)  Design 
D)  Layout

Question 14

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 15

In an Access relational database,to tie the information from one table to another,a(n)____ must be common to each table.

Accepted Answer

A)  record 
B)  field 
C)  object 
D)  property 
A)  record 
B)  field 
C)  object 
D)  property

Question 16

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 17

-In the accompanying figure,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 18

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 19

-In the accompanying figure,explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

Accepted Answer

A primary key field is a field that cont

Question 20

The ____ key field is the linking field on the "many" side of the relationship.

Accepted Answer

A)  record 
B)  table 
C)  link 
D)  foreign 
A)  record 
B)  table 
C)  link 
D)  foreign

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

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

The goal of building one-to-many relationships between tables is to minimize ____ data.

-In the accompanying figure,the data type for the PaymentAmt field is ____________________.

The Field Size property is not available for Currency fields.

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

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

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

The Input Mask property provides a pattern for data to be entered using three parts.

Where do you modify field properties?

A(n)____________________ record is a record in the "many" table that doesn't have a matching entry in the linking field of the "one" table.

Which Short Text field property should you use to specify whether an entry was required for the field?

You can enter optional field descriptions in Table ____ View.

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

In an Access relational database,to tie the information from one table to another,a(n)____ must be common to each table.

Which of the following is NOT true about field properties?

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

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

-In the accompanying figure,explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

The ____ key field is the linking field on the "many" side of the relationship.

Word 2013 : Creating and Formatting Tables

Word 2013 : Illustrating Documents With Graphics

Word 2013 : Working With Themes and Building Blocks

Word 2013 : Merging Word Documents

Powerpoint 2013 : Working With Advanced Tools and Masters

Powerpoint 2013 : Enhancing Charts

Powerpoint 2013 : Inserting Graphics, Media, and Objects

Powerpoint 2013 : Using Advanced Features

Integration : Integrating Word and Excel

Integration : Integrating Word, Excel, and Access

Integration : Integrating Word, Excel, Access, and Powerpoint

Excel 2013 : Analyzing Data Using Formulas

Excel 2013 : Managing Workbook Data

Excel 2013 : Managing Data Using Tables

Excel 2013 : Analyzing Table Data

Access 2013 : Improving Queries

Access 2013 : Enhancing Forms

Access 2013 : Analyzing Data With Reports

Working in the Cloud

Filters

Exam 16: Access 2013 : Modifying the Database Structure

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

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

The goal of building one-to-many relationships between tables is to minimize ____ data.

-In the accompanying figure,the data type for the PaymentAmt field is ____________________.

The Field Size property is not available for Currency fields.

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

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

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

The Input Mask property provides a pattern for data to be entered using three parts.

Where do you modify field properties?

A(n)____________________ record is a record in the "many" table that doesn't have a matching entry in the linking field of the "one" table.

Which Short Text field property should you use to specify whether an entry was required for the field?

You can enter optional field descriptions in Table ____ View.

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

In an Access relational database,to tie the information from one table to another,a(n)____ must be common to each table.

Which of the following is NOT true about field properties?

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

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

-In the accompanying figure,explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

The ____ key field is the linking field on the "many" side of the relationship.

Word 2013 : Creating and Formatting Tables

Word 2013 : Illustrating Documents With Graphics

Word 2013 : Working With Themes and Building Blocks

Word 2013 : Merging Word Documents

Powerpoint 2013 : Working With Advanced Tools and Masters

Powerpoint 2013 : Enhancing Charts

Powerpoint 2013 : Inserting Graphics, Media, and Objects

Powerpoint 2013 : Using Advanced Features

Integration : Integrating Word and Excel

Integration : Integrating Word, Excel, and Access

Integration : Integrating Word, Excel, Access, and Powerpoint

Excel 2013 : Analyzing Data Using Formulas

Excel 2013 : Managing Workbook Data

Excel 2013 : Managing Data Using Tables

Excel 2013 : Analyzing Table Data

Access 2013 : Improving Queries

Access 2013 : Enhancing Forms

Access 2013 : Analyzing Data With Reports

Working in the Cloud

Filters