objects within a database

objects within a database

1. forms

   • Easily created by 'Wizard'
   • forms can be used to both input and output data records
   • Allow records to be presented in a user friendly way
   • Text can be enhanced and additional text added
   • Can be edited using a form editor
   • Allow command buttons to be added
   • create basic form using wizard
   • Modify it as needed
   • add records
     • modify records
       • delete records
   • when you move off the record the changes are made automatically to table

2. Tables

   • store the data itself

3. Queries

   • used to answer questions about the data. can extract and display records
   • queries answer questions about your data
   • only the required data is displayed
   • can be saved for future use
   • used to view ,alter and analyse data from one or more tables in a database
   • Wildcards - matches any number or characters or none
   • maths operators
     • >(greater than) <(less than)
     • or / and

4. reports