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

  Converting user form into 1nf and 2nf

Complete database exercise by converting user form located the evaluation procedures section of the syllabus into 1NF and 2NF.

  Summarize-data collection methods

Is the problem significant to nursing and health care? How will it generate or refine knowledge in nursing practice and Was the review of background literature provided?

  Analysis of a simple case study

VSS has an existing software package that controls its high bay systems and wants to rewrite it. The existing system is written in C and uses C-ISAM files to store data.

  Create tables using database called "genomicdb"

I created a database called "genomicdb" in MYSQL server with two tables: "gene" and "location". The tables are supposed to be populated with data from .txt files.

  Question 1a explain the use of facts dimensions and

question 1a explain the use of facts dimensions and attributes in a star schema model.b in relation to a fact table

  Write the sql code to change the job code

Write the SQL code to change the job code to 501 for the person whose personnel number is 106. After you have completed the task, examine the results, and then reset the job code to its original value.

  Granting privileges to the new user

Issue an INSERT statement to insert a new record in new user session - Login to the Oracle server using SQL Developer and write and execute the SQL command needed to create a new user with a username and password of your choosing.

  What are the responsibilities of a dba

What are the responsibilities of a DBA? If we assume that the DBA is never interested in running his or her own queries, does the DBA still need to understand query optimization? Why?

  Explain techniques for distributed data placement

Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the diagrams supporting your conclusion. Note: The graphically depicted solution is not included in the required page length.

  Create a relational database design for the data model

Create a Relational Database Design for the data model you developed for where you've added Projects and Supplies - Remember that in a database design you cannot have N:M relationships.

  How the approach proposed in the paper is different

Summarise the differences between the ETL process in the paper and that in the scenario.

  Describe the importance of using sub queries in a database

1. Extracting and interpreting data can be very valuable to an organization. Describe the importance of using sub queries in a database system. Provide at least two business case scenarios to support your response.

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