Labels

ICT (23) Theory (17) Practical (6) Software (6) Paper1 (5) Access (4) Components (4) Hardware (4) Paper 2 (4) Syllabus (4) Learning (3) Paper3 (3) Link (2) Database (1) Excel (1) Facebook (1) Interface (1) Powerpoint (1) Storage Devices (1) Twitter (1)

Thursday, March 17, 2011

Database Tables

A table is cut down by a query with criteria which is outputed as a report with a title. Eg;

Table > (query/criteria) > report


The table is full of info, when you search a query, it cross checks all info in the table with criteria. For example:

A table of everyone's ages, houses, addresses, and names. If you made a query with the criteria of 16 and in Remuera, you'd get everyone matching both of those. Should someone be 16 and live in Parnell, they would not be included. After the query has been made, this is taken and made 'prettier' by putting it into a report.

No comments:

Post a Comment