Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed (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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

What are the roles of the Analysis, Redo, and Undo phases in ARIES?

Answered: 1 week ago

Question

2. Develop a persuasive topic and thesis

Answered: 1 week ago

Question

1. Define the goals of persuasive speaking

Answered: 1 week ago