Data Storage 1

Data Storage 1

1. Text-Sequances of letters, numbers and other symbols.Someone's name would be a text field. A Field that can accept multi line text is often called a memo field.

2. Number-Respresents a numerical value. A product's price or the number of items left in stock would be stored as numbers. This would enable you to produce a report summing up the prices of all the products you had sold,which wouldn't be possible if they were stored as text

3. Data/time-Stores dates or a combination of dates and time

4. Logical-Represents a value that is either true or false,For Example when a costumer opens an account with an online company they might be asked whether they are happy to recieve marketing material.

5. Key Terms

   • Database-A Collection of data stored in a structred way.
   • Table-A two dimensional representation of data in a database
   • Record-A Group of selected data which are associated in some way
   • Field-A Signle Piece of data within a record
   • Primary Key-A Single unique key used to identify each record in a table
   • Foreign Key-A Field which can be used to cross refrence and access associated information across many tables