Data Applications

Data Applications

1. Database concepts

   • A table consists of a number of records
     • A record is represented as a row in a table
   • A field is part of a record that stores a single data item, represented by a column
     • Forms are used to collect data to create a new record, modify an existing record or view records already stored in a table
   • A key field uniquely identifies one record
     • A query searches and filters data in a database that satisfies the query criteria