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

  Describe various relational database management systems

Create an xml representation of data describing various relational database management systems (e.g. Microsoft SQL Server, MySQL, ...). The data for each database should include (but is not necessarily limited to) info like name, vendor, current v..

  Design of the premiere products database

Indicate the changes you need to make to the design of the Premiere Products database to support the following situation. A customer is not necessarily represented by a single sales rep but can be represented by several sales reps.

  Explain the content and user access methods

Find an example of an actual data warehouse. For this example, explain the content, user access methods, purpose, and sources of data (what on-line transaction processing [OLTP] databases feed data into the data warehouse) -

  Create application owner and stored in schema

One of the tenets of database development is to never permit developers to create or own objects during development. All objects are created by application owner and stored in that schema.

  Design of a data warehouse

Enterprises are accumulating substantial amounts of data that are necessary for their business operations.

  The database used for the relational algebra simple one

Relational Algebra- The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined)

  Analyze the data in the database and in application exercise

To complete this assignment, you will need to do data calculations. Remember to follow good database practice here by not saving your calculations as part of the data table itself (they should appear only in your queries).

  1 not having an appropriate index can cause a full table

1. not having an appropriate index can cause a full table scan while performing the select statement by using a

  Draw a context diagram of the computerised inventory system

Draw a Context Diagram of the Computerised Inventory System at The Variety Store from the perspective of the Purchasing Department. Please complete using the DIA software and also in word document.

  Print to screen the ''below average''

Print to screen the 'below average' if minimum unit_cost is 10 for the same product (use sh.costs table)

  What amount would company have to charge for cake

what would you expect to happen to the costs of cakes and what would be the overall margin on the order?

  Clustered versus unclustered indexes

Choice of search key for the index. What is a composite search key, and what considerations are made in choosing composite search keys? What are index-only plans, and what is the in?uence of potential index-only evaluation plans on the choice of sear..

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