In this module we have learned that information can be stored in a structured way in a database file. A file has collections of information about a particular person or thing called records. Records are made up of individual items of information called fields. You create a database by defining fields and field types in a new table. Forms present records in a graphical format to help data entry. Queries search for particular data in a database file. Reports display data in a format suitable for printing. Simple sorts arrange records in a particular order by arranging the contents of one field in ascending or descending order. Complex sorts are used to separate items that cannot be separated using a simple sort and sort on a second field. |
