NEW
Font size
WorksheetsCreating a Database
Total questions: 15
Worksheet time: 8mins
The data type you should use for a country's name:
Short Text
Long Text
String
Text Type
A field containing a person's entire CV (more than 255 characters)
Short Text
Long Text
String
Paragraph
To store the quantity of items in a shop the data type would be
Integer
Real Number
Number
Whole Number
You want to store the price of the food at your International Day sale, you will use
Number
Price
Currency
Expenses
To store the date of sports events at Jumeirah College, the secretary will use a field of type
Date
Date of Birth
Date/Time
Calendar
You need to store whether a superhero is reliable or not, you use a field of type
Yes/No
Maybe
True/False
Question
For an ID number which is created by the software 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
The advantage of a paper based database is that
It's easy to change data
It's portable
It requires great skill to setup and use
It's very organised
In a database, data is stored in...
tables
forms
reports
queries
Which of the following could be used to uniquely identify a record?
Validation
Primary key
Data Type
Combo box
Data validation is used to
Ensure the data entered meets certain requirements
Test whether the data is lidated
Check for irregularities and outliers
Input data in a neat and orderly fashion
A combo box is added in order to
help the user to input data easily
combine data into the table
create combined fields and records
give the user a technique to combinate data
