Answer to Question #236958 in Excel for desmond

Question

Query 1: List all of the books that are published by Prentice Hall using the LastName field of the Author table, the Title field of the Book table, and the PubName field of the Publisher table. Sort the query in ascending order according to the Title field. Save this query as Prentice Hall Books. Query

2: List all of the books where the publish date is greater than today’s date using the LastName field of the Author table, the Title and PubDate fields of the Book table, and the PubName field of the Publisher table. Sort the query in descending order according to the PubDate field. Save this query as Books not yet published. Query

3: List all of the books where the copyright year is 2010 or the publish date is less than 60 days old using the LastName field of the Author table, the Title, PubDate and Copyright fields of the Book table, and the PubName field of the Publisher table. Sort the query in descending order according to the PubDate field. Save this query as New Books. Query

Answer 1

Dear desmond, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order