Lesson 3 – Objectives

1. Lesson 3 – Objectives Look at how at the different ways of adding data to a database. Learn how to import data into access Learn how to record research

2. Import • Import on computers means “to bring something that is in a different format into a program”. • For databases we can import something known as a comma delimited file • Sometimes known as a CSV file • “Comma separated values!”

3. CSV files A CSV file will look like this. Each row represents a single records and fields are separated by comma’s

4. How the CSV works Year of release Title ID Album Effort Rating Genre Track number Artist Title Duration

5. Want to type it? Clearly to type in this data would take a long time! We will use access’ import feature to do this for us.

6. Step 1 – Start import Go to External data then click on text file

7. Step 2- Select the CSV file You can get the file from http://dida.pwnict.co.uk/example%20work/database/Tracks.txt

8. Step 3 – Select append Make sure you select append and choose your table!!!!

9. Next and finish! Then just click next and finish!

10. Check the results Finally see if you have 214 records Check this in datasheet view

11. If it failed... • Check the following • Have you got your fields in the correct order • Are your validation rules correct • Are your field sizes correct? • You can find the field list here • http://dida.pwnict.co.uk/analysis/step1.html

12. Activity Import data into your database You can use this PowerPoint OR http://dida.pwnict.co.uk/analysis/step4.html

13. Using your form Make sure you research the tracks! Next task is to use your form to add two music tracks of your choice.

14. Recording research We are going to use a sources table to record your research. You can find a blank copy here http://dida.pwnict.co.uk/word%20docs/sourcesTable.doc

15. Adding some Metal! I want to add Iron maiden – Bring your daughter to the slaughter to the database. I found the details I need on amazon.co.uk

16. Needed information It clearly states release date and duration. However it was not released in 2006! NOT ALL INFORMTION IS ACCURATE!

17. Accuracy is important! Another search brought up the date 24th December 1990 on Wikipedia. Can we trust this source?

18. Finding more than one source To ensure the information we find is correct we should find MORE than once source. That way we know it is correct!

19. Sources table Item – What you have looked for

20. Sources table Where found – The FULL web address (URL) of where the research was found

21. Sources table P/S – Primary or secondary. If found on the web it is secondary

22. Sources table Permission required – If you copy a image / music then you need to get permission. If you just getting ideas or information then you do not need permission.

23. Sources table You only fill this in if you need permission

24. Sources table Description. – What have you found and why do you need it?

25. Sources table Produced by – Who made the source?

26. Sources table Editing – Have you edited the source?

27. Sources table Where used – Where did you use the source

28. Activity • Choose two music tracks to add to your database. • Find two sources for EACH track (so 4 in total) to find • The duration of the song • Year of release • Album title • Track number • Etc • Fill out the sources table and add the tracks to your database using your form.

29. Help for sources table http://dida.pwnict.co.uk/sourcesTable.html If you need extra help you can use the above website.