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:
Work for Mr Ali's Classes
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:
Today you will:
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.
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
You will learn to:
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
Now create a report for your Queries
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.