Multiple Tables (& foreign keys)

Blog Task 1

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 Systems

4. What is a primary key in a table used for?

    Primary key is used to identify each record. This field is usually the ID field and can be used to link
    records across multiple tables.

5. Why is the ID column such a useful field?

    To identify fields

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?

     Yes/No

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?

     A collection of related data in a structured format (such as text, memo, number,

      Date/Time, Currency, Yes/No..etc.)

11. A table is made up of what?

      Rows and columns (Records and Fields)

12. What is a record?

     The rows in a table  

13. Are spaces allowed in field names?

      Yes, but it is not best practive

DatabaseScreenshot