Objects within a database

Objects within a database

1. Tables

   • Stores all of the data itself

2. Queries

   • Used to answer questions about the data.
   • Can extract and display records which match certain criteria
   • Queries answer questions about your data
   • Can be used to view, alter and analyse data from one or tables in a database
   • Wildcard symbols
     • * = matches any number of charecters or none
     • ? = exactly one character
   • Maths operations
     • < = greater than
     • > = Less than

3. Reports

   • Output data to the user
   • Input data
   • Friendly way

4. Forms

   • Used to format the output of data and queries in a user friendly way
   • Why are forms used?
     • Easily created using wizards
     • Forms can be used to both input and output data records
     • Allow records to be presented in a user friendly way
     • Text can be enhanced and additional text added
     • Allow command buttons to be added
     • Can be edited using a form editor
   • The best approach is to create a basic form using a wizard and then modify it when it is needed
   • You can view your data in a form
     • Add records
     • Modify records
     • Delete records
       • Be careful when deleting records
   • When you move off the record, the changes are made automatically to the table