Digging+Data

Digging Data

Introduction During computing class we have been learning about and working on databases. A database is a collection of data items that are used for things like schools, supermarkets, addresses of places, information about people and so on. Lots of schools use databases so that they can store information about every student in the school such as their name,age, ID etc. Supermarkets use databases so that they can store information about what products they have in the store such as meat, canned food, milk, etc. The information for each entry on a database is called a record. The two views that can be used are called design view and table view which you can use for viewing your information. The purpose of keeping a database is so that someone can find information about a person, place or product easily to find out the information that is needed. When the information is searched for and found you can make a report to show the information that you have found.

Describe difference between a table,query and report. A table is where you put the information that you need on your database. A query is something that you use to find information about a certain person, place or thing. A report is something that you use to show all the information that you have found out from your query.

Describe and demonstrate add, edit and delete records. To add a record you right click on the left side bar and then click on new record, to delete a record you do the same thing as adding a record but this time you click delete record and to edit a record you click on the field that you want to edit and then type the data.

Describe and demonstrate sort, search and filter records. To sort records you right click on the table and you click sort and it gives you the option to either sort it from A to Z or Z to A. To filter records you go up to the toolbar at the top and click on filter. To search records go up to the toolbar at the top and click on find.

Brief To design a database to record information for Information about cats then carry out queries and reports.

Plan 1.Learn how to use access 2.Brainstorm topics 3.Choose a topic 4.Create the database 5.Carry out queries and reports 6.Upload to wikispaces page <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">7.Evaluate my work.

<span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Brainstorm <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Supermarket items <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Party invites <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Sports club <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Hotel Guests <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Ice cream shop <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Restaurant <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Cafe <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Family Reunion <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Wedding guest lists <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Camp site bookings <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Shoe shop items <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Family barbeque <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Pet shop

<span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Here is my actual database that I created

<span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">

<span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Here are some queries that I carried out

<span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">For this query below I did all the cats that are 15 years old and have blue eyes. <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">

<span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">For this query below I did all the cats that were 15 years old and were 25kgs. <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">

<span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">For this query below I did the cats eye colour.

<span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">

<span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">For this query I did all the cats that have ginger fur and green eyes. <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">

<span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">And for this query below I did all the cats that have grey fur. <span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">

<span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">For this query I did whether the cats had black or grey fur and had blue eyes



<span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Here are some of my reports

<span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">

<span style="color: #0000ff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">







<span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">

<span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Here is a form that I made <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">To create a form you <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">1. Go to your database <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">2. Click on Create <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">3. Then click on Form Wizard <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">4. Then choose the fields that you want in your form and click the right arrow to add them then click next <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">5. Then choose the layout of your form, then click next. <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">6. Then if you want to change the name of your form you can otherwise underneath it will ask you if you want to modify or open the form. <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">7. Choose the one that says Open the form to view or enter the information, and then click finish.

<span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;"> <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">To create a lookup Wizard you <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">1. Go to your database and click on design view <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">2. Click the down arrow on one of the categories under data type and click Lookup Wizard <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">3. It will then come up with a box that gives you 2 options of how you want you're look up values to work, you want to choose the one that says "I want the lookup columns to look up the values in a table or query, then go next. <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">4. Then choose the table that you want the look up wizard to look at and make sure the view is on tables, then click next. <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">5. Next click on the field that you want to look at and then click on the right arrow then click next. <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">6. If you would like to sort your fields you can otherwise click on next. <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">7. It will then show you how the field is going to look, then click next. <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">8. If you want to change the name of the field you can otherwise click on finish. <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">9. It will then come up with a box that will tell you that you must save your table, click on yes to save it. <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">10. Then do a test record and click in the field and the drop down arrow will appear, click on that and choose the value that you want.

<span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">Evaluation <span style="color: #000bff; font-family: Arial,Helvetica,sans-serif; font-size: 120%;">I think I did ok with my database, I was able to make a decent database with information about cats and make my queries and reports for them. Although I had been away for two sessions I was able to catch up on the work that I had missed and carry on with what I needed to do I have learnt lots of skills on access such as how to make queries and reports and also how to do lookup wizards and forms as well. But overall I think that I am happy with what I created.