Types of Database Models........................................................................................................ 11
Stages of a Database................................................................................................................. 12
Applications of Databases......................................................................................................... 13
Structured Query Language....................................................................................................... 14
Lookup in Fields/Columns....................................................................................................... 18
Input Masks............................................................................................................................. 20
Setting Data Entry.................................................................................................................... 23
Table Relationships.................................................................................................................. 25
Many-to-Many Relationship....................................................................................................... 28
Referential Integrity.................................................................................................................. 30
Automatic Field Update............................................................................................................ 32
Inner & Outer Join................................................................................................................... 34
Update Query.......................................................................................................................... 39
Append Records...................................................................................................................... 41
Delete Query........................................................................................................................... 43
Make-Table Query.................................................................................................................... 45
Crosstab Query........................................................................................................................ 47
Duplicated Records.................................................................................................................. 53
Unmatched Records................................................................................................................. 56
Variable Parameter Query......................................................................................................... 61
Wildcards................................................................................................................................ 63
Maximum and Minimum Values................................................................................................ 65
Calculated Field........................................................................................................................ 67
Sum Functions......................................................................................................................... 68
