Today you will learn to:
Create queries and also use wildcards in your query
Create reports for your queries.
You will need to open your newsome fitness database from last lesson, complete the following worksheet:
Tutorials
Year 9 -Business letter & Flyer
You need to ensure you have completed your letter.
The letter needs to contain the following:
- Letter Header (including logo and Newsome high address)
- Date
- Name & Address of the recipient
- Salutation (eg. Dear Mr Smith)
- Main Content
- Commentary Close (Yours Sincerely)
- Space for Signature + Printed Name
Once you have created the letter you need to create a flyer advertising the Paris trip to Year 11 Pupils.
The flyer is to be produced on Publisher and must meet requirements of the house style (use logo, appropriate colours and fonts). You also need to incule cost, date, 2 pictures 1 from clipart and 1 from the internet. The purpose of the flyer is to encourage students to go on the trip to Paris.
Functional Skills – Database II
You will learn to:
- Sort a database in Access
- Search a database in Access (create queries)
Download the database below and save it to your user area:
YOU MAY WANT TO USE VIDEO TUTORIALS
Create queries to carry out the following tasks
- Sort your database in Surname order
- Sort your database by Gender and then Firstname
- Find all members with surname Mcdonald
- Find all members who are under 21
- Find all members between 25 and 35
- Find all members who live on Claycliffe Hill Avenue or Street
Now create a report for your Queries
Unit 1 – 2010 AO4 Business letter
Your task is to create a Business letter using your House Style. The letter is for the parents of Year 11 pupils at Newsome wanting to go on the Paris trip.
Here is an example of the content you may put in the letter.
Example letter
Use the presentation below to help you decide how to layout a business letter:
Functional skills – Intro to Databases
Lesson Aim:
Define Field, Record and File
Design a database structure in MS Access and add records to your database
Click on the link below to view presentation on databases
Now create a database structure to hold information about members of Newsome fitness Centre.
Use the design details below to design the table.
Now add 10 records to your database.
Please ensure they are not for real people.
Year 10 – OCR Unit 2 website
Today lesson you will need to continue with adding content to your website. In todays lesson you will need to create roll over images into your website, can you add a minimum of three roll over images.
Year 9 – lesson 5
Complete the Paris costs spreadsheet , if you have not already started the evidence sheet click on the link below to download it:
If you have finished the Paris costs evidence ensure all files for unit 1 are in the correct folder.
You may then create a Xmas card in Publisher or word
Year 7 – Cover for lesson 4
Your task is to find the cheapest prices for a range of Xmas products use the sheet below and the internet to carry out your task:
Year 10 – Cover lesson 3
In todays lesson continue with your websites, you should have at least 3 pages of content on your website. Remember the content of your website can be straight of the internet, your role is to arrange it into a suitable format for publishing on the web.