End-User Computing: Access engagement 2011
Examiner: Mrs R. Minty
Total Marks: 50
-------------------------------------------------
Instructions:
* -------------------------------------------------
An electronic copy must be submitted to your lecturer for marking.
1. Open up the source document correct UP from the server motion-picture show in the computer labs and save it under your student number, last name and initials e.g. 201012345 Brink C.(1)
ANSWER THE FOLLOWING QUESTIONS ON THE EMPLOYEE TABLE
2. The salary tugboat contains ####. Correct this so that the information in this column is visible.(2)
3. kind the row height to 25pts.(2)
4. Ruan Smith started working at TUNE UP in 1999. Make this change.(1)
5. Edit the properties of the SALARY orbit to display values with 0 decimal places.(2)
6. Open the form EMPLOYEE FORM. Insert the following Footer: TUNE UP: BENONI secern(2)
7. Change the orientation of the EMPLOYEE FORM to landscape.(1)
8. Use the Report paladin to create a brood as follows:(5)
* Use each(prenominal) available cogitations.
* Grouping: Employee name
* Sorted in descending come out of salary
* Save the report as: EMPLOYEE REPORT
* Indicate on the report the total amount paid for salaries.
Accept the default settings for the persist of the options.
ANSWER THE FOLLOWING QUESTIONS ON THE CUSTOMER TABLE
9. Change the field name SERVICE COST to INVOICE TOTAL.(1)
10. Pam who is the administrator at TUNE UP forgot to enter the details for one customer. estimate the information below at the end of the table.(2)
Customer Number: C345
Customer Surname: Dalton
Customer Initials: T
Purpose: Replace incline box
Assisted by: E102
Invoice total: 22000
11. Insert a new field called MAKE OF CAR after the support BY field which allows the person
entering data into the table to opt data from a drop-down...If you want to get a in force(p) essay, order it on our website: Ordercustompaper.com
If you want to get a full essay, wisit our page: write my paper
No comments:
Post a Comment