Central 3295 Hassan Eunice Three East 2956 Busolo Josephat Three North 2977 Makhanu Josephat Four South 3216 Mateshe Jackline Three West Club Number Club Name Date established 97/Mat Mathematics 05/02/1997 02/Sci Science 08/04/2002 01/Env Environment 01/09/2001 97/Lan Debate 08/04/1997
Reg. Number Admn. No. Club No. Reg. Date Membership Fee MT/0013 2844 97/Mat 12/03/2007 100 SC/0189 2977 02/Sci 11/03/2007 120 MT/0975 2910 97/Mat 05/05/2007 100 DB/0111 2977 97/Lan 11/03/2007 90 EN/1001 3811 01/Env 01/03/2010 80 SC/0998 3216 02/Sci 09/10/2008 120 SC/1006 2844 02/Sci 12/03/2007 120 DB/0565 3295 97/Lan 10/05/2008 90 (c) Create a query for each record containing the product of membership fees $ multiplied by 79.8.Label this column “Amount in shillings”. The query should display: Last Name (in ascending order), First Name, Registration Number, Date of Registration, Amount in shillings. For all members whosellast name start with M or J and first name start with M save the query as Query M(8mks)(d) Create a query that Display Admission Number, Last name, first Name, Club Names and Registration date for form four students. Save query as (e) Create a tabular report from Query-M that displays Last Name, First Name, Membership Number, Date of Registration, Membership Fees paid in shillings and display the total to the membership feesat the end of the report. Save the repo\rt as “Membership Report”(5mks)Admn. No. First Name Last Name Form Stream 3200 Busaule Mwitani Two East 3811 Mawi Martha One South 2844 Nambwaya Nancy Four East 2910 Wafula Victor Four Central 3295 Hassan Eunice Three East 2956 Busolo Josephat Three North 2977 Makhanu Josephat Four South 3216 Mateshe Jackline Three West (f) Create a tabular report from Members query, sort the records by first name and save it as Club Members. (4mks) (g) On each report, add your name, index number and page number in the format “Page X of Y pages” as footer (4mks) (h) Add “Mary Seat of Wisdom Bulimbo Girls’ Sec. School” and Report Name as Header on each report (2mks) (i) Print membership Report, Club Members, Query-M and Student table (4mks) Question two (a) Enter the following as it is onto worksheet and save it as the budget (7mks) A B C D E F G No. Item description Quantity bought Unit price Amount Comments Cost Rank 1 2Kg Mumias Sugar 4 210 2 Sony 2HD floppy 3 37 3 Rapid spring file 10 56 4 200pg A4 books 9 89 5 1 litre Quencher 2 256 6 AIHAO Gelink pen 15 55 7 Omega dustless chalk 18 105 8 LG 2GB Flash Disk 4 1055 Total
You've reached the end of your free preview.
Want to read all 75 pages?
- Fall '12
- mks, following terms