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

database project

Extracts from this document...

Introduction

The aim of this task ,is to improve the existing system that southall illustration use, which is paper- based system that use to produce invoices and tracking customer's orders, and all financial information by the introducing a database system . I need to justify the use of a database system by comparing Access with at least one other package such as; Excel. Excel can be used as a database but it has severe limitations. In Access, southall illustration can do complex searches called Queries, produce quality Reports and suitable data entry forms. The company can also improve the database by making it relational. Excel is more suited to performing calculations functions. A relational database application such as Access is better than Excel because it can mean the employee can spend less time on data entry and fewer errors. Access saves files in MDB (Microsoft Database) format. It compresses all your tables, forms, queries and reports into a single file. Sometimes it will be enough for southall illustration employee to see information on the screen but, on other occasion, they may need a printed report. Complicated queries such as a duplicates query so they can produce a graph of how many customers etc there were in the total database - much easier in Access because there's a wizard for it. ...read more.

Middle

* Data can be moved easily into other applications e.g. a mail merged letter so the company could save time in managing their business. * More than one computer can access the data at the same time that could save time for employee to do their work. * It is easy to add/change information. Southall illustration make use of the database system to store the detail of customers, employee, design templates, invoice and order details, I had produced five tables and entered different types of information. How did I design the Tables? * I Select Tables in the Object bar The purpose of each table in my database design Customers detail table - this will hold details such as the name and address of existing customers Design table - this will hold details such as the design Id, font and the colour of the design templates Employee table - this will hold details such as the employee firs name, last name, DOB, address and so on Invoice table this will hold details such as the invoice Id, order date, quantity, ship name, and ship address Order table -this will hold details such as the customer Id, invoice Id, design Id, employee Id, quantity and unit price Relationship Relationships used ...read more.

Conclusion

* Click on the Reports button and then double-click on Create report by using wizard. * The next Report Wizard Box appears. * The next Report Wizard box appears, that will allow you to sort your report * Then chose the style you like to appear in your report Southall Illustration invoice Report Southall illustration invoice query Report Data dictionary Customer table Design table Employee table Invoice table Order table Test plan Testing is the process of checking all the function of the system work as planned and gives correct result. The main reason for test plan is to produce a test plan that would enable someone who knows nothing about the system to be able to test it thoroughly. Test No. Test /Data Reason for the test Expected Result Errors and problem 1 Validation 0905/07 Test validation rule on Employee Id field Rejected and error message to appear N/A 2 Report Examine the logo reports 0905/07 To check picture appears correctly The logo appears on both reports N/A 3 Queries Customer ID query 0905/07 To check that query works The customers Id are displayed N/A 4 Tables 0905/07 To check if the entries in data type were entered correctly all the entries are correct N/A Validation Test validation rule on Employee Id field Report Examine the logo reports Queries To check that query works ...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. Analysis section for database project based on a hotel booking system

    program for the design of this logo Reusability of relational database: E.G. Another great advantage of using a relational database is the because of it ability to be reused. For example, there is the ability to modify and update for example, a customer's address of phone number if it is changed.

  2. The aim of my project is to make the task of the allocation of ...

    In the event that the user wants to change the data in the situation of a change in cost to put on a show, or some other change in price or projected profit, the user can easily switch off the cell protection, edit the data, and then switch cell protection back on.

  1. Database design for a games shop.

    should print 18 Games by genre field runs accordingly and is clear Check the form All fields included, English is clear 19 Date rented on rentals sheet is set on current date Customer verification form, date should be today Today's date 20 Long game titles are accepted Enter qwertyuiop Asdfghjkl12345

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

    Once I had selected my specific range I clicked the square icon again, to maximise the box on the screen. In the criteria box, I typed in what I wanted it to count, in this case I wanted it to count all the percentage which were greater than or equal to 70%, so I typed in ">=70%" and pressed ok.

  1. bookings database

    3. Easy to enter the names to be searched- when you click on the 'Find Guest details', a parameter box appears which clearly says 'Enter surname or part of it'. It is efficient for the user as it will save time instead of typing the full name they can enter part of it.

  2. ICT BTEC UNIT 2 - REPORT

    Another feature in vista ultimate is parent control it can be used to deny young children to certain programs. Disadvantages are its requirements are at high rate and consume a lot of hard drive space. Vista ultimate is very expensive and the price rises depending on what country your in.

  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. Powerpoint review project

    The software includes functions for creating various types of charts and graphs and for inserting text in a variety of fonts. Most systems enable you to import data from a spreadsheet application to create the charts and graphs. This mainly includes pictures and colours to make a slideshow interesting.

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