1. The Scranton table contains information about Dunder Mifflin employees from the Scranton, PA office. Regional Manager Michael Scott would like to have a record of all full-time employees that were hired before 2004. Create and run an action query that will create a table of all full-time employees that were hired before 2004. Use all fields in the Scranton table. The table that this query makes should be named ScrantonBefore2004 (Be sure to run this query and verify that the new table exists). Save this query as: Query1. 2. For this query, use the Scranton table again. Dunder Mifflin has decided to reward all full-time employees with a bonus for their outstanding performance last quarter. To accomplish this, create and run an update query that will update the BonusAmt field to be 3% of their salary. Save this query as: Query2. Select queries-you can complete these in any order 3. Executives at Dunder Mifflin have requested a mailing list of all of their sales representatives from the NE region who were hired in 2003 or later and all of their full-time sales representatives from the MW region who were hired in 2005 or 2006. Please list EmployeeID, FirstName, LastName, Address, City, State, and ZipCode. Sort in ascending order by LastName and then by FirstName. Save this query as: Query3. 4. Dunder Mifflin executives would like to know the number of orders placed in the third quarter of 2008. Create a query with a new field named Qtr3Orders that will calculate the total number of orders placed during that time. Save this query as: Query4