Thursday, 15 September 2011

Databases, everything anything and all of it

Data File - largest piece of the database, this is whole database
Record - holds all the details on the subject on one individual person/car/ whatever
Field - smallest part of the database, this holds one piece of information


Field Types - Text, Numeric, Date/Time, Currency, Graphic

Sort or Search

Complex - means you do this on more than one field
simple - means you do it one field

Example Answers
To find all of the blue eyed cats we would ...
Complex Search on the Pet Field for "Cat" and the eyes field for "blue"

To get a list in alphabetical order
Ascending Sort

Calculated/Computed Field
A field which uses a formula to calculate using the other fields.

How much memory does one character require.
One Byte!