Software - Databases
Fields (2 of 2)


When we design a database we can choose what type of data is to be stored in a particular field. This is done using a field design table:


© Microsoft Corporation

  • Number fields are used when the data to be stored is a numerical value.
  • Date fields are used when data is to be stored as a date.
  • Logical fields store 'true' or 'false' values.
  • Graphical fields can store data which is held in a graphics format.
  • Currency fields store data in a currency format.