• 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...


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.


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.


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

    USB in the end are beneficial to Boots as it allows the R&D Department to do their research and print and fax and scan documents that need to be filed with ease. It is beneficial for suppliers because it allows them to print off the delivery list for their individual

  2. Computer Systems Assignment 2

    To change directory, type the following command cd dos. To copy Assignment 1 Tasksheet, you would type copy Assignment 1 Tasksheet.doc D:\. To rename a file you type Ren Assignment 1 Tasksheet.doc Assignment 2 Tasksheet.doc. To get help you type in help copy.

  1. Database Coursework

    Field Data Type Length Reason Loan ID AutoNumber Long Integer I have set this as AutoNumber so that computer automatically provides a unique number for each record. This can be any length as it linked to the number of loans.

  2. ICT Coursework (MarcoS)

    End-user questionnaire, to know how currently they keep the accounts Data input The data, like customers' details and projects details, will be input by the employee. Then everything will be checked by the manager. Data manipulation The data entered the system, will be used to make up the order of the customer, and to calculate prices of different projects.

  1. ict applied coursework

    Personannly, for example at school to calculate answers. I have used the calculator a few times during my maths lessons to help me to find the answers of questions which were to hard to work out by my own. There are a few types of calculator the most known are simple and scientific calculators.

  2. Design Section

    and Samsung Page Number VLOOKUP - source from the phone table, column 5 Cost on Motorola, Nokia, Sony Ericsonn and Samsung Page Number VLOOKUP - source from the phone table, column 6 General on Motorola, Nokia, Sony Ericsonn and Samsung Page Text VLOOKUP - source from the phone table, column

  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