Coursework.Info - Inspiration in an Instant

On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:

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 1) To set up a table: Open Microsoft Access and click on Tables, Then create table in Design View. Type in your fields under fieldname. Find a key field. This field must be totally unique to every entry. When you have found it, click on the field and then on the key icon in the top toolbar. Choose the Data type from what type of data...

Get instant access

• Instant, unlimited access to our documents in full
• Swap your work for free access, or pay £4.99
• To see the full version of this document and 146,871 others

OR

Receive email updates for this category

• Simply tell us your email address and receive a weekly Study Help Email for FREE
• Receive 3 FREE essay views with each email
• Get all the latest essays from Coursework.Info & discussion from TheStudentRoom.co.uk