No idea how to do this and need help please. Each table is screenshotted down below.

Directions: Your first report should display trouble tickets by user. Include the following information: Department Name, Ticket Submitted, Ticket Resolved, and Ticket Status. Set Department Name as the main grouping and sort the data by the order of when the tickets were submitted.

The second report will add summaries to this one. Use the Group and Totals options to create a report that will display a count of the tickets that each Department submits. Because the Ticket Submitted field always contains a value, use this field as the means of counting. Count Record options have been built into the database that will create this for you. This report needs a formatting upgrade. Modify the column headings to make sense to a reader who isnt familiar with them. Finally, create a copy of your work to this point to make certain your professor can see it.

> OU v File Home Create External Data Database Tools Help Fields Table Tell me what you want to do X Cut E 41 Ascending 7 Selection New 7 ! Ascending Totals Sc Replace Calibri v 11 ME E LO Copy Al Descending Advanced Save ab Spelling Go Tor View Paste Filter Refresh Find BI U Ave Ave A Format Painter 20 Remove Sort 7 Toggle Filter hos Select All X Delete - More Views Clipboard Sort & Filter Records Find Text Formatting All Tables TicketTbl X UserTbl X Ticket Tbl TicketID TicketUser - TicketDevice TicketTech - TicketSubmi - TicketResok TicketStatus Click to Add 3 1 1 1 1 1/1/2011 1/5/2010 Closed TicketTbl : Table 2 2 2 2 2/2/2011 2/6/2010 Closed UserTbl 3 3 3 3 3 3 3 3/3/2011 3/7/2010 Closed UserTbl: Table 4 4 4 4 4/4/2011 Open Dept 3 5 1 3 3 5/5/2011 Open D Deptibl: Table 6 3 2 2 2 5/5/2011 Open TechTbl 3 7 2 2 1 1 10/10/2010 10/11/2010 Closed TechTbl : Table 8 4 2 2 3/14/2011 3/24/2011 Closed DeviceTbl 9 5 3 3 3/29/2011 On hold B DeviceTbl: Table 10 6 4 4 4/6/2011 4/21/2011 Closed 11 7 5 3 4/14/2011 On hold 12 8 6 4 3/17/2011 Cancelled 13 9 7 1 4/6/2011 In process 14 10 6 2 4/1/2011 4/5/2011 Closed 15 9 5 3 5/3/2011 Cancelled 16 8 6 4 3/15/2011 3/31/2011 Closed 17 7 7 3 4/26/2011 4/28/2011 Closed 18 6 4 2 2 4/29/2011 In process 19 5 5 3 3 1 2/19/2011 2/25/2011 Closed * (New) Calibri 11 [Copy BI Ave Text Formatting File Home Create External Data Database Tools Help Fields Table Tell me what you want to do X Cut 21 E New Totals 7 L Ascending ? Selection Sc Replace Al Descending Advanced Save abc Spelling Go To View Paste Filter Refresh Find Format Painter 2 Remove Sort Y Toggle Filter All X Delete More Select Views Clipboard Sort & Filter Records Find All Tables TicketTbl X Userbl X DeptTbl X Ticket Tbl Deptid DeptName - Click to Add 1 Marketing TicketTbl : Table 2 Accounting UserTbl 3 Engineering UserTbl : Table 4 HR Dept 5 Production DeptTbl : Table (New) TechTbl 3 DE TechTbl: Table DeviceTbl DeviceTbl : Table + + Co, LECopy abc Spelling File Home Create External Data Database Tools Help Fields Table Tell me what you want to do of Cut A1 Ascending 17 Selection C New Totals Gbc Replace Calibri v 11 A Descending Advanced Save Go To View Paste Filter Refresh Find Format Painter 2 Remove Sort Y Toggle Filter BI U Arev 3 A All X Delete More Select Views Clipboard Sort & Filter Records Find Text Formatting All Tables ETicket User X Deptibl TechTbl X TechID TechName TechTitle TechEmail - TechPhoneE Office Locati - Click to Add Ticket Tbl + 1 Mike Tech mike@compar 7532 1-3 ! TicketTbl : Table 2 Nancy Tech II nancy@compa 7533 1-3 UserTbl 3 Ogbemi Sr. Tech ogbemi@com 7534 1-5 UserTbl : Table 4 Patsy Tech II patsy@compar 7535 1-4 Dept Tbl 5 Quentin Tech quent@compa 7536 1-4 DeptTbl : Table (New) TechTbl BI TechTbl : Table DeviceTbl DeviceTbl: Table + + + Record: 1 of 5 No Filter Search Datasheet View Num Lock abc Spelling HH File Home Create External Data Database Tools Help Fields Table Tell me what you want to do X Cut 7 21 Ascending ? Selection New Totals Replace Calibri 11 EEE L@ Copy A Descending Advanced o Save View Go To Paste Filter Refresh Find Format Painter BI U Ave A 20 Remove Sort Y Toggle Filter All X Delete More Select Views Clipboard Sort & Filter Records Find Text Formatting All Tables TicketTbl X UserTbl x Depttbl x TechTbl x DeviceTbl X Ticket Tbl DeviceID DevName DevLocation DevPurchDa DevPurchPri DevPropTag Click to Add 1 Router Basement 1/1/2010 $250.00 TicketTbl : Table 123456 2 Router 2nd floor, Rm 2 2/2/2010 $225.00 234567 UserTbl 3 Bridge 2nd floor, Rm 2 2/2/2010 $150.00 234568 UserTbl : Table 4 Switch 2nd floor, Rm 2 2/2/2010 $150.00 234569 Dept Tbl 3 5 Ethernet hub 1st floor rear 3/3/2010 $150.00 235790 D Deptibl: Table + 6 Server 1st floor rear 3/3/2010 $4,000.00 235791 TechTbl 7 Wi-Fi router Marketing 4/4/2010 $50.00 245877 TechTbl : Table 8 Backup storage Marketing 4/4/2010 $558.00 245878 DeviceTbl (New) DeviceTbl: Table + + Record: K 1 of 8 No Filter Search Datasheet View Num Lock BE TicketTbl X UserTbl X UserDept UserID + + 2 + 3 + 4 All Tables Ticket Tbl TicketTbl: Table UserTbl UserTbl: Table Dept Tbl I Deptibl: Table TechTbl Techtbl: Table : DeviceTbl DeviceTbl : Table : + 5 6 6 UserName v UserEmail 1 Adam adam@company.com 1 Betty betty@company.com 2 Charles chuck@company.com 2 Diane diane@company.com 3 Edward ed@company.com 3 Frances fran@company.com 4 George george@company.com 4 Hallie hallie@company.com 5 Isidore izzy @company.com 5 Jessica jess@company.com UserDOB 1/1/1981 2/2/1982 3/3/1983 4/4/1984 5/5/1985 6/6/1986 7/7/1987 8/8/1988 9/9/1979 10/10/1980 UserDOH Click to Add 1/1/2009 3/3/2009 5/5/2009 7/7/2009 9/9/2009 11/11/2009 1/1/2010 3/3/2010 5/5/2010 7/7/2010 + 7 8 + + + 9 10 (New) *