Creating Tables Test Page

QUESTION 1

To make a field the primary key, how should you be looking at your table?

In Datasheet View
In the Field Builder
In Design View
In the Table Wizard



QUESTION 2
What is this toolbar button used for?

To insert a field
To show the Indexes dialog box
To delete a field
To open the Field Builder dialog box



QUESTION 3

A field of which data type will not allow you to enter a number?

Text
AutoNumber
Currency
Memo



QUESTION 4

Which of the following statements is true?

Only the primary key should be indexed
Every field should be indexed
Indexing a field can help with sorting data
Fields can only be indexed if all the values are unique



QUESTION 5

From left (smallest) to right (largest) can you select which number types are capable of describing the largest number ranges?

Integer, Long Integer, Byte, Single
Byte, Long Integer, Single, Double
Integer, Single, Long Integer, Double
Byte, Single, Double, Long Integer



QUESTION 6

How many buttons from the left on the toolbar is the View button for toggling between design and datasheets views?

Fourth
Third
Second
First



QUESTION 7

What does the Build button do?

It displays the Field Builder dialog box
It starts to compile the database to make it run faster
It lets you add new indexes to your fields
It lets you see and set the field properties



QUESTION 8

Where does the Description text created in Design View appear in Datasheet View?

To the left of the field name
On the Status Bar
To the right of the field name
As tooltip text when you hover over the field



QUESTION 9

Which of the following is NOT a valid choice for indexing?

No
Yes (Duplicates OK)
Yes (No Duplicates)
No (Unless Duplicated)



QUESTION 10

Which of the following statements is true?

Unless the Caption property of a field is entered you will not see a name for the field
A default value must be given where a field has the Required property set to Yes
You cannot enter more than 50 characters into a text field
You can have spaces in a field name