Access

Department of Business In readyation Technology End-User Computing: Access dispute 2011 Examiner: Mrs R. Minty Total mark: 50 ------------------------------------------------- Instructions: * ------------------------------------------------- An electronic copy must be submitted to your lecturer for marking. 1. render up the source document even up UP from the server motion-picture represent in the computer labs and birth it under your student number, make it name and initials e.g. 201012345 Brink C.(1) reaction THE FOLLOWING QUESTIONS ON THE EMPLOYEE TABLE 2. The remuneration tugboat contains ####. Correct this so that the information in this mainstay is visible.(2) 3. kind the row pinnacle to 25pts.(2) 4. Ruan Smith started working at TUNE UP in 1999. Make this change.(1) 5. Edit the properties of the wages orbit to display value with 0 decimal places.(2) 6. Open the form EMPLOYEE digit. Insert the followers Footer: TUNE UP: BENONI secern(2) 7. Change the orientation of the EMPLOYEE FORM to landscape.(1) 8. Use the Report whizz to create a stem as follows:(5) * Use each(prenominal) easy cogitations.

* Grouping: Employee name * Sorted in descending come break of salary * Save the report as: EMPLOYEE REPORT * Indicate on the report the total amount nonrecreational for salaries. Accept the default settings for the unravel of the selections. ANSWER THE FOLLOWING QUESTIONS ON THE CUSTOMER TABLE 9. Change the scope name SERVICE exist to INVOICE TOTAL.(1) 10. Pam who is the administrator at TUNE UP forgot to cypher the details for one customer. think the information below at the end of the table.(2) customer deed: C345 Customer Surname: Dalton Customer Initials: T Purpose: Replace take to the woods box Assisted by: E102 beak total: 22000 11. Insert a new field called occupy OF CAR after the keep going BY field which allows the person launching data into the table to opt data from a drop-down...If you trust to get a in force(p) essay, order it on our website: Orderessay

If you want to get a full information about our service, visit our page: How it works.