• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 867

Creating a Database Coursework

Extracts from this document...


Contents Introduction 2 Inserting a Record 3 Deleting a Record 4 Changing a record 5 Creating a Simple Query 6 Introduction What is a database? A structured set of data held in a computer, esp. one that is accessible in various ways. A database is used to store organized information, so that we can manage and retrieve information. Typically a database is made up of many linked tables of rows and columns, each containing specific data (E.g. name, address, location, size, weight, dates).also, a field: each column represents a field, record: each row represents one record, table: collection records. What are the benefits of using a database in a company? Phones your way are currently using a Roller Deck system. A roller deck system is very UN reliable as it is a paper system therefore, it is easy to misplace and easily damageable. Also, a Roller Deck is also limited to a number of cards. ...read more.


Therefore, writing it out by hand will no longer be necessary. Inserting a Record Why would Phones Your Way need to be able to insert new records? Show a screen shot before inserting the record Show a screen shot after inserting the record Explain what you did to insert a new record Phones your way like another phones company will need to add or remove customer details. Phones your way needs customer details to keep track on the merchandise and payments made by the purchaser. Phones your way is an expanding company therefore new customers are very common. If Phones your way were unable to add new customers they will have to refer back to their old and un reliable manual system to add a new customer. Deleting a Record Why would Phones Your Way need to be able to delete a record? Show a screen shot before deleting the record Show a screen shot after deleting the record Explain what you did to delete a record Phones your way will on some occasion have to delete customer details. ...read more.


How would using a query help phones your way? Show a screen shot of your query in design view Show screen shot of your query results A Query is a collection of data such as; records in a database. The term may also be used to search a single file or collection of files such in a database. In addition to obtaining lists of records that match the search criteria, queries are useful to a database as it is good for counting items and summing amounts. Phones your way will benefit from queries as they are simple to use and very useful for the databases of customer recorders, for example, Phones your way have many customers in different regions. If Phones your way shop - for any reason would to be closed for the day Phones your way would only have to inform the customers in that region. A query will be beneficial in this situation as it will specify (narrow down) the address of customers in that area. ?? ?? ?? ?? Assessment Objective 5: Using a Business Database Hardeep SINGH Page 1 of 9 ...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. The aim of my project is to make the task of the allocation of ...

    spreadsheet I have evaluated your sheet and have been testing it and have found to be an extremely useful asset in helping the calculation of costs and profits from my theatre.

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

    As there is an upcoming rugby tournament and the club wants to create a barbarian rugby side. The search for all the players has already been done in task 2. The clubs wants to use the results of this query to send out personalised letters to each of the members.

  1. Database design for a games shop.

    He can print it out the report easily. After considering everything, I have chosen Microsoft database as a solution, simply because it is the most reliable and best option available to me. This will be my system. User requirements: After having a meeting with MR.

  2. Hire Shop - creating a database.

    I visited the local library, to see if they had a system like one I'm trying to make. Co-incidentally they did. They had a database that was like one we made before starting this GCSE project. It contained information on the book, like the title, the author and the publisher.

  1. Description of a database and it's features!

    I have included various facts in my second table all about the squad of the Liverpool football club team. I have included 11 different fields in my second table, and they all consist of a wide range of data types.

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

    I then clicked on one of the cells I wanted in the formula, inserted an addition sign and clicked on the cell I wanted to add to it, and pressed enter; this then added the two cells together, and displayed the result in the high-lighted cell.

  1. bookings database

    2. Easy to navigate to another task when finished- when you finish checking the details, there are two command buttons at the bottom of the form. This says 'Exit' and 'Add a new guest'. These are very big and apparent so these are effective for the user.

  2. Spreadsheet for a basketball company

    Conservation of time is augmented by Macros as this feature consents the users to navigate any worksheet in a click of a button. Drop down boxes will be very convenient for the receptionist in order to select the appropriate type of seat and graphs will make it easier to interpret the results from tables.

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