• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  • Level: GCSE
  • Subject: ICT
  • Word count: 3309

Description of a database and it's features!

Extracts from this document...

Introduction

Description of a database and it's features! A database can become very helpful for many people, especially if the person has their own business or responsibilities to look after a lot of information, that they require to look at every now and then. By using a database, you can make it possible for yourself to search for various information quickly and easily. A database has to consist of many relations, so that all the information in the database can link together and be searched for easily. Data is arranged into various tables (preferably two or more), and as I have mentioned above, the data is linked together with the aid of relations. With a database various searches and reports can be produced based on the needs of the user. This is extremely flexible and can save space by avoiding duplication. Each table in a database is made up of fields and records. Fields have different formats depending on the type of data they store. Examples of various kinds of fields and their formats:- Type of data- text, category- Basic - Mixed letters and/or numbers, What is included in it- Up to 255 characters (letters and/or number codes). Number: -Integer- Whole numbers between -32,768 and +32,767 -Long Integer- Whole numbers between -2,147,483,648 and +2,147,483,647 -Byte- Whole positive numbers between 0 and 255 -Single- Any number (accurate to 7 significant figures) -Currency- Up to 15 figures before decimal place, 2 after - e.g. �1,234.56 -AutoNumber- Automatic counter - incremented by 1 for each record. Special: Date/Time- Both date & time - e.g. 25/12/98 16:25:08 -Yes/No True/False On/Off - For data with only 2 possible values - OLE Object- For pictures, sound, video, Word/Excel documents etc. -Hyperlink- For links to the Internet or e-mail. All of the information mentioned above is all about the different types of fields that can be used in databases. All of these fields above are found within tables and various tables can be linked together by the power of relation database. ...read more.

Middle

Then after that, I was ready to set up my tables. To create a table I firstly, clicked on the table's option at the top of the window, and then I clicked on "new." Once I clicked on new, a new window came up onto my screen, like the one shown in the diagram above. On this window I clicked on the option "design view" and then I clicked on OK After I had clicked on O.K on the previous window, a new window came onto my screen, which appears like the one above. In this section I entered all the details for the various fields that I was going to use in my first table. I firstly started by entering personal reference number as the choice of my first field. In the choices in the second window, which was located at the bottom of my screen, I selected the field size as integer and I made sure that I specified that this was "required." Finally I clicked on O.K at the bottom of the window. Then I entered the other field names, into my table according to the plan making sure that the planned types of fields, field sizes, etc. are entered. Then I created my primary key. In this case, with my first table my primary key was used on my personal reference number, which consisted of unique data in each record. Anyway, to create the primary key, all I did was click on the first row, where my personal reference number field was located, and then I selected edit and then primary key form the toolbars at the top. A soon as I did this a small gold key appeared on my screen next to my first field on the left-hand side. Then to finish my first table, I gave my table a name. From the table I chose the toolbar- file, and I clicked on the save as option. ...read more.

Conclusion

field names form the left hand box to the right hand box by clicking on the field names and then clicking on the arrows in the between the two boxes. I moved al the field names to the right hand box, apart from the Birthplace field name. I then clicked on the next button four times, until I was asked by layout. Once I was asked about layout, a number of windows appeared on my screen one after the other, asking me about the layout style, of my report. For example- if I wanted it laid out portrait or landscape, or what type of background I wanted on my report. After I had decided all the final lay out and appearance of my report, I then clicked on the finish option. Finally I gave my report a suitable name and clicked on the finish option. The name I kept for this particular report was:- Liverpool Chester report. Then my report from my Chester query appeared onto my screen, in the same lay out I had chose it to. Below is a screen shot of what my report looked like:- After this I created a report for all of my other queries and I then had finally completed all of my database. I did then consider adding in extension ideas into my database, but I really did not have enough time to add pictures to the players name or anything like that, because I did have to begin my next assignment which was to do with spread sheets, so I thought I would leave it for the time- being and perhaps get back to it later If I found the time to do so. Basically I think that I could have improved my database, If I had perhaps added some pictures to it and livened the whole atmosphere of t a little. Also I could have added some colours to my database, and then this way, my database would be a lot more brightened interesting. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. Reviewing different multimedia presentations.

    is any other business which needs a Multimedia Presentation at a high and professional standard doing for them in there business. There is hence no specific age target audience as it is just for a business man who needs a Multimedia Presentation doing for them.

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    is because you must type in the number of the row instead of the letter e.g. A would be 1, B would be 2 etc. However, if my cell range was from column G to J, then column G would be 1 etc.

  1. bookings database

    Output will be on screen Yes Screen Title:- "(Find a returning guest") Yes Surname (input) Yes Postcode (input) Yes Title (Dr., Mr., Mrs.) (output) Yes First name (output) Yes Address (output) Yes Guest number (output) Yes Desired outcomes (qualitative) 1.

  2. ICT BTEC UNIT 2 - REPORT

    Adobe Premier Pro has a very wide selection of editing tools of which you can create many special effects. Disadvantages for adobe premier pro it costs quite a lot �459.65 almost as much as a decent laptop. It takes up a large amount of your HDD space.

  1. Spreadsheet Report

    Now that everything was in order I decided to save my work by clicking on the floppy disk which was on the tool bar. A window appeared asking me where I wished to save my work. I selected my folder, renamed my file name and clicked save.

  2. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    The colour full graphics will be inserted form the Microsoft publisher application and also photo draw, the use of different texts and fonts will be done in Microsoft publisher application, by using these attractive images the customers will easily be attracted.

  1. Database analysis of 'a video lending library'.

    registers in a file rack, which will occupy more space in the shop than that of the space occupied by a computer. Many tables can be inserted in one database that suits the user requirements, and also store allot of data.

  2. Analyse - Database

    However, the database software package was not considered. Below, is a table of the software solution that have been considered. Furthermore, the advantages and disadvantages of each software package has been discussed. Database Software Package Advantages Disadvantages Excel - Display data in graphs and charts - Has neat tables -

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work