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

  2. ict applied coursework

    Also the printing speed is reasonable and if someone does not print a lot just like me that printer can be made to a perfect use. MP3 Player: I use my Mp3 player only personally to listen to music when I am on my way to my friends or even school.

  1. System administration report

    - How does the hotel do about when purchasing new equipment, hardware or software? - How many times does the IT department have to write reports for management? Monitoring Processes - What day-to-day checks are made to the IT department?

  2. Different types of technology How I use ICT at home and at school

    What Facebook essentially does is make you think you have a social life and makes you depend and become addicted to Facebook using this illusion of a social life. It becomes addictive, distractive and hard to stop using. It distracts and causes me to procrastinate on my work and causes

  1. ICT Job Applications - Enricé's Tapas Bar.

    Execute macros to perform tasks, I have recorded, very quickly, create website to let applicants to enter their details in their own time and draw tables and hide them, which can be used to set the layout of the top half of the letters.

  2. Design Section

    used Order Reference Number on Customer Details Page Number =RAND()*(1-1000)+1000 used Motorola, Nokia, Sony Ericsonn and Samsung on Phone Selection Page Text Hyperlink is used Model on Motorola, Nokia, Sony Ericsonn and Samsung Page Text VLOOKUP - source from

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

    This is more the tertiary sector of the industry since they do not really provide you with a product, so there uses for IT are going to be different. The main program that is used to check people in and out is called Opera, this is a program that is widely used between hotels.

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

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