Preview

03 - Table Basics

 1. ____ can be described as raw facts and figures. _____ is essentially meaningless until it is processed and made meaningful in a context.

  Information

  Knowledge

  Wisdom

  Data

 2. When____ is processed, organized, structured or presented in a given context so as to make it useful, it is called _______.

  data / information

  facts / data

  information / data

  information / wisdom

 3. Tables are perhaps the most important of database objects. A table is where__________________.

  data is stored

  queries are both created and formed

  reports are generated

  the main programmig of the interface is done

 4. Tables are made of rows and columns with cells in the places where rows and columns intersect. Fill in the blanks.
In Access, rows and columns are referred to as ____________________.

  records and files

  cells and rules

  records and fields

  files and fields

 5. Which of the following statements is correct?
Note: A field is a way of organizing information by type. Think of the field name as a question and every cell within that field as a response to that question.
table_design_fields1.png

  In this field, there are three table names: City, Country and Number

  In this database, the fields range from 1 to 12 and A B C D

  In this table, the fields are: City, Country and Number

  In this table, there are several fields including: Amsterdam, Netherlands and 812

 6. In this example, an example of a record is all the cells (from 'Country' to 'Switzerland') in column A (i.e Column 1)
Note: A record is one unit of information. Every cell on a given row is part of that row's record. 
table_design_fields2.png

  TRUE

  FALSE

 7. When editing a table (e.g. changing the data type of a particular field) you need to do so in the datasheet view.

  FALSE

  TRUE

 8. In the following example, an ideal primary key would be:
table_design_fields3.png

  Customer_ID

  Address

  Last_Name

  First_Name

 9. A primary key can be defined as a _____________________.

  an identical key field (all records will have the same primary key)

  unique key field (a table will never have two of these that are the same)

  a secure key field (all records will have a key that locks them with primary security)

  a numeric key field (a number that is always the same and can identify every single record)

 10. On setting up a table it is important to create each field with an appropriate data type. What is an appropriate data type for telephone number?
e.g. Telephone Number 1: 0073737173473; Telephone Number 2: +33 4384828348238

  Date/Time

  Autonumber

  Number

  Text

 11. When a database has two related tables, the primary key that is present in another table is called a:

  second key

  duplicate key

  secondary key

  foreign key

 12. Analyse the three tables shown below and decide which of the following statements is correct.
table_design_primary_foriegn_key.png

  StudentID and RoomID are foreign keys in the TblRoomStudent table

  RoomName and Floor are foreign keys

  Only StudentID is a primary key

  Room ID is a secondary key as it comes after StudentID in creation