NEW
Font size
WorksheetsDatabase Basics
Total questions: 10
Worksheet time: 5mins
The data type consisting of text consisting of letters, numbers and/or symbols up to 255 characters is called:
Short Text
Long Text
String
Text Type
The text type consisting of Text consisting of letters, numbers and/or symbols up to 64,000 characters is called
Short Text
Long Text
String
Paragraph
To store a grade or temperature the data type would be
Integer
Real Number
Number
Whole Number
You want to store the price of the products at your cake sale, you will use
Number
Price
Currency
Expenses
To store the birthdays of all Jumeirah College students, the secretary will use a field of type
Date
Date of Birth
Date/Time
Calendar
You need to store whether people have paid for their order or not, you use a field of type
Yes/No
Maybe
True/False
Question
You want the Database program to create a new number each time a new record is added, you use datatype
Generate
NewNumber
Autonumber
Automatic
A new table contains: first name, surname, date of birth, address, paid or not. List the data types to be used
Short text, Long text, Date/Time, Long Text, Yes/No
Short text, Short text, Date/Time, Long Text, Yes/No
Short text, Short text, Date, Long Text, Yes/No
Short text, Short text, Date/Time, Short Text, Yes/No
The table above has no Primary key, what is an easy and quick solution?
Add a field called ID of datatype Number and type in data for the ID's. Make this field the Primary Key
Add a field and make it an Autonumber and Primary Key
Set the Date of Birth as the Primary Key
Set the First Name and Surname as a combined Primary Key
An advantage of a computerized database is that
You can query it and obtain specific data that is relevant to your requirements
You can enter lots and lots of data and never run out of space
Anybody can access the data and use it
It's easy to use and you never need to worry about it again
