Question 1

Which of the following statements is TRUE regarding multitable queries?

Accepted Answer

A)  Related tables never need to be previously established when you create a multitable query. 
B)  If join lines do not appear between tables, the multitable query results will not be affected. 
C)  Creating a multitable query is significantly different from creating a single-table query. 
D)  Skill is required in choosing the right tables and managing table relationships.

Question 2

Which of the following is NOT a guideline for adding fields to a database table?

Accepted Answer

A)  Consider the future use of the database. 
B)  Store data in their smallest parts. 
C)  Design to accommodate date arithmetic. 
D)  Link tables using foreign keys

Question 3

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 4

What are the three ways to run a query?

Accepted Answer

The answer of What are the three ways to run...

Question 5

The ________ data type should be applied to fields that contain a combination of characters and will be 255 characters or less.

Accepted Answer

The answer of The ________ data type should be applied...

Question 6

To count the number of records that satisfy a query, you click the Total button and select Count in the Total row in the query grid.

Accepted Answer

A) True 
 B)False

Question 7

Two or more tables that contain duplicate data are an example of:

Accepted Answer

A)  one-to-many relationships. 
B)  data redundancy. 
C)  many-to-many relationships. 
D)  data backup.

Question 8

The maximum size of the ________ data type is ________ characters.

Accepted Answer

A)  Short Text; 25 
B)  Long Text; 1,024 
C)  Long Text; 255 
D)  Short Text; 255

Question 9

Match the following data types to their definitions:
I. Short Text
II. Long Text
III. OLE Object
IV. Yes/No
V. Lookup Wizard
A. can hold up to 255 characters
B. formerly Memo data type
C. contains something created by another application
D. limits field values to on and off, for example
E. creates a field to choose a value from another table

Accepted Answer

The answer of Match the following data types to their...

Question 10

The Run command appears as a red exclamation point in Design view.

Accepted Answer

A) True 
 B)False

Question 11

When creating a multitable query, in the top section of the query design, you use ________ lines to connect common fields in related tables.

Accepted Answer

A)  join 
B)  relationship 
C)  common field 
D)  connection

Question 12

In field names, object names, and filenames, uppercase letters are used to distinguish the first letter of a new word in ________ notation.

Accepted Answer

The answer of In field names, object names, and filenames,...

Question 13

Which of the following statements is TRUE about data types and delimiters?

Accepted Answer

A)  Numeric fields require quotation marks as delimiters. 
B)  Date fields are enclosed in quotation marks. 
C)  Different data types require different delimiters. 
D)  All data types use the same delimiters.

Question 14

When using Design view, a query can only be sorted on a single criteria.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

The Answer of start a single-table query and run a is...

Question 16

Match the following terms to their meanings:
I. calculated field
II. constant
III. data redundancy
IV. data type
V. foreign key
A. date of birth is a common field example
B. field in one table that is also the primary key of another table
C. produces a value from one or more existing, often numeric, fields
D. the unnecessary storing of duplicate data
E. determine the type of entry that can be made into a field

Accepted Answer

The answer of Match the following terms to their meanings:
I....

Question 17

Data redundancy may result in errors.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is NOT a way to create a table in Access?

Accepted Answer

A)  Typing a field name in a column in Datasheet view 
B)  Typing a field name in a row in Design view 
C)  Entering table data into a new row in Datasheet view 
D)  Importing data from another database or application

Question 19

Creation of the order of fields within a table and specific field names given are significant because it's very difficult to change these after the database has been created.

Accepted Answer

A) True 
 B)False

Question 20

When using Datasheet view, what determines sort order when sorting more than one field?

Accepted Answer

A)  The order is determined from right to left. 
B)  The order is determined from left to right. 
C)  The order is determined by the first selected field to the last selected field. 
D)  The order is determined by the last selected field to the first selected field.

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

Which of the following statements is TRUE regarding multitable queries?

Which of the following is NOT a guideline for adding fields to a database table?

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.

What are the three ways to run a query?

The ________ data type should be applied to fields that contain a combination of characters and will be 255 characters or less.

To count the number of records that satisfy a query, you click the Total button and select Count in the Total row in the query grid.

Two or more tables that contain duplicate data are an example of:

The maximum size of the data type is characters.

The Run command appears as a red exclamation point in Design view.

When creating a multitable query, in the top section of the query design, you use ________ lines to connect common fields in related tables.

In field names, object names, and filenames, uppercase letters are used to distinguish the first letter of a new word in ________ notation.

Which of the following statements is TRUE about data types and delimiters?

When using Design view, a query can only be sorted on a single criteria.

Match the following tabs in Access to functions available on that tab:

Data redundancy may result in errors.

Which of the following is NOT a way to create a table in Access?

Creation of the order of fields within a table and specific field names given are significant because it's very difficult to change these after the database has been created.

When using Datasheet view, what determines sort order when sorting more than one field?