Data base
* The Data base definition: A database is a structured collection of data. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information.
* The record: A record is a collection of fields containing informations about one object.
* The primary key: The primary key has to consist of characteristics that cannot be duplicated by any other row.The primary key may consist of a single attribute or a multiple attributes in combination.
* The table: Its a store of data organised by rows and columns.
* The query: Queries offer the ability to retrieve and filter data, calculate summaries (totals), and update, move and delete records in bulk.
* The report: Reports organize and summarize data for viewing online or for printing. A detail report displays all of the selected records. You can include summary data such as totals, counts, and percentages in a detail report.
* The validation rules: A Validation rule is a criterion used in the process of data validation, carried out after the data has been encoded onto an input medium and involves a data vet or validation program.
* How to reduce entry errors? By checking everything after doing a work or task, for example try out your validation rule ( Dont forget the validation text which will help any user) Also the impute mask
* Data types : Text, number, Yes/No, currency...
No comments:
Post a Comment