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

I.T Shopticians

Extracts from this document...

Introduction

Design The series of tasks that I will perform from now until the system is completed: 1. Research into information the company needs to include in database content. 2. Create a data capture form. 3. Fill in my data capture form, in order to organise what fields I will create. 4. Create a data design sheet. 5. Fill in my data design sheet, in order to organise what types of fields I will create [e.g. Boolean]. 6. Start creating fields and text labels in the main layout in Viewpoint. 7. Create the other different layouts that I will have. 8. Add validation checks to fields where it is necessary. 9. Test the validation by inserting 'test records'. 10. Create queries by sorting and searching. 11. Attach the queries to the layouts. 12. Create buttons on the first page, in order to navigate around the database, through the different layouts. These will then need testing, to see if they link to the correct layout. 13. Set up a web page, so that a web link button can be created on the database. 14. Check database through to see if it is all working correctly. 15. Input all data as records. Inputs: Data that is required for the system will need to be input. This would be through a mouse and a keyboard. When the database is first being set up, the main input device needed will be a mouse. ...read more.

Middle

On the other hand, Shopticians will probably need to use printers a lot more, and therefore speed needs to be put into consideration. Because of this, a laser printer would be the most sensible choice, despite its higher cost. Processing: The speed of viewing and using the database depends on the computer's CPU (Central Processing Unit) and memory size. The CPU could be compared to the brain of a computer system. It is where input data is processed and turned into output data. The higher the processing speed, the faster the instructions are carried out. For complicated instructions, such as validation, a big RAM is needed. Another process is the downloading of pages, when viewing them on the Internet. This will apply to the webpage that is linked to the database, that customers will be able to view. The speed of this depends on the user's Internet connection, measured in how many bytes are sent per second. Most users at home [Shopticians' customers] will have either a broadband connection, usually at around 1MB per second, or a slower dial up modem at around 56.6KB per second. I, however, have access to a much faster T100 link, which works at the speed of 10GB per second, meaning that web pages that I view load almost instantly. However, if I had one of the slower connections, there would be a longer loading time. 3GHz processor at skool If this slower system was the case for a customer, then they may become impatient waiting for the Shopticians website to load, and give up. ...read more.

Conclusion

The user can also change the type of field if a wrong one is created, and they realise that, for example, it needs to be a text field instead of an integer. Although, to completely delete a field, the user has to know to press 'ctrl', as well as 'delete'. Another advantage about the software, however, is that, for text and fields, the software allows the user to select multiple boxes, in order to change colours, fonts, borders and backgrounds, saving time. A main useful feature that is included in Viewpoint, is 'Query'. This saves the user time, instead of them having to browse the whole database, and also allows a 'Sort', for a specific order. Layouts can also be created with attached queries. However, the user has to know the specific codes to type. For example, to find all ages under 15 the user has to type '<15' and not everyone may know this, again coming back to the point that training is required. After considering the 3 software as options, it has become clear that Microsoft Word is not really an option at all. Then, in the words of http://www.filemaker.com, "Most people would agree that Excel is the tool of choice when it comes to crunching numbers and building charts. But when your needs become more sophisticated and you want to add graphics, print professional reports, perform complex searches and sorts, or share your data across a workgroup, it's time to consider a database solution." Therefore, I will use Viewpoint. User Interface: Navigation Through The Database: ?? ?? ?? ?? Shopticians Coursework ...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. Reviewing different multimedia presentations.

    User interaction It has good interactivity as it is easy to make you way through the Multimedia Presentation as all you have to do is click through at your own pace. Use of animation and/or video In this Multimedia Presentation there is no video in it at all which makes it quite boring to do.

  2. 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.

  1. 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

  2. Information and Communical technology

    A database is made up of one or more related files. Data from the company can be ordered in tables. In a database you can use a Query so that you can search for particular criteria. In addition, you can add an icon of your choice in the table.

  1. ICT BTEC UNIT 2 - REPORT

    system is using all the minimum system requirements which could cause the computer to be slow and tedious. The top computer meets the requirements and then exceeds them this will make the computer a very fast system but comes at a considerably higher price at �8,395 however having said that

  2. Spreadsheet for a basketball company

    Objectives The users have specified several essential elements, which they would like to be featured in the project, and after a discussion, we have come to an agreement of the following eight objectives that the project should be proficient in performing: 1.

  1. Project 1b; Film Database

    The screen print of the database is on the next page. This database has the purpose to identify the films it is asked for. To find them efficiently, the user can use queries. The data that is relevant will be sorted and filtered according to the criteria and sort typed in by the user.

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

    * The spreadsheet should be quicker, by calculating everything. Quick calculations shall be made, as soon as the description of item is keyed in. * Will have formulas that will allow new information to be typed and will affect the profit/loss of the company accordingly.

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