• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  • Level: GCSE
  • Subject: ICT
  • Word count: 1981

User Documentation for ICT A Coursework 2a

Extracts from this document...


1 USER DOCUMENTATION [7 MARKS] 1.1 Editing Data [2 marks] 1.1.1 Entering and Saving Data [1] This is the first screenshot which shows the list of data forms that could be opened. To open the form you would have to click on the form that you require and open the form that you need. When the form has been double clicked, it will then open and this screenshot shows what should come up. A datasheet should come up showing this information all about the table. To add new records to the form, you just have to go to the bottom of the screen and click on new record button where it can the open up a new record. On the form when you enter a new record, you can save it by just clicking on a button which is shown on the screenshot. The button will save the record and so it is much easier then right clicking on the tile and then saving on the datasheet. This is a more easier and efficient way to save it. 1.1.2 Amending Data [2] When a game is sold or the information about it has been changed then you will need to change the data in order for your system to be updated. To change existing records first of all you need to open a table like the sales one. If there is a lot of records and a lot of data, and you also don't have a lot of time then to search for the data you want to change more quicker is to by clicking on the find button which will allow you to find any record and then change it. ...read more.


The fields selected are forename, surname, name of game, gender and console. When you have clicked on Run to run the query, this is the data that should come up. Query on sales made This is a query that is being run on sales of games. The basic query is to find and search for all games that have been sold with a quantity of 10. The fields are name of game and quantity sold. These are the results of the query after running it. Multi table query on certain games that are sold This is a multi table query on certain games on a certain console. The query is for the user to find sales of certain games on only one type of console so if the user is looking for game sales for one console, this query would be accurate. The fields are name of game, sale ID, price and console. After clicking on run, this is the data that should come up. Query for stock of a certain quantity This is a query to find out games in stock which have a certain number of quantity. The fields include name of game, certain number of quantity and Game ID. After running query, this is the data that should come up. Create new queries /filters for their requirements To create a new query for your own requirement, in the system you need to click on create which will allow you to then select a type of making query- query wizard, query design. ...read more.


You then need to select the file- database or system so that you can use the fields from the table in the letter You then need to select the table(s) you want or need. Then click on Ok When you have done that, by choosing a field- members in this example, you will get fields all over your template. You will then need to preview results to check if the right data comes up and merge the data. Then you can fully merge all the data and make as many mail merge letters to your members by clicking on finish and merge and selecting all records. A list and view of all the finished mail merge letters that are ready to be emailed to members. 1.3 Avoiding Problems [2 marks] 1.3.1 Producing Results [2] When you are setting validation rules or queries and you want certain data to be entered then using <value or >value will allow you to enter in certain data but if you want those certain values to be entered in as well, then you will have to change the requirement to <= or >= to enter in both types of data. When you are making a query - normal or multi table- if you want a certain criteria then you will need to type that in. However if you want two types of certain data then by just typing in one type will only get you results linking to that type of data. You will need to type in something underneath in Or to get another type of result not just one. ?? ?? ?? ?? GCSE ICT - Coursework Task 2 Name: Ashley Koya ...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. a level ict project

    Proceed to follow the steps of installation17 I can't open the password protected file All passwords as well as user names are case sensitive; therefore it matters whether the caps lock in on or off. When entering the username and password check to see whether the caps lock is on

  2. Tennis Tournament UNIT 1 GCSE ICT coursework

    Another is that a spreadsheet lets you validate data so that its entered, so that if a mistake is made and put in the recycle bin it would not allow it. 5). A good feature about spreadsheets is that it lets you protect cells so then users can not change formulas.

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

    Sarah is extremely keen on using Facebook. While she does this mainly from her computer, she can also do this from her iPhone. This allows her to be social wherever she is, which she wants a lot as she is at home all day. She craves to be like a normal person and although she may not

  2. Computer Systems Assignment 2

    A joystick is a more lifelike control than a steering wheel with immediate reactions concerning direction. It behaves in an intuitive manner. The reason it is used in computer games is because it is ergonomic and it provides different levels of resistance, is programmable and is comfortable to use and gives precise adjustment.

  1. Testing for ICT A Coursework 2a

    These are the results of my query and it shows again the exact information that i needed. TEST 6 This is my last query in total and this may be the most important query of all as it will search for certain stock which may be important to the user so this would be very important.

  2. ICT car insurance quotation System Coursework

    It then displays the Multiplier value. The If sections of the formula, makes the cell blank whenever the Clearscreen macro is pressed. So subsequently does not display #N/A. =IF(E26="","",VLOOKUP(E26,Multipliers!A36:C38,3)). This formula multiplies the figures in H10,H11,H12,H13 and H15, to get the total; cost of the quote.

  1. System requirements analysis

    This is a printer, scanner and a photocopier machine. It is ideal for office and photo use. It costs roughly �45.00. This printer is not a fast printer like the LaserJet printer. But I feel that the heath centre do not need a fast laser jet printer as they are not going to need a fast printer to print out prescriptions, letters, etc.

  2. ICT Case Study Coursework - Hull Daily Mail Publications Ltd.

    If one of the disks fail, the backup drive is brought straight into action and a message is broadcast to all the IT support computers. The users do not notice any difference. The problem with this method is that you only get half of the total space which you have.

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