Month only Vijhu Machu Yec/074 29.11.97 1000.00 55 811015 Honorary Member (c) (i) Insert the field called than 4000” that will accommodate Y “more for Yes and N for No. (3 marks) Indicate in these new fields those members who have paid more than sh.4000.00 with Y otherwise N. (3 marks) (iii) Save as Club2. (1 mark) (d) (i) Create a query that contains the field Membership Number, Last Name, Date of registration, Membership fee paid and status for all members who have paid less than sh.4000.00 and registered after 15/4/1995 or are above 35 years of age. (9 marks) (ii) Write on the paper provided the query expression you used. (2 marks) (iii) Save the query as ClubQ. (1 mark) (e) (i) Excluding the status field, create a report for all members and give it the title: ENTEREPRENEURS CLUB. (12 marks) (ii) Save the report as ClubR. (1 mark)
Month only Vijhu Machu Yec/074 29.11.97 1000.00 55 811015 Honorary Member (c) (i) Insert the field called “more than 4000” that will accommodate Y for Yes and N for No. (3 marks) Indicate in these new fields those members who have paid more than sh.4000.00 with Y otherwise N. (3 marks) (iii) Save as Club2. (1 mark) (d) (i) Create a query that contains the field Membership Number, Last Name, Date of registration, Membership fee paid and status for all members who have paid less than sh.4000.00 and registered after 15/4/1995 or are above 35 years of age. (9 marks) (ii) Write on the paper provided the query expression you used. (2 marks) (iii) Save the query as ClubQ. (1 mark) (e) (i) Excluding the status field, create a report for all members and give it the title: ENTEREPRENEURS CLUB. (12 marks) (ii) Save the report as ClubR. (1 mark)
Comp%20pp2%20016.docx