• 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. Evaluating a relational database solution

    Reports > I could print my reports at any time and I could lay them out exactly as I wanted them to be orientated. > Some of my reports looked like tables with the contents arranged in columns. > They could contain as much or as little information as you want - all records or just a few.

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

    is because you must type in the number of the row instead of the letter e.g. A would be 1, B would be 2 etc. However, if my cell range was from column G to J, then column G would be 1 etc.

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

    It will also allow detailed reference of how many children were there, the amount of adults and concessions, and allow their prices to be changed in an easy way. The spreadsheet permits Mr. Brown to easily change the values of each calculation by changing the appropriate square, for example to

  2. Database design for a games shop.

    Lastly I think having foreign keys is not enough in the rentals form. It would be more helpful if you could insert the name of the customer from the members table into the rentals, this will help me verify customers information.

  1. Selecting the best software for a theatre business.

    you buy your computer and you ask for it, if you buy the excel package or if you pay for it on the internet. This is a program that is worth the money because once Bob has it he will not stop using it until he gives up his shop.

  2. GNVQ intermediate ict unit 4

    When I finished drawing the button a macro window opened up called "Assign Macro". I clicked on the Record button and this window opened up I clicked OK. A small widow opened up (shown below) to let me record the macro.

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

    To obtain information form a database, the best method to use it to:- produce a query. Now a query is used, usually if you want to search for a particular piece or group of information. The easiest way to search for information on the Access database is by using a

  2. Reviewing different multimedia presentations.

    In overall it does use quite bright and interesting colours to grap the person who is using the Multimedia Presentations attention. The amount of text and other information To be honest there is no information or in fact text as it is just pictures.

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