Objects within a database

Objects within a database

1. Tables

   • Store the data itself

2. Queries

   • Used to answer questions about the data can extract and display records which match a certain criteria
   • 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 source of records in forms or reports
   • Only the required dataa is displayed
   • Can be saved for future use
   • Criteria
     • Wildcards,symbols and maths operaters can be used
       • Example:or, and < > (greater than and les than)
       • wildcards
         • Matches any number of characters or none
         • matches exactly one character
     • Critera can be combined eg. >25<50

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 or output data in a user friendly way-for on screen use
   • why use forms?
     • Easily created using wizards
     • can be used for both input and output
     • Allows records to be presented in a user friendly way
     • text can be enhanced and additional text can be added
     • Allow command buttons to be added
     • can be edited using a form editor
   • The best approach is to
     • Create the basic form using the wizard then modify it as needed
   • using forms
     • You can view your data in a form
       • Add records
       • Modify records
       • delete records
     • When you move off the record the changes are made automatically to the table