1. What does a column in a table represent?
A field.
2. What does a row in a table represent?
A record.
3. What does DBMS stand for?
Database Management System.
4. What is a primary key in a table used for?
Identifying records uniquely.
5. Why is the ID column such a useful field?
Because if you know the primary key/ID of a record, you can do anything with that record.
6. What Access data type would you use to store the string “18 Segway Drive, Moonville” ?
The Text data type.
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?
The Number data type.
9. What Access data type would you use to store a long string such as an essay or report?
The Memo data type.
10. A database is a collection of what?
A database is a collection of related data stored in a structured format.
11. A table is made up of what?
Rows and columns.
12. What is a record?
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?
Yes, but it is not good practice.
No comments:
Post a Comment