objects within a database

objects within a database

1. tables

   • to store the data

2. queries

   • answer questions about the data. can extract and display records which math a certain criteria
     • answer questions about the data
     • used to view, alter and analyse data from one or more tables in a database
     • used as the source of records in forms or reports
     • only the required data is displayed
     • saved for future use
   • criteria to make sure you get the data you want
     • maths operators
       • or, and, > greater than, < less than, between... and ...
     • wildcards
       • * matches any number of characters or more
       • ? matches exactly one character

3. reports

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

4. forms

   • used to input or output data in a user friendly way. on screen use
     • easily created using wizards
       • create a basic form, then modify it. using wizard
     • allow records to be presented in a user friendly way
     • text can be enhanced and additional text added
     • common buttons can be added
       • next/previous page
       • search
       • save
       • delete
     • edited using a form editor
   • using forms
     • when you move off the record. the changes are made automatically to the table
     • you are given a warning before you delete a record
     • view data
       • add/modify/delete records