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

Creating a Database Coursework

Extracts from this document...

Introduction

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.

Middle

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.

Conclusion

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. Database design for a games shop.

    input forms for each of the tables * relationships between table * rentals, members and games table includes adding information * overdue rentals query * password for security reasons * query sourced overdue rentals contact sheet report * customer search wildcard parameter query * mail merged letter sourced from the

  2. What is a computer registry?

    file Use Windows Script Host The Windows Script Host lets you run VBScript and JScript scripts directly in the operating system. You can create VBScript and JScript files that use Windows Script Host methods to delete, to read, and to write registry keys and values.

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

    The reason I decided to add a filter into my spreadsheet, was so that the teacher was easily able to see which students needed help in particular subjects, as it allows the teacher to filter particular subjects and know which students need help in that area.

  2. Information and Communical technology

    * Monitor * Printer * Form view * Design view * Report * Datasheet view How will I store and back up the data? Data from the company will be stored in a hard drive. To make sure that the data will not be lost, a magnetic tape will be used to make sure that no data has been lost.

  1. bookings database

    The font is bold and has a larger font than the other command button. This is effective for the user because this command button is the most frequently used by the user. As it bold and centred, the user will automatically see this command button first.

  2. Spreadsheet for a basketball company

    Compute the remaining stocks whenever the items of the income increase. This must be shown in both the expenditure and the income page. 2. Analyse 2.1. Hardware The hardware required is a computer, a mouse, and a keyboard. The operating system used is Windows XP to run the necessary application software for viewing and editing the spreadsheet.

  1. Project 1b; Film Database

    I made some mistakes in my database that I which to correct now. I will mark these mistakes on the following paper with these ovals: I made three mistakes, which I will need to correct. The screen print on the following page shows the corrected table.

  2. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    * Should calculate the profit and loss of the company. * Will notify any mistyped data on the system. This will be accomplished by using validation checks. * Retrieve data rapidly TASK C: Spreadsheet coursework page 2 * Clear and simple instructions for both beginners and advanced users.

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