objects within a database

objects within a database

1. tables

   • stores the data its self

2. queries

   • used to answer questions about the data can extract and explain and display records which match certain criteira
   • 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 to source of records in forms or reports
   • only the required data is displayed
   • can be saved for future use
   • criteria
     • wildcard symbols and maths operators can be used
     • examples include or, and > greater than < less than between and (can be number or dates)
     • criteria can be combined e.g
       • >25 and <50
     • wildcards can be used
       • * matches any number of characters or none
       • ? matches exactly one charcter

3. reports

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

4. forms

   • used to input and/or data in a friendly way-for on screen use
   • can be created by wizard
   • forms can be used to both in put and out put data records
   • allows 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 and to modify it
   • you can view your data in a form and you can also add record modify records and also delete records
   • when you move off the table the changes are automatically made to the table
   • note: be care full when deleting records