Objects within a database

Objects within a database

1. Tables

   • Store the data itself

2. Reports

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

3. Queries

   • Used to answer questions about the data. can extract and display records which match certain criteria
   • Questions about data
   • Used to view, alter and analyse data from one or more tables in a database
   • Source of records in forms or reports
   • only the required data is displayed
   • Can be saved for future use
   • Wildcard symbols
     • ?Matches exactly one character
     • *matches any number of characters of none
   • Maths operator
     • <less than
     • >greater than
     • between...and...(can be numbers or dates
     • Or

4. forms

   • Used to input and/or output data in a user friendly way-for on-screen usey
     • Allows records to be presented in a user friendly way
     • Can be used with input and output data records
     • Allows command buttons to be added
   • the best approach is to create a basic form using wizard. Then modify it.
   • Using forms
     • add records
     • Modify records
     • Delete records
     • Changes are automatically mad in table.