Creating a Database

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