Available Answers

1. 1.

   Fill in the blanks.

   1. A table is a _______________ object that you use to store data about a particular subject.
   2. A _______________ consists of records and fields.
   3. Table properties are _______________ of a table that affect the appearance or behaviour of the table as a whole.
   4. A _______________ is a logical connection between two tables that specifies fields that the tables have in common.
   5. A _______________ key consists of one or more fields that uniquely identify each record.
2. 2.

   Write True or False.

   1. A table template is an empty table, that you can start using as-it-is, or modify to suit your needs.
   2. Fields, that are part of table relationship are called keys.
   3. A foreign key contains values, that correspond to values in the primary key of another table.
   4. There are fifteen different data types in MS Access.
   5. One can set some field properties in datasheet view or design view.
3. 3.

   Multiple Choice Questions (MCQs).

   1. Access displays the field ______________ pane, which contains a list of commonly used field types.
      1. List
      2. Template
      3. Display
   2. Fields, that are part of a table relationships are called ______________.
      1. keys
      2. area
      3. table
   3. MS Access has ______________ important types of keys.
      1. two
      2. three
      3. four
   4. A record is a ______________ of all information about an instance.
      1. column
      2. row
      3. none of these
   5. ______________ is long blocks of text and text that use text formatting.
      1. Number
      2. Text
      3. Memo
4. 4.

   What is a table?

5. 5.

   What are the data types used in MS Access?

6. 6.

   How do you create a table in Design view?