Question 1

When you import data, where can you not store it?

Accepted Answer

A)  New form 
B)  New table 
C)  Existing table 
D)  Linked table

Question 2

Match the following field properties with their example:
i. Default Value
II. Validation Text
III. Validation Rule
IV. Input Mask
v. Field Size

Accepted Answer

A)  !\(999") "000\-0000;0;_ 
B)  "MD" 
C)  14 
D)  "MD" Or "PA" Or "WV" 
E)  "Please enter a value greater than 40."

Question 3

Access does not require that every table has a primary key.

Accepted Answer

A) True 
 B)False

Question 4

What data type assigns the next consecutive number to new records?

Accepted Answer

A)  Number 
B)  AutoNumber 
C)  IncreaseNumber 
D)  Integer

Question 5

One advantage of establishing relationships between tables is so you can combine fields from more than one table in a query or report.

Accepted Answer

A) True 
 B)False

Question 6

If you wanted the user to pick from a particular list, what would you pick from the data type drop down list for that field?

Accepted Answer

A)  List 
B)  Short Text 
C)  Lookup Wizard 
D)  Long Text

Question 7

In a query, the sort order, when sorting on multiple fields, is determined by the field order from left to right.

Accepted Answer

A) True 
 B)False

Question 8

It is safe to change data in a query since you are only changing a temporary copy of the data, not the underlying data in the table.

Accepted Answer

A) True 
 B)False

Question 9

You can only have one primary key in a table, but you can have several foreign keys.

Accepted Answer

A) True 
 B)False

Question 10

What is not true about the Caption property?

Accepted Answer

A)  It allows labels to be more readable than field names. 
B)  It displays at the column head instead of the field name. 
C)  It is used in both forms and reports. 
D)  The Pascal case is preferred in this property.

Question 11

How many characters can be stored in a field with a Long Text data type?

Accepted Answer

A)  1,000 
B)  12,256 
C)  Unlimited 
D)  64,000

Question 12

Match the following terms with their description:
i. Caption
II. Foreign key
III. Data type
IV. Field properties
v. Wildcards

Accepted Answer

A)  Used to relate tables on common fields 
B)  Effects what operations can be performed on data 
C)  Characteristic of a field 
D)  Special characters that can represent other characters 
E)  More understandable than a field name

Question 13

A field's ________ determine how that field functions.

Accepted Answer

The answer of A field's ________ determine how that field...

Question 14

What is not one of the six guidelines for designing tables?

Accepted Answer

A)  Store data in as large of number of parts as possible 
B)  Determine the primary keys 
C)  Link the tables on related fields 
D)  Think of what needs you might have in the future

Question 15

The ________ property provides literal characters that are typed for each entry.

Accepted Answer

A)  Validation Rule 
B)  Default Value 
C)  Validation text 
D)  Input Mask

Question 16

Use the ________ data type if you need to store a True or False value.

Accepted Answer

The answer of Use the ________ data type if you...

Question 17

One way to fix the problem that exists if you add a table with 10 records to a query and add an unrelated table with 4 records to the same query is to add ________ lines if there are common fields.

Accepted Answer

The answer of One way to fix the problem that...

Question 18

Use the ________ data type when you do not know how much text space will be required.

Accepted Answer

The answer of Use the ________ data type when you...

Question 19

You can easily ________ your data by using a multitable query.

Accepted Answer

The answer of You can easily ________ your data by...

Question 20

Data entered in a query is actually stored in the underlying table(s).

Accepted Answer

A) True 
 B)False

Exam 3: Access: Tables and Queries in Relational Databases

When you import data, where can you not store it?

Match the following field properties with their example: i. Default Value II. Validation Text III. Validation Rule IV. Input Mask v. Field Size

Access does not require that every table has a primary key.

What data type assigns the next consecutive number to new records?

One advantage of establishing relationships between tables is so you can combine fields from more than one table in a query or report.

If you wanted the user to pick from a particular list, what would you pick from the data type drop down list for that field?

In a query, the sort order, when sorting on multiple fields, is determined by the field order from left to right.

It is safe to change data in a query since you are only changing a temporary copy of the data, not the underlying data in the table.

You can only have one primary key in a table, but you can have several foreign keys.

What is not true about the Caption property?

How many characters can be stored in a field with a Long Text data type?

Match the following terms with their description: i. Caption II. Foreign key III. Data type IV. Field properties v. Wildcards

A field's ________ determine how that field functions.

What is not one of the six guidelines for designing tables?

The ________ property provides literal characters that are typed for each entry.

Use the ________ data type if you need to store a True or False value.

One way to fix the problem that exists if you add a table with 10 records to a query and add an unrelated table with 4 records to the same query is to add ________ lines if there are common fields.

Use the ________ data type when you do not know how much text space will be required.

You can easily ________ your data by using a multitable query.

Data entered in a query is actually stored in the underlying table(s).