Case Study: Membership

[M_a] 

• What is Member number (MemberNo) for ?
  • To uniquely identify each record in the table. Necessary for example if two names are the same eg. Mary Smith.
• Explain what is meant by "Key field".
  • A field used to uniquely identify a record. Most commonly stored as a Counter which is a number created by the database.
• Why have we used Address1 and TownCity rather than Street, City ?
  • Not all addresses are Street, City. People live in towns, have rural codes for addresses or use PO Box numbers.
  • This reduces the confusion for a data entry operator as to where to enter the data.

• Why is phone text rather than numeric ?
  • phone numbers are not used in calculations (normally), and often inclde alphanumeric character
    • eg. (09) 123-456, 123-444 ex 123
• What does a "Single" in the field size mean?
  • Refer to MS-Access97 Reference:
     Field data types