• 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. Different types of technology How I use ICT at home and at school

    This meets my need to tackle my awkwardness and just talk about something I enjoy. Watching TV also lets me develop an interest in something and make it a hobby of mine. Discovering anime also made me delve further into it and become a fan, which made me also start reading manga.

  2. ICT Report 2b: ICT in Organisations

    The actual scanner is one of many types; a CCD reader. CCD readers (also referred to as LED scanner) use an arrangement of hundreds of tiny light sensors lined up in a row in the head of the reader. Each sensor can be thought of as a single photodiode that

  1. ICT Coursework (MarcoS)

    Software Advantages Disadvantages Microsoft Word 2007 - Very easy to use - You can easily create texts - You can add pictures to your texts - You can make table to insert data - You can change the font for your writing - You can make paragraphs like ball points ecc.

  2. gcse ict unit 2a

    In addition Asda announced plans to build a minimum of 18 stores across the whole UK and it is expected to create 2000 new jobs. Also, there are twenty four distribution centres and also a Head Office. Aims * To comprehensively be recognised as the best supermarket in the UK and also be known all around the world.

  1. GCSE ICT Coursework Write-up

    spreadsheet so instead of copying all of the values and typing them out, I could just mail merge them from the spreadsheet into the document. I used this for the payslip, as I was able to easily draw a table for the payslip and to insert the logo that I

  2. Database design.

    This asks you to select the fields you want in your query after you select the fields click next. This window will appear and asks if you want a detail query or summary query. Detail shows every field of every record, and a summary query is a choice of what fields you want calculated.

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

    Each menu can either have a default voice command or a customised one. The increased text/icon size feature makes Sarah able to use her own hands to navigate her phone, despite having extremely inaccurate control over this. It was briefly mentioned with the voice recognition feature but with this, Sarah can increase the size of text and icons.

  2. Ict Powerpoint Coursework

    , 12 GB ram , 4TB Hard Drive , Blu Ray RW This desktop is dated for up to 25 years into the future, I have chosen this computer due to the reliability of its top of the range features.

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