Question: Please Use Microsoft Access. I Just want a good explanation on how to do it. a. C. 5. Design the queries to do the following:

Please Use Microsoft Access. I Just want a good explanation on how to do it.Please Use Microsoft Access. I Just want a good explanation on how

a. C. 5. Design the queries to do the following: List all the employees (first name, last name, job level and hire date) working with the publisher called Algodata InfoSystems. The list must be in order ascending order of job level. If two employees have the same job level, they must be listed in ascending order by their last name. The order of the columns must be as specified above. b. List all books (title, publisher, publication date, number of authors) with 2 or more authors. List all books (title, publisher, publication date) published in 2013 where the total year to date sales from the book has exceeded $5000. d. List the authors (Id, first name, last name) that published a book before their 21st birthday. List the id, first name and title of books by all authors whose subject is 'Action'. List must be in ascending order by id and then by book title if an author has more than 1 book. The columns must be in the order specified above. f. Accept a job level and display a list of jobs (with all details) that the job level can qualify for given the minimum level required for each job. Columns of your query result must be shown in the display order specified and must also satisfy any sort order specified. e

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!