Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(iv). Add a title: MOTO VEHICLES In car type (g) Add Header as Your Name and Yo INFORMATION REPORT size 24 (h) Add an image
(iv). Add a title: MOTO VEHICLES In car type (g) Add Header as Your Name and Yo INFORMATION REPORT size 24 (h) Add an image on your report to serve ander as Footer on the report (h) Print your queries and report only. PRACTICAL QUESTION EIGHT (a) Using a database package create a database file 'COMPANY', Design a table with the following fields; use appropriate data types and appropriate primary key. The field EmpNo should be automatically increase by 1. Enter the following records in a table, save the table as EMPIOVErs b) Using all the fields in your table, create a query that will return the Gross Salary of each employee. Save the query as Gross Salary. c) From the query Gross Salary, create a query that displays all employees who were employed before February 2012 and earn a basic salary of more than UGX 800,000 . Save the query as ROYALS. d) Create a query for those employees whose names end with letter " a " and working in the department of marketing. Save it as Dept Mar. Produce a report grouped according to department that extracts the following information from the query in (b) above: EmpNo, Dept, Surname, Basic Salary, and Basic Salary. Save it as Gross Report. 7. Freate an input form that can be used to enter data in the table. On the form, add a company logo (use any image from computer or picture from clipart) and save the form as Data Entry Form. Include your name and personal number as page footer
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started