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

Designing a solution to make the day-to-day running of a yet-to-be opened antique store.

Extracts from this document...

Introduction

Daniel Byrne Coursework project design What am I designing? I am designing a solution to make the day-to-day running of a yet-to-be opened antique store. This system needs to cater for the specific requirements, which the store will generate. In order to outline the solution I need to design I visited a existing antique store to find out what problems may arise and discover anything I may have over-looked. Q: Your store seems to be very old fashioned in the way it is run, why don't you update your methods of running the business? We have always been a family business and a fairly small store in comparison to others out there which means the implementing a computer solution to our problem may not significantly improve efficiency or save enough money to justify its implementation. However I do see the potential in implementing an ICT solution in a store from the word go. The store will need the implementation of a store site promoting the store and to allow users to search for items. What software will I use? There are two program classes suitable for the project I am working on. These include databases and spreadsheets. The features, which my ICT solution for the antique store requires, the efficient use of the features a database lets you develop. ...read more.

Middle

Payment method From drop down list of payment methods Sale price Currency. Price sold for and database automatic generation of date/time and revenue generated. Number of products Number. Amount of copies of the item is purchased. (if in set it can only be purchased as a set) Employer hadling Name of employer handling the purchase. Quantity The number of objects purchased (relating to the specific item not multiple items). Example: 5 copies of a antique clock purchased at once. 'Add return' Data input Item selection Text from drop down menu Number of items returned Number. Relates only to the copies of the item selected, not to multiple items. Total would be added. Reason for return Text. Description of reason returned. Returner Name of the person returning the item from drop down menu. All data will be inputted via a form layout on the switchboard and updated to the database automatically. Step one: Creating the database The database is to be designed using Microsoft Access due to the reasons listed further up in this document. To create a database you simply start up Microsoft Access and press Ctrl+N. From the control panel select 'create table by entering data' and the database will load for you to begin editing. ...read more.

Conclusion

I plan to allow those on our page to search the item database for items they may be interested in purchasing. I don't plan on allowing the item to be purchased from the store site due to the nature of how a antique store works but I will cover the basics on how you could implement such a system here. 1. The first step involves implementing a basic page or site. This can be done in basic editors if you lack the coding knowledge to do this yourself. You should approach this step with a plan of what fields you will want the sure to search and the formulae you may use. Example of a simple search form. This form field would be placed at any position on your page and direct towards the database you want. I plan to allow those on our page to search the item database for items they may be interested in purchasing. I don't plan on allowing the item to be purchased from the store site due to the nature of how a antique store works but I will cover the basics on how you could implement such a system here. Results page A results page will be generated from the parametor's set by the user of the search system displaying results appropriate to what they are searching. ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. ICT PROJECT

    Enter within boundary data e.g. 60 To see how validation system accept the right data Data should enter without a problems 30. At boundary data e.g. 99 To see how system reacts to correct data Should enter data without difficulties 31.

  2. GCSE Excel Project ICT

    Now the OS cell (B16:D16 (merged)) this has multiple values but it is not important enough to have a separate sheet, so a drop-down box will be created. We select B16 and, under the data validation tab, we are brought to this pop-up box: As we wish for this cell to be a 'drop down' box

  1. ICT Coursework (MarcoS)

    in cell E38 in the Invoice sheet The price of the project is displayed 75 Formula in cell E40 in the Invoice sheet The type of payment chosen is displayed 76 Formula in cell G5 in the Materials sheet The result of D5 x F5 is

  2. The impact of ICT on a person with special/particular needs

    to have access to the internet to do a lot of things advertised and such which adds to the periodical cost Sarah has to pay * Takes a lot of electricity * Can be addicting, time consuming and very distracting with the vast amount there is to do * With

  1. Computer project Alevels

    using wizard' you can then follow the wizard and make a report. Then if you are using design view you must then select 'Create report in design view' and then you can create the report. * Editing Reports * The background of a report can be in two ways this

  2. Ict Powerpoint Coursework

    The buttons on the slideshow will be a forward button to go to the next slide, a previous button to go to the previous slide, a home button to redirect the user of the slideshow to the main slide, where there is a variety of buttons redirecting the user to

  1. Database coursework

    6 Queries to be produced. Output The primary way to present the output will be the Monitors. This will be used by employees and customers. The secondary way to present the output will be the A4 paper. This will be used for the invoice.

  2. Database Coursework

    In the membership form that they fill out, they give us their number or email addresses; they also tick a box about whether or not they want to receive information about DVD releases. We send texts or emails to customers who do want to receive information about new DVD releases.

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