objects within a database

objects within a database

1. tables

   • store the data itself.

2. queries

   • used to answer questions about data.
   • used to view, alter and analyse data from one or more tables in a database.
   • can be saved for future use.
   • wildcards can be used: * = matches any number or more ? = matches exactly one character

3. reports

   • used to format output of data.
   • easily created using wizards.
   • used to input and output data records.
   • allow command buttons to be added.
   • can be edited using a form editor.

4. forms

   • used to input and output data in a user friendly way.
   • best approach is to create basic from using wizard then modify it as it is needed.
   • you can view your data in a form also you can add records, modify records, and delete records.
   • once you delete a record you cannot get it back again.