object within a database

object within a database

1. tables

   • stores the data itself

2. queries

   • used to answer question 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 more tables in a database
   • can be used as the source of records in forms or reports
   • only the required data displayed
   • can be saved for future use
   • criteria
     • wildcards symbols
       • wild card can be used: * matches any number of characters or none. ? matches exactly one character
     • maths operators
       • examples
         • or
         • and
         • >(greater than) and <(less than)
         • between.....and.......(can be number or date
     • can be combined >25 and<50

3. reports

   • used to format the outputs of data from tables or quries in a user friendly way- mainly for printing

4. forms

   • used to input and/or outputs data in a user friendly way- for on-screen use
   • why we use them
     • easily created using wizards
     • forms can be used to both input and output data records
     • allows records to be presented in a user friendly way
     • text can be enhanced and additional text added
     • allows command buttons to be added
       • e.g. delete button, search button
     • can be edited using a form editor
     • you can view your data base in a form and you can
       • add records
       • modify records
       • delete records
     • when you move off the record the changes are made automatically to the table
     • be carful when deleting records.
   • best approach is to
     • create the basic form using the wizard
     • then modify it as needed