Category: Functional ICT
Protected: Functionals skills – Introduction to Spreadsheets
Functional Skills – Practice Task
Task Aim
- Create a menu for an Indian Takeaway
Use the file below to create a menu for an Indian Takeaway. It needs to be professionally laid out.
Functional Skills – Exam Practice
Your Task
Your task is to start the November Functional skills exam.
This lesson you should complete questions 1&2 minimum
You can find the exam paper and data files in the link below:
Functional skills Exam II
Following the practice exam last lesson we will cover some of the issues which arose. You will have an opportunity to do second practice task. Find the task and data files below:
Functional skills – exam files
Functional Skills – Mail-merge
Today you will:
- Mail merge the information from the members database to the letter
You can use your own letter if you can’t find use the letter below:
Now create a membership card for members of the fitness suite and mail-merge details from the database.
Functional skills – Databases III
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
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