1 / 21

Database Evidence

Database Evidence. Elena Rybka. Field Names. Entering Field Names. I entered all of the Field Names that were specified in the Data Item list provided on the Edexcel website . Data Types. Name of Species.

ardara
Download Presentation

Database Evidence

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Evidence Elena Rybka

  2. Field Names

  3. Entering Field Names • I entered all of the Field Names that were specified in the Data Item list provided on the Edexcel website

  4. Data Types

  5. Name of Species • I kept the Data Type for “Name of Species” as Text, because then this allows an unique text, in either numbers or letters, or a mixture of both • The primary key in this field also ensures that each entry is unique. • I changed the field size to 50 as this is the maximum amount that will be entered into this field. I changed the other properties to make sure that there would be no duplicates (e.g. Indexed Yes (No duplicates). • This ensures that each piece of data entered into this field will be individual.

  6. Testing my Validation Rule Group • The Look Up Wizard working in Datasheet View • I entered a Validation Rule so that only the values listed in the Validation rule (the same as in the drop down box) can be entered; I also changed my Validation text (the error message that appears when another value is entered). • I also changed the Field Size to 18, as this is the maximum characters in any of the options in the drop down list. • I entered a Lookup Wizard so that the options specified in the Data Item sheet would come up as options when entering data into the database

  7. Location • I kept the Data Type for “Name of Species” as Text, because then this allows an unique text, in either numbers or letters, or a mixture of both • I changed the field size to 30 as this is the maximum amount that will be entered into this field, as no location in the world is more than 30 characters

  8. Testing my Validation Rule Status • The Look Up Wizard working in Datasheet View • I entered a Lookup Wizard so that the options specified in the Data Item sheet would come up as options when entering data into the database • I entered a Validation Rule so that only the values listed in the Validation rule (the same as in the drop down box) can be entered; I also changed my Validation text (the error message that appears when another value is entered). • I also changed the Field Size to 4, as this is the maximum characters in any of the options in the drop down list.

  9. Testing my Validation Rule Threat • The Look Up Wizard working in Datasheet View • I entered a Lookup Wizard so that the options specified in the Data Item sheet would come up as options when entering data into the database • I entered a Validation Rule so that only the values listed in the Validation rule (the same as in the drop down box) can be entered; I also changed my Validation text (the error message that appears when another value is entered). • I also changed the Field Size to 1, as this is the maximum characters in any of the options in the drop down list.

  10. Weblink • I changed the Data Type for Weblink to “Hyperlink” as this allows me to enter the weblink into the field and then be able to click it and instantly access the webpage

  11. Adoption Cost • I changed the Data Type to “Currency” as in this field, prices will be entered, and this Data Type allows me to enter a price • I changed the decimal places to 2 as this is the number of decimal places in the UK currency

  12. Importing Data

  13. Take One • The first time I imported my data, not all of the records were imported. I only managed to import 104 out of 173 records. This means that I had to go back and change something to correct this. I changed the field size from 4 to 6, when I realised my mistake

  14. Take Two • I removed “Like” from all of my Validation Rules to ensure that my Validation Rules would work properly

  15. Take Three • I changed the spelling of “Amphibian” in my Validation Rule, and this meant that all of the data was imported successfully, resulting in 173 records

  16. Data Entry Form

  17. Data Entry Form • I created a data entry form where data can be viewed and new data can be entered, and also can be easily navigated, using the buttons provided

  18. Entering New Records

  19. Baboon • I researched the baboon and added it into my database as a new record • This is the website that I used to gain my information from • This is the information I used to tell me that they were “Endangered” and that the threat was “Humans”

  20. White Rhinoceros • I researched the white rhinoceros and added it into my database as a new record • This is the website that I used to gain my information from • This is the information I used to tell me that they were “Endangered” and that the threat was “Humans”

  21. Arctic Fox • I researched Arctic Fox and added into my database as a new record • This is the website that I used to gain my information from • This is the information I used to tell me that they were “At Risk” and that the threat was “Loss of Habitat”

More Related