Part p5 and m3

Select Query ( Part of p5)

p5 and p6

Data Dictionary

D1

There are several errors that can occur when using databases. This includes accidental deletion of fields. This could be time consuming if you do delete fields. You can overcome this problem by backing up, this allows important data to be restored. You can set this to automatically back up every 5-10 minutes. Another way to overcome this is save your documents in two places. So for instance save it on your computer and on an email or a memory stick. 

Another error is the incorrect data type. A way you can decrease this is by doing multiple choice questions. This allows the data to be entered faster and makes it easier to complete a data form. 

Another error is validation. This can make sure that the information put into the database is correct. You can put these in place in the design stage. There are several validation rules these include range checks, present checks, input masks, list checks and format check. 

The final error i'm going to discuss is null values. Null values are shown when data isn't entered into the field when there is a present check in place. This would bring up an error message. 

Form print screens p4 and p6

d1

There are several errors that can occur when using databases. This includes accidental deletion of fields. This could be time consuming if you do delete fields. You can overcome this problem by backing up, this allows important data to be restored. You can set this to automatically back up every 5-10 minutes. Another way to overcome this is save your documents in two places. So for instance save it on your computer and on an email or a memory stick. 

Another error is the incorrect data type. A way you can decrease this is by doing multiple choice questions. This allows the data to be entered faster and makes it easier to complete a data form.

Another error is validation. This can make sure that the information put into the database is correct. You can put these in place in the design stage. There are several validation rules these include range checks, present checks, input masks, list checks and format check.

The final error i'm going to discuss is null values. Null values are shown when data isn't entered into the field when there is a present check in place. This would bring up an error message. 

p2