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 7.Evaluate my work.
Brainstorm Supermarket items Party invites Sports club Hotel Guests Ice cream shop Restaurant Cafe Family Reunion Wedding guest lists Camp site bookings Shoe shop items Family barbeque Pet shop
Here is my actual database that I created
Here are some queries that I carried out
For this query below I did all the cats that are 15 years old and have blue eyes.
For this query below I did all the cats that were 15 years old and were 25kgs.
For this query below I did the cats eye colour.
For this query I did all the cats that have ginger fur and green eyes.
And for this query below I did all the cats that have grey fur.
For this query I did whether the cats had black or grey fur and had blue eyes
Here are some of my reports
Here is a form that I made To create a form you 1. Go to your database 2. Click on Create 3. Then click on Form Wizard 4. Then choose the fields that you want in your form and click the right arrow to add them then click next 5. Then choose the layout of your form, then click next. 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. 7. Choose the one that says Open the form to view or enter the information, and then click finish.
To create a lookup Wizard you 1. Go to your database and click on design view 2. Click the down arrow on one of the categories under data type and click Lookup Wizard 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. 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. 5. Next click on the field that you want to look at and then click on the right arrow then click next. 6. If you would like to sort your fields you can otherwise click on next. 7. It will then show you how the field is going to look, then click next. 8. If you want to change the name of the field you can otherwise click on finish. 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. 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.
Evaluation 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.
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
7.Evaluate my work.
Brainstorm
Supermarket items
Party invites
Sports club
Hotel Guests
Ice cream shop
Restaurant
Cafe
Family Reunion
Wedding guest lists
Camp site bookings
Shoe shop items
Family barbeque
Pet shop
Here is my actual database that I created
Here are some queries that I carried out
For this query below I did all the cats that are 15 years old and have blue eyes.
For this query below I did all the cats that were 15 years old and were 25kgs.
For this query below I did the cats eye colour.
For this query I did all the cats that have ginger fur and green eyes.
And for this query below I did all the cats that have grey fur.
For this query I did whether the cats had black or grey fur and had blue eyes
Here are some of my reports
Here is a form that I made
To create a form you
1. Go to your database
2. Click on Create
3. Then click on Form Wizard
4. Then choose the fields that you want in your form and click the right arrow to add them then click next
5. Then choose the layout of your form, then click next.
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.
7. Choose the one that says Open the form to view or enter the information, and then click finish.
To create a lookup Wizard you
1. Go to your database and click on design view
2. Click the down arrow on one of the categories under data type and click Lookup Wizard
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.
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.
5. Next click on the field that you want to look at and then click on the right arrow then click next.
6. If you would like to sort your fields you can otherwise click on next.
7. It will then show you how the field is going to look, then click next.
8. If you want to change the name of the field you can otherwise click on finish.
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.
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.
Evaluation
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.