Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Open the JobsEntry form in Design View and complete the following: Open the Visual Basic Editor window for the form. Insert the comment 'Highlights jobs

Open the JobsEntry form in Design View and complete the following: Open the Visual Basic Editor window for the form. Insert the comment 'Highlights jobs in the energy industry as a new second line in the procedure just above the If statement. Save and close the Visual Basic Editor window then save and close the JobsEntry form. Create a standard module and save it using CustomFunctions as the name, and then create a new function within it by entering the code shown below, which is also shown in Figure 3. Function Demand(SalaryValue, IndustryValue) If SalaryValue > 50000 Then Demand = 3 ElseIf SalaryValue > 60000 Or IndustryValue = "Energy" Then Demand = 4 ElseIf SalaryValue > 60000 And IndustryValue = "Energy" Then Demand = 5 End If End Function Save and close the CustomFunctions module

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

Oracle Databases On The Web Learn To Create Web Pages That Interface With Database Engines

Authors: Robert Papaj, Donald Burleson

11th Edition

1576100995, 978-1576100998

More Books

Students also viewed these Databases questions

Question

The amount of work I am asked to do is reasonable.

Answered: 1 week ago

Question

The company encourages a balance between work and personal life.

Answered: 1 week ago