User Account

All Pages

How to set title criteria for more than one title position

Assignment Help Database Management System
Reference no: EM13949797

I am having a problem with criteria range. I do not know how to set two different criterias in one column. I need to ADVANCE FILTER all of the Clerks (1 and 2) and the Sect. 1 workers who make more than $5.50/hr. I do not understand how to set the title criteria for more than one title. It HAS to be advanced filtered, not auto-filtered. I already have the database labeled and the criteria page ready to go, I just need to figure out how to set the title criteria for more than one title position.

Here is the database that goes with this problem:A B C D E F G

3 Last Sex SS Number Title Class Yrs.Emp. Pay
4 Winston F 980-54-7654 Clerk 2 3 18 $5.25
5 Ricks F 546-90-8876 Sect. 1 3 9 $5.50
6 Miller M 101-99-1193 Sect. 1 3 7 $5.78
7 Larson F 676-45-3211 Clerk 1 3 9 $5.95
8 Thomas M 209-78-6543 Installer 3 11 $6.34
9 Flan F 300-74-4535 Clerk 1 3 16 $6.45
10 Evans F 908-57-4678 Clerk 2 3 14 $6.95
11 Murillo M 556-87-8839 Tech. Dev. 2 11 $7.25
12 Osborn M 786-45-6754 Repair 3 11 $7.74
13 Owens F 465-45-5678 Admin. 3 19 $6.55
14 Hines F 209-86-5646 Installer 3 14 $8.89
15 Sandy F 769-43-2121 Sales Rep. 3 15 $8.99
16 Altman M 565-56-5665 Sales 2 11 $9.02

Please help me figure out how to ADVANCE filter for the Clerks and Sect. 1 workers who make more than $5.50.

Reference no: EM13949797

Questions Cloud

Compute gross revenues by month and region : Create a new worksheet in the database to compute gross revenues by month and region, as well as world-wide totals, for each product using the data in Mower Unit Sales and Tractor Unit Sales
Determine the mass flow rate : Air enters a one-inlet, one-exit control volume at 6 bar, 500 K, and 30 m/s through a flow area of 28 cm2. At the exit, the pressure is 3 bar, the temperature is 456.5 K, and the velocity is 300 m/s. The air behaves as an ideal gas. For steady-sta..
Significant areas of audit planning and risk assessment : One of the most significant areas of audit planning and risk assessment is to become expertly knowledgeable about the industry or industries that the audit client operates in. This may involve multiple SBU's (Strategic Business Units).
Develop a list of it audit tasks : Describe the various general controls and audit approaches for software and architecture to include operating systems, telecommunication networks, cloud computing, service-oriented architecture and virtualization.
How to set title criteria for more than one title position : I am having a problem with criteria range. I do not know how to set two different criterias in one column. I need to ADVANCE FILTER all of the Clerks (1 and 2) and the Sect. 1 workers who make more than $5.50/hr
What effect would davids actions have on quality of bolts : Explain why David stopped inspections on the bolts and reassigned inspectors to production and materials handling. What likely effect would David's actions have on the quality of the bolts?
Operator of a pumper-tanker fire engine : 1. How does the operator of a pumper-tanker fire engine control water flow to all the hoses in use? 2. For air flowing through a converging-diverging channel, sketch the variation of the air pressure as air accelerates in the converging section and..
Control volume energy rate balance : 1. How does the control volume energy rate balance account for work where mass flows across the boundary? 2. Why does the relative velocity normal to the flow boundary, Vn, appear in Eqs. 4.3 and 4.8?
What is the probability that at least one bill is incorrect : What is the probability that 10 of the bills is incorrect? What is the probability that at least one bill is incorrect? What is the probability that more than 15 of the bills is incorrect?

Reviews

Write a Review

Database Management System Questions & Answers

  Information-gathering techniques for the project

Explain the information-gathering techniques and design methods you would suggest to use for project. Recognize the key factors that help ensure the information required for the project.

  What is the cardinality of an entity

What is the cardinality of an entity - Why is it useful to consider the cardinality when designing a database?

  Random number cards from a deck

Write a script that will print 10 random number cards from a deck. A. The script will build a deck of 52 cards by using nested foreach loops.

  Explore ways of converting depositors to borrowers

Universal Bank is a young bank growing rapidly in overall customer acquisition. The majority of these customers are depositors with varying sizes of relationship with the bank. The customer base of borrowers is quite small, and the bank is interes..

  What is the reason for this increased emphasis

Modern relational database management systems have been around for a relatively short period of time.

  Determine the best shipment of coal cars

The Southern Rail Company ships coal by rail from three coal mines to meet the demand requirements of four coal depots. The following table shows the distances from the mines to the various depots and the availabilities and requirements for coal

  How can you create and manipulate an object in sql

How can you create and manipulate an object in SQL?

  Create set of relational tables that are normalized to bcnf

Using the information given above, create a set of relational tables that are normalized to BCNF.

  Explain web forms with database interaction

Web Forms with Database Interaction, you will start with the form created in Week 2 and add functionality to INSERT records into a database table and SELECT records for display to the user

  Case study requirement and analysis disciplines through

case study requirement and analysis disciplines through analysis of a simple case study and to express the results

  1 prepare directories on your hard drive place a small text

1 prepare directories on your hard drive. place a small text file in one directory. use oracle package utlfile to read

  Expanded entity relationship model diagram

Each department has many employees assigned to it, but each employee works for only one department at one of the factories. An employee cannot work at more than one factory at a time.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd