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

IT B2 report

Extracts from this document...

Introduction

Coursework Assignment B2 : Garden World Word Processed Report Plant Database Activity 1 To obtain the document I went into learning resources on my school network system and I saved the database entitled, "plants," into my documents. I double clicked on this and it opened a page with options asking which file I wanted to open. I double clicked on plants, as a table and then it opened. To insert the two new types of plants I clicked on insert then new database. Once I inserted the two records I put them in alphabetical order. To do this I highlighted the row saying common name then I clicked the button A to Z. Activity 2 1. I clicked on a cell that had the name, "Conifer," in the plant type. I then went to the button filter by selection, all the conifers came up. I then went to the column entitled damp soil, I selected one that liked it and I then filtered it. I ended up with 7 conifers that liked damp soil. I then I clicked the remove filter button. ...read more.

Middle

I went into the label wizard and I selected the information from the shrub query. I chose the manufacturer HP and the size of the label given was the size I needed. I selected all the categories again and then clicked next. I selected them in alphabetical order so they will be printed in alphabetical order too. I again clicked next then finish. A preview of the labels then came up on screen. I inserted word art saying, "Garden World." To do this I clicked the view button, and then I went into Microsoft Word and made a title with word-art saying, "Garden World". I chose a logo and made them quite small. I then copied and pasted them into my Microsoft Access report. I also added in labels saying all the titles so you could see what written beside each section. I did this by clicking label in the tool bar. I then clicked view again which showed me a final view of my final eight labels. Customer Database Activity 1 To obtain the document I went into learning resources on my school network system from this I took the Customer database and saved it in my folder. ...read more.

Conclusion

I also selected portrait in the orientation section, I again clicked next. I chose the style casual, I again clicked next. I inserted the title, "Customers Tel No's." I wrote a letter explaining that there was a sale. I then inserted my Garden World title and logo. I then opened my customer table. I went into tools in the menu bar, I then clicked office links and merge with Microsoft Word. When the wizard came up I selected link your data to an existing Microsoft Word document. I clicked ok and then opened my letter. I selected insert merge fields in the menu bar. I selected title, forename and surname to go on the first line. I went a line below and inserted house number, street and on the next line I selected town followed by postcode. I clicked beside where I wrote dear and inserted the title and surname as I did before. I clicked on mail merge recipients and I went to interests. I selected broad leaf trees and the people who liked broad leafed trees came up. There were four and I clicked ok. I clicked merge to new document and ok. My four letters were then presented in a Microsoft Word document. G.C.S.E. Information & Communication Technology 1 Leanne Quinn 5B ...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. ICT Report 2b: ICT in Organisations

    Also, several miles of these cables are cheaper than an equivalent length of copper wires. Therefore, for Boots it is a cheaper, albeit much better quality method for transmitting data between its stores. Finally, fibre optic cables are much less susceptible to interference.

  2. ICT Coursework (MarcoS)

    Cell link: type " B12 " Then press OK on then window, to close it. * In the cell C7 type in the following formula: =IF(B6="","",VLOOKUP(B6,Customers!B3:E12,2)) Now the name that you have select will appear in this cell. * In the cell F6 type in the following formula: =IF(B6="","",VLOOKUP(B6,Customers!B3:E12,3))

  1. Computer Systems Assignment 2

    You do not need to know what you are doing to operate Windows and that is why a lot of computers are slow because they do not know how or why they should defragmentate their computers. d) The DOS command used to make a new folder is Mk dir.

  2. Database Coursework

    However, it's not designed to calculate, which means that it would be very suitable for the system. Although the records would be well maintained, it would still mean that the calculations would have to be made manually. This wouldn't be much of an advantage to the mechanics.

  1. ict applied coursework

    as researches can be done very quickly, as well as online shopping or communication can take place socially. Calculator: I use the calculator to calculate the price of any products I want to buy or I use it. Personannly, for example at school to calculate answers.

  2. Design Section

    the phone table, column 2 Make on Motorola, Nokia, Sony Ericsonn and Samsung Page Number VLOOKUP - source from the phone table, column 3 Colour on Motorola, Nokia, Sony Ericsonn and Samsung Page Number VLOOKUP - source from the phone table, column 4 Talk time on Motorola, Nokia, Sony Ericsonn

  1. System administration report

    Main source information The main source of information came from two people, Mr. Mark Lewis, manager of the hotel and Mrs. Inge Rutten, system administrator of the hotel. I will hold close contact with these people, asking them questions related to the administration of the business.

  2. ICT (double award) - Business systems portfolio.

    server * There is a Firewall; this is a very important piece of hardware that stops any unwanted intrusions onto the system. It also stops viruses and worms being downloaded. * There is one server which all the computers are connected to.

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