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.

  Data

  Information

  Wisdom

  Knowledge

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

  facts / data

  information / data

  information / wisdom

  data / information

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

  reports are generated

  the main programmig of the interface is done

  queries are both created and formed

  data is stored

 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 ____________________.

  files and fields

  records and fields

  records and files

  cells and rules

 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 database, the fields range from 1 to 12 and A B C D

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

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

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

 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

  Last_Name

  Address

  First_Name

  Customer_ID

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

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

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

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

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

 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

  Autonumber

  Text

  Number

  Date/Time

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

  duplicate key

  secondary key

  foreign key

  second 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

  Only StudentID is a primary key

  RoomName and Floor are foreign keys

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