Recent Changes

For this query I did all the cats that have ginger fur and green eyes.
{Cats fur Colour and Eye Colour Query.jpg}
I did fur colourall the cats that have grey fur.
{Cats Fur Colour Query.jpg}
For this query I did whether the cats had black or grey fur and had blue eyes

{Cats Fur Colour and Eye Colour Report.jpg}
{Cats Fur Colour Report.jpg}
{Cats Age and Eye Colour Report.jpg}
{Cats Age and Weight Report.jpg}
Here is a form that I made
To create a form you

{Cats Database.jpg}
Here are some queries that I carried out
cats that are 15 years old and have blue eyes and weigh 25kgs.eyes.
{Cats Age and Eye Colour Query.jpg}
For this query below I did all the cats that were 15 years old and were 25kgs.

{Cats Database.jpg}
Here are some queries that I carried out
I did ageall the cats that have blue eyes and eye colourweigh 25kgs.
{Cats Age and Eye Colour Query.jpg}
I did ageall the cats that were 15 years old and weightwere 25kgs.
{Cats Age and Weight Query.jpg}
For this query below I did the cats eye colour.
{Cats Eye Colour Query.jpg}
I did Fur colourall the cats that have ginger fur and eye colourgreen eyes.
{Cats fur Colour and Eye Colour Query.jpg}
And for this query below I did fur colour

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.
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.

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
needed to do.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

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
to do. But overall I think that I am happy with what I created.

{Cats Fur Colour Report.jpg}
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.
{Cat's Database Form.jpg}
To create a lookup Wizard you
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.