Database Blog Task

1. What does a column in a table represent?
Field

2. What does a row in a table represent?
Record

3. What does DBMS stand for?
Database Management System

4. What is a primary key in a table used for?
A unique field used to create relationships between different tables.

5. Why is the ID column such a useful field?
Its useful for uniquely identifying records, especially those that share similar details such as a first name and last name.

6. What Access data type would you use to store the string “18 Segway Drive, Moonville” ?
Text

7. What Access data type would you use to record True/False values?
Boolean

8. What Access data type would you use to store a number?
Number

9. What Access data type would you use to store a long string such as an essay or report?
Memo


10. A database is a collection of what?
Tables

11. A table is made up of what?
Records

12. What is a record?
A row of information in a table such as first name, last name and various other information such as telephone numbers, address etc.

13. Are spaces allowed in field names?
No.