Objects within a database

Objects within a database

1. Queries

   • answer questions about the data. extract records to match criterion.
   • Queries answer questions about your data
   • can be used to view, alter or analyse data from a table.
   • can be used as a source of records for a form or report
   • Only the required data is displayed.
   • Can be saved for future use
   • Criteria
     • Exact values
       • Between... and...is used in place of <> with dates and numbers
       • AND used to combine functions to refine results.
       • Maths operators
         • > means more than and can be used to find values over an amount.
         • < means less than and can be used and combined to find values under an amount.
       • OR results to widen results and search.
     • Wildcards
       • ? means an exact amount of characters.
       • * means any or no characters for example S* search for something beginning with S.

2. Forms

   • On-screen format for input and output
   • Easily created using wizarda
     • The best approach is to create a basic form using wizard THEN modify as needed
   • Forms can be used for both input and output of data
   • Allows records to be presented in a user friendly way.
   • Text can be added and enhanced
   • Can be edited with a form editor.
   • Command buttons for user friendliness.
     • NEXT
     • SEARCH
     • DELETE
     • ADD
   • Using forms: you can...
     • ADD-adds to the table.
     • MODIFY changed
     • DELETE- gone forever
   • Table is automatically updated

3. Reports

   • Used to format output of tables- for printings.