-
Instead of filter by selection I clicked filter by form and a blank record came up. I inserted, “shrub or hedge,” in the plant type, I then selected, “yes,” in damp soil. I went to average height and typed in, “>2”. I applied the filter and I got four records up.
Activity 3
I scrolled down to, “Sacred Bamboo,” and then deleted the record. I went back into the plants database format page and I selected query. I double clicked on the create query in design view button. A show table came up and I selected plants and then add. In selected queries I have selected common name, plant type, average heights and description as this is the only information I want on the labels. I went into the criteria row under the plant type column and typed in, “Shrub,” as I only want all the information on shrubs. I then saved my query so I can now access it from clicking on query in the file format section.
I went to the category called report; I created a new report by clicking new. 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. I went into Microsoft access and clicked on tables. Inside this I clicked on create a table in design view. In the first field I typed in Title and in data type I selected text. I did the same for forename, surname, house number, street, town, post code, telephone number, internet and finally interests. For all of these I selected text in the data type. I then saved my table and called it customers. I closed and reopened it. I copied all the information from Microsoft Excel into my Microsoft Access Customer table and then saved it again.
I went into my plants database format page and selected report; I then clicked on Create report by using wizard. When the wizard came up I took my information from the customers table. I selected, “Title,” “Forename,” “Surname,” and “Telephone Number.” I then clicked next twice. I sorted my records in order of surname first, and on the second level I sorted them in order of forename in case two or more people had the same surname. I then clicked next and selected tabular in the layout section. 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.
