Question 1

Which of the following is FALSE about changes in multitable queries?

Accepted Answer

A)   Deleting a join line affects all relationships in all tables of the database.
B)   Join lines can be deleted in a query with no impact on the relationships.
C)   When you add two tables to a query, join lines appear automatically.
D)   The Relationship window displays join lines. A

Question 2

Linking tables using common fields is a suggested guideline for successfully adding fields to a database.

Accepted Answer

A) True 
 B)False  True

Question 3

Which of the following statements is TRUE about how Access and Excel share data?

Accepted Answer

A)   Access can import data from Excel, but cannot export data to Excel.
B)   Access can export data to Excel, but cannot import data from Excel.
C)   Access can import data from Excel, and export data to Excel.
D)   Access cannot import data from Excel and cannot export data to Excel. C

Question 4

When designing a database,an important guideline is to store data in their largest parts.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is FALSE about multitable queries?

Accepted Answer

A)   You can add tables of a multitable query using the Show Table dialog box.
B)   You can delete tables of a multitable query by clicking the unwanted table and pressing Delete.
C)   You can add fields by clicking a field selector and clicking Add.
D)   The Relationship window displays join lines.

Question 6

The ________ group on the External Data tab has options that you can use to send a portion of a database to other applications.

Accepted Answer

A)   Import & Link
B)   Export
C)   Collect Data
D)   Web Linked Lists

Question 7

Using a field that contains a year of birth and a field that contains the current year to determine the age of a person listed in a database is called ________.

Accepted Answer

The answer of Using a field that contains a year...

Question 8

Which statement accurately describes the function of a query?

Accepted Answer

A)   Queries allow a user to ask questions about data and then provide answers by providing subsets or summaries of data.
B)   Queries delete data stored in tables, displaying only those records that match the query's criteria.
C)   Queries edit data stored in tables, displaying only those records that match the query's criteria.
D)   Queries manipulate data stored in tables, hiding only those records that match the subsets or summaries of the query's criteria.

Question 9

Which of the following is NOT a type of relationship available in Access 2013?

Accepted Answer

A)   One-to-one
B)   One-to-many
C)   Many-to-one
D)   Many-to-many

Question 10

A one-to-many relationship is established when the foreign key in the first table matches multiple primary key values in the second table.

Accepted Answer

A) True 
 B)False

Question 11

Match between columns
                        Premises: Home tab
Design tab
Query Tools Design tab
Create tab
External Data tab

Accepted Answer

The Answer of import Excel data and start a single-table is...

Question 12

The ________ data type can be used for fields that contain monetary values.

Accepted Answer

The answer of The ________ data type can be used...

Question 13

Describe a wildcard in Access.Mention at least two wildcards that are available in Access.

Accepted Answer

The answer of Describe a wildcard in Access.Mention at least...

Question 14

Match between columns
                        Premises: constant
data redundancy
data type
foreign key
calculated field

Accepted Answer

The Answer of field in one table that is also is...

Question 15

Sarah is working in a database that stores resort vacation information.She needs to design a field that will allow a user to link to a Web page.Sarah should apply a(n)________ type.

Accepted Answer

A)   Short Text
B)   OLE Object
C)   Hyperlink
D)   Lookup Wizard

Question 16

If a user selects the ________ Related Fields option while creating a relationship,Access will automatically modify all foreign key values in a related table to match any modifications made to the primary key.

Accepted Answer

The answer of If a user selects the ________ Related...

Question 17

Match between columns
                        Premises: field property
short text data type
caption property
AutoNumber
number data type

Accepted Answer

The Answer of data type that automatically increments when a is...

Question 18

Match between columns
                        Premises: Long Text
AutoNumber
OLE Object
Attachment
Short Text

Accepted Answer

The Answer of JPG image of a lake and a is...

Question 19

An unchanging value is called a(n)________.

Accepted Answer

The answer of An unchanging value is called a(n)________....

Question 20

Match between columns
                        Premises: Result Type
Indexed
Validation Text
Required
Format

Accepted Answer

The Answer of changes the way a field is displayed is...

Exam 14: Tables and Queries in Relational Databases: Designing Databases and Extracting Data