• 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

    I feel that although the pictures were effective I could have used scanners and widened my range of skills shown during the process of producing the publication. This would also have made the publication look more professional. Overall I think Microsoft Access was the correct program to complete my work

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

    and view the results already in a format that shows whether or not he gained money or lost it in the show, and where he must improve to achieve peak profit in order to gain more money. The spreadsheet shows simply and easily whether or not Mr Brown has made a profit.

  1. Selecting the best software for a theatre business.

    � In the spreadsheet he can use goal seek, this will tell Bob how many tickets he will need to sell to make a certain amount of money, for example if the tickets cost �50 each, and he needs to make a minimum of �2000 the goal seek will tell him he needs to sell 400 tickets.

  2. GNVQ intermediate ict unit 4

    (This is a range that contains all the names of the teams) Testing my system Test Predicted result Actual result Any changes made Yes/No 1.Open up spreadsheet Spreadsheet should be in folder and I would be able to find it.

  1. Database design for a games shop.

    Data flow diagram Receive error report No/overdue Data manipulation In the system I will require the following tables and they will be structured as shown: * Members: (client number, title, first name, surname, address phone number and email address) * Games: (game ID(primary key), name of game, system, genre, rental price per day)

  2. Hire Shop - creating a database.

    It will have two hold at least 50 records. It has to be easy to operate. Information has to be easy to get at. It will have the shops logo at the top of the page. It will identify what hired out equipment is over due.

  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. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    When the "Insert Function" box appeared, I found the "IF" function and clicked on it. 3)A "Function Argument" box then appeared. In the space next to the words, "Logical_test" I started to create the formula I needed. I wanted to create a function which told me, if the person

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