• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Database - In this report I plan to type out all the information, which I had researched. This will include the video tables, membership table and the loans table. The information I will use in the video table is video number, video title,

Extracts from this document...


Database Report. Introduction: A database is a collection of related data items, which are structured and linked so that the data can be accessed in a number of ways. The function of a database is to hold information on a computer. Often the information stored is very large and it would take a long time for us to search through if it was written on paper. Holding the information in a database enables us to search very quickly and to sort the information easily. All this information is for my video store. Planning: In this report I plan to type out all the information, which I had researched. This will include the video tables, membership table and the loans table. The information I will use in the video table is video number, video title, The information I will use in the membership table is the membership number, surname, forename, address, postcode, gender, age, telephone number, mobile number, e-mail, and fax. The information I will use in the loans table is loans ID, membership number, video number, date out, date due and returned. I will also be creating the database table, when creating a new database, I will first have to list all the fields needed (above). For each field decide what type of data it will be, for example age will be a number field. I will also have to be careful with some fields that appear to be numeric fields but are actually text fields, telephones fall into this category. ...read more.


You could also choose a secondary field to sort which could be the forename in case there where other people with the same surname. You would then decide whether the data should be in ascending order (a-z) or in a descending order (z-a). When you do a sort the numbers will come before letters and depending on the database lower case letters will come before upper case letters. I will also be describing searching, which is when you are able to retrieve information from a database, particularly from a large database. The computer taking the users request and searching for a match in the database does this. I will show all the steps used in the method. I will also do a validation. Method: Results: I had two options in sorting my database. The first was by the doing a membership report that was accessed by accessing Microsoft Access and then a new menue came up with a scroll on the left hand side. You then scroll down to an option labelled report, then on the right it will have two options the first saying and the second saying "create by using wizard". Next a new menue will appear and it will ask you what type of report you would like. You have a choice of doing a membership report, video report and a loans report. I will do the membership report which you then have to transfer all the information onto the other side by clicking ...read more.


a window will appear, from the tables/queries bar at the top select either the membership table, video table or loans table, from this selection the available fields will appear underneath the tables/queries menu. You then transfer all the available fields across to the left side of the screen. Select next, On the next screen I had to click on detail, next I had to save my work as, either video table, membership table or loans table query. Here are my video table queries below: Video table query. Membership table query: Loans table query: Evaluation: My Database includes all of the users need's, such as the videos that have been loaned and the return by date. Improvements I can make are to make my Cell's better formatted and make it show all the information needed, and all the information needed for the video store manager to examine customers choice in rental movies. To keep my work safe I will save it on to a floppy disk and it will be kept safe from any damage, I will also save my work to my user name, which requires a password. My self and my teacher only know this password, so if there are any errors either my teacher or I can correct them. I will also check for simple spelling or grammar mistakes by using the grammar or spell check functions. I could also have extra passwords for better safety precautions. These will be added on to the computer and my floppy disk. Zuber Din Mir T079648 Leytonstone School 13411 1 ...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. Testing database. Test plan 1 I am going to check my data restriction. ...

    I would be testing the result I get if they are correct or not Testing 7 In this screen shot I have opened my price query. I have highlighted my criteria as these criteria would display the product which comes in this price range.

  2. Reviewing different multimedia presentations.

    filling in body parts in the right place so you are having to be involved in the Multimedia Presentation. ELEMENT: YOUR COMMENTS: Use of images in the product In this Multimedia Presentation there is a lot of image used as the whole Multimedia Presentation works around the fact of putting

  1. Appropriate Software To do this project I am going to use excel because ...

    Sales will be the main thing that will be entered, however should they choose to add a new product to their range or encounter an increase in overhead costs such as Gas bills then it will have to be added.

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

    each results table, she can just click the name she wants from the drop down menu and the VLookUp table will show student percentages, achieved grades and merits. Additionally, the VLookup table is more reliable, as it will show all the correct data a child has received, but if the

  1. ICT - Software Review Table

    Advantages * Enables you to improve alter colours. * Change backgrounds. Disadvantages * Takes a while to get used to it. * A legal license for Photoshop is very expensive. Contrast and compare chosen device to alternative Software type: Drawing Package.

  2. bookings database

    Easy to input data-the arrival date is automatically generated (today's date). If you want to change this, all the user has to do is to delete it. The textboxes are empty so it is easily apparent that this is where the user enters data.

  1. Website Report

    ACCESSORIES PAGE This page displays a selection of mobile phone accessories on sale. The page is simple but still gives all the information needed. Clicking on the pictures brings up an option to buy the products on-line. The page also includes a back button, for an easy return to the main page.

  2. Logo Report

    There are many pre-made templates there for you to alter slightly or for you to add a few of your own ideas. I have chosen to use Macromedia Fireworks to create my logo, mostly because it is the easiest software to use and still make professional looking logos.

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