Sunday, February 04, 2007
Database section in practise exam(January 2006)
Task 2 needed a validation rule created and validation text to complement it: The rule was "A" or "B" or "C" ...
Task 3 asked to use the relationship feature to create a one to many relationship with the AGEGROUP and FEE table(right click> select realtionships>right click>showtables>insert table> drag and drop> tick the box enforce referntial integrity.):
Task 4 just asked to insert new data into the firld Feecode: (Ensure all data copied as appears exactly on exam!!):
Task 5 needed a query to be created. To do so i selected "query>design view and insert relevant table and fields-in question- and then under surname sort:ascending and for criteria for feespaid "no" and date joined "<01/10/05"(neither>
Task 6 just asked for a screenshot produced on the design view showing all criteria:
Unfortunately i was unable to complete the 7th and 8th task. I am unaware on who to create a report and even though the 8th apperas simple i need to use the report created so am unable to complete. I need to ask Mr Barr to explain for me.
This now ends the database section of the exam.
