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

Description of a database and it's features!

Extracts from this document...


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.


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.


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


    Resolution = 1024*768 RAM = 512 Mb In First Page version 3 final its got full support from many advanced technologies such as HTML and Java Script and more much like adobe Dreamweaver and one of the great advantages to First Page is that its free to download.

  2. Documentation of a database for a sports centre.

    "0" is not known as a number in the world of databases. Finally, primary key is used in the table design to uniquely identify each record in the table. So for this situation, the member number will be a primary key in the table as it gives every member a unique number to be identified by.

  1. Evaluating a relational database solution

    Macros > These let me open a new form for example, automatically. I also used these with buttons to refer from records to welcome pages. Table View > I could view all of the information inputted clearly and in the form of a table with columns.

  2. Setting up a database in microsoft access.

    I then selected 'Record Navigation' out of the categories. I then chose what the button would do when I clicked it, I could make the button 'got to next', 'previous', 'last', 'first' record depending on which one I selected in the 'Actions' section. I then clicked 'Next' where I could then name the button if I wanted to, and then I clicked 'Finish'.

  1. Selecting the best software for a theatre business.

    Can be used to calculate the overall performance of the shares. I am planning to use graphs and charts to show data, conditional formatting and absolute cell reference. Quantitative Objectives Excel is a program that will help, it will be able to: � It is easier to look at and understand (clearly set out)

  2. A new IT system in a Dubai Marauders Rugby Football Club

    be Updated Easily Microsoft Excel TASK 1 - Club Logo / Letterhead The club needs a logo and a letterhead that will appear on printouts that will be seen by members of the public and on letters. The club already has a logo, which I could scan and save it on the computer.

  1. Database design for a games shop.

    This report can be printed out if necessary. * Customers detail search: in this report it contains information about each specific member which can be easily accessed by Mr. Walcott Field name Data type description Membership id Auto number Unique primary key Title Text Title if member First name Text

  2. Spreadsheet Report

    I will know the quantity of columns and rows to use, the type of formulas that I will use, what my graphs will be showing, etc. By having my spreadsheet planed out I will save time in the long period while producing my spreadsheet.

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