13 questions
Which datatype is most suitable for the following:
7
TEXT
CURRENCY
NUMBER
DATE/TIME
WHICH DATA TYPE IS SUITABLE FOR:
YES/NO
NUMBER
TEXT
DATE/TIME
LOGICAL
WHICH DATATYPE IS MOST SUITABLE FOR THE FIELD:
FIRST NAME
LOGICAL
TEXT
NUMBER
CURRENCY
WHICH DATATYPE IS SUITABLE FOR CREATING A FIELD FOR DATE OF BIRTH?
LOGICAL
NUMBER
TEXT
DATE/TIME
_____________ is used to uniquely identify each record in a database.
A primary key in one table and is reused in another table is called a/an ________________________.
A row is also referred to as a/an ________________.
while a column is referred to as a/an ______________________.
The view that displays the data dictionary/table structure is called:
Design view
Datasheet view
The view that displays the full table is known as:
Design View
Datasheet view
What field is used to create a link/relationship in the following picture?
ID
STUDENT
ACTIVITY
COST
Which menu do you select to create a relationship in Microsoft access?
Home
Database Tools
Create
File
Which of the following is an advantage of a database software?
Expensive
Initial training is required
saves storage space
time consuming