A database is a collection of data items that are used in different places such as schools and supermarkets. It is used to find a selection of things like for example question; how many girls are in school? or how much money does one person spend daily at the supermarket for carrots? Even if it may sound absurd it can be found. Also for instance, principals and teachers use this to find students who are present, sick or truant. You can view a database two ways, design and table. The information that are used in each entry are called records, the main purpose of a database is to keep you updated on significant information about things that happen in your life, if you just happen to find the information that you are looking for it's important to make a report. Most who want to know the buying habits of the customers, or where to send the bill to. Utility companies for example need records which means creating a database from which they can manage accounts. Supermarkets collect information (that's what clubcards are all about) about what their customers are buying so that they can target them with offers and to work out what sells and what doesn't.They all use them with one motive - to make money by increasing the efficiency of their businesses.To add or delete fields, right click and stroll down to delete field. Click it.
Brief:
Our learning intention is to make a database about a theme/topic that we have selected.It must be simple and easy to read. It may be about a small business or a random topic.
Planning:
1. Brainstorm topic. [10 mins]
2. Pick a topic/subject. [5 mins]
3. Research your topic.[45 mins]
4. Draft out your idea. [60 mins]
5. Edit, to see if you have made any mistakes. [30 mins]
6. Final product. [25 mins]
7. Edit once more. [5 mins]
8. Put on wikispaces. [2 mins]
9. Peer evaluation. [3 mins]
10. Make changes if needed. [15 mins]
Brainstorm of themes.
Wedding guest list.
Family reunion.
Stock items.
Brand names.
Bithday invites.
A census.
Sports membership.
The theme I have chosen:
My theme that I have decided to do is going to be Kaylene's Wedding To James Cheal. Also, Kaylene's guest list to her wedding.
Query:
I made this query using Microsoft Access, than I made simple cell, I started by making names than made records by right clicking the mouth and went down rename. I named it name and gender for the other. I wrote the names down and tried my hardest to make it look the way I wanted it to. Queries are used to search for certain information, like for a table for instance these are the names of all the male and theyre gender.
Form:
We use this when we want to fill something out. I made this using Microsoft Access.
I made a query went and pressed create, looked for form and it made that.
I like this layout, so I kept it like this.
Reports
We use reports, it shows the time and date it was made on.
First, I used the table, pressed on create and than went on report and it made this.
I kept it like this because I just like this lay out.
Look-Up Wizard.
In Microsoft Access, you can add a field to a table to look up information in another table. You typically use this technique when you want to create relationships between tables. For example, perhaps you have a Products table with a Category field that looks up the category name from a Categories table.By using this technique, you can store the primary key value only in the Categories table, but display the more useful Category name.
Input Form.
An input mask helps to prevent users from inputting invalid data in an Access 2007 form or report. To make your own I followed the steps.
1. Open the form in Design View.
2. Right-click the field you want to modify.
3. Choose Properties from the pop-up menu.
Evaluation.
I didnt put up all the queries because it didnt look right but I enjoyed doing the guest list.
I liked that I learnt alot about this and I hope next time I will be able to do a better job.
By Me.
Partner Evaluation.
Your page is very good, its is very well presented and it doesn't need any work Kaylene :)
The introduction:
A database is a collection of data items that are used in different places such as schools and supermarkets. It is used to find a selection of things like for example question; how many girls are in school? or how much money does one person spend daily at the supermarket for carrots? Even if it may sound absurd it can be found. Also for instance, principals and teachers use this to find students who are present, sick or truant. You can view a database two ways, design and table. The information that are used in each entry are called records, the main purpose of a database is to keep you updated on significant information about things that happen in your life, if you just happen to find the information that you are looking for it's important to make a report. Most who want to know the buying habits of the customers, or where to send the bill to. Utility companies for example need records which means creating a database from which they can manage accounts. Supermarkets collect information (that's what clubcards are all about) about what their customers are buying so that they can target them with offers and to work out what sells and what doesn't.They all use them with one motive - to make money by increasing the efficiency of their businesses.To add or delete fields, right click and stroll down to delete field. Click it.Brief:
Our learning intention is to make a database about a theme/topic that we have selected.It must be simple and easy to read. It may be about a small business or a random topic.Planning:
1. Brainstorm topic. [10 mins]
2. Pick a topic/subject. [5 mins]
3. Research your topic.[45 mins]
4. Draft out your idea. [60 mins]
5. Edit, to see if you have made any mistakes. [30 mins]
6. Final product. [25 mins]
7. Edit once more. [5 mins]
8. Put on wikispaces. [2 mins]
9. Peer evaluation. [3 mins]
10. Make changes if needed. [15 mins]
Brainstorm of themes.
Wedding guest list.
Family reunion.
Stock items.
Brand names.
Bithday invites.
A census.
Sports membership.
The theme I have chosen:
My theme that I have decided to do is going to be Kaylene's Wedding To James Cheal. Also, Kaylene's guest list to her wedding.
Query:
I made this query using Microsoft Access, than I made simple cell, I started by making names than made records by right clicking the mouth and went down rename. I named it name and gender for the other. I wrote the names down and tried my hardest to make it look the way I wanted it to. Queries are used to search for certain information, like for a table for instance these are the names of all the male and theyre gender.
Form:
We use this when we want to fill something out. I made this using Microsoft Access.
I made a query went and pressed create, looked for form and it made that.
I like this layout, so I kept it like this.
Reports
We use reports, it shows the time and date it was made on.
First, I used the table, pressed on create and than went on report and it made this.
I kept it like this because I just like this lay out.
Look-Up Wizard.
In Microsoft Access, you can add a field to a table to look up information in another table. You typically use this technique when you want to create relationships between tables. For example, perhaps you have a Products table with a Category field that looks up the category name from a Categories table.By using this technique, you can store the primary key value only in the Categories table, but display the more useful Category name.
Input Form.
An input mask helps to prevent users from inputting invalid data in an Access 2007 form or report. To make your own I followed the steps.
1. Open the form in Design View.
2. Right-click the field you want to modify.
3. Choose Properties from the pop-up menu.
Evaluation.
I didnt put up all the queries because it didnt look right but I enjoyed doing the guest list.
I liked that I learnt alot about this and I hope next time I will be able to do a better job.
By Me.
Partner Evaluation.
Your page is very good, its is very well presented and it doesn't need any work Kaylene :)