Databases (Microsoft Access)
DB → File(s) → Records → Fields
A Field contains one item of data
A record contains data about one person or thing
A key field is a unique identifier to the record
Validation
This is the checking of data by software processing on input.
This ensures the data is sensible
It Prevents GIGO- Garbage In Garbage out.
Examples of Validation are:
Presence Check- Forces data to be entered e.g. required field.
Range Check- Checks that the data entered is within the required range. E.g. with 1:9 only 1,2,3,4,5,6,7,8,9 are acceptable.
An Idiot’s guide to Microsoft Access
Tables
- To set up a table:
Open Microsoft Access and click on Tables, Then create table in Design View.
Type in your fields under fieldname.
This is a preview of the whole essay
Peer Reviews
Here's what a star student thought of this essay
Quality of writing
The report's presention is quite poor, the text size is too large and this should be reduced to ethier 12 or below. The starting text states 'A Field', although the second line states 'A record'. The first is using two capitals and the second is one at the start. This error needs to be correct, to ensure it's in a presentable format. The guide, starts with the bullet point ')1', however after this there isn't any further bullet points. This is very messy and looks unprofessional.
Level of analysis
The report gives a vague definition of what database validation is, and this could be improve by using an in-depth paragraph. The student has written a good step-to-step guide on how to use a database when read correctly, as there is currently no numbers to tell if it's instruction 1 or 8.
Response to question
The report, overall is quite unprofessional. I couldn't see this database guide used in any commercial environment, as this wouldn't be acceptable. However the content (if brushed up a little) is quite good. The student has worded the database guide as 'An Idsiot's guide', which can be offence. Within an commercial environment, this wouldn't be written in this way. The title should be removed and re-placed with something on the lines of 'Database User Guide'.