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?

It is is a field that uniquely identifies each record. This field can be used to link records across multiple tables.

5. Why is the ID column such a useful field? ID IS KING, “If you know the ID of a record, you can do anything you want with that record”

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? RELATED DATA THAT IS STORED IN A STRUCTURED FORMAT

11. A table is made up of what? ROWS AND COLUMNS

12. What is a record? THE ROWS IN A TABLE

A record is a group of related fields containing all of the information about a specific person, place or thing.

13. Are spaces allowed in field names? NO THEY ARE NOT

Suzie's Blog