objects within a database

objects within a database

1. queries

   • Used to answer questions about the data. Can extract and display records which match certain criteria
   • can be used as a source if records in forms or reports
   • Can be used to view alter and analyse
     • Maths operators can also be used: >25 and <50 will search for numbers between.
   • Queries answer questions about your data
     • Wildcards can be used: * matches any number or character of more.

2. Reports

   • Used to format output of data

3. Tables

   • Stores the data itself

4. Form

   • used to input and and/or output data in a user friendly way- for on screen use.
   • Easily created using "wizards". Forms can be used to both input and output data records
     • When you move off the record the changes are made automatically to the table.
   • Allow records to be presented in a user friendly way. Text can be enhanced and additional text added. Allow command buttons to be added.
     • You can view your data in a form and you can also: add, modify and delete records.
   • The best approach is to create a basic form using wizard, and then modify it.