80.2K

Verified Solution

Link Copied!

Identify two reports each for the following frequencies

• A report you would want to run daily or weekly
• A report you would want to run monthly or quarterly
• A report you would want to run annually

For each report, state the following:

• The purpose of the report (how will it be used)
• The data you will require for the report (be specific on fields, etc) as this must relate back to your specific company.

ASSETS X EMPLOYEES X Employeeld - Last Name 0001 Viner 0002 Hendricks 0003 Barkway 0004 Martin 0005 Hanson 0006 Cairns 0007 Early 0008 MacDonald 0009 Newall 0010 Chai 0011 McNaugton 0012 Castellano 0013 Lacrois 0014 Britton 0015 Tremblay (New) FirstName - Donna Lorin Ryan Ken Sheila Yasmine Chris Rayna Alannah James Matthew Cameron Tracey Lloyd Shauna Title Phone Office Location Sales Manager 555-888-5689 Winnipeg Office Manager 555-888-5688 Winnipeg IT Manager 555-888-5683 Toronto Sales Representative 416-555-1234 Toronto Sales Representative 504-555-1233 Montreal Accountant 555-888-5682 Winnipeg Customer Relations 555-888-5681 Winnipeg Product Specialist 555-888-5684 Winnipeg Sales Representative 416-555-1235 Toronto Customer Support 555-888-5685 Winnipeg Sales Representative 504-555-1234 Montreal Sales Representative 416-555-1235 Toronto Sales Representative 555-888-5686 Winnipeg Sales Representative 504-555-1236 Montreal Marketing Assistant 555-888-5690 Winnipeg Department - Employee Status Sales Active Administration Inactive Information Technology Active Sales Active Sales Inactive Administration Active Marketing Active Sales Active Sales Inactive Administration Active Sales Active Active Sales Active Sales Active Marketing Active Sales Item Type VPN ASSETS X ASSOLID 1001 Laptop 1002 Laptop 1003 Laptop 1004 Laptop 1005 Mobile 1006 Mobile 1007 Laptop 1008 Laptop 1009 Mobile 1010 Tablet 1011 Tablet 1012 Desktop 1013 Desktop 1014 Desktop 1015 Laptop 1016 Laptop 1017 Laptop 1018 Mobile 1019 Mobile 1020 Mobile 1021 Laptop 1022 Laptop 1023 Laptop 1024 Laptop 1025 Laptop 1025 Mobile 1027 Laptop 1028 Mobile Now Description HP 3000 HP 3000 HP 3000 HP 3000 Galaxy 500 Galaxy 500 HP 4000 HP 4000 Apple iPhone 8 Apple Mini Apple Mini Dell 2030 Dell 2030 Dell 2030 HP 4000 HP 4000 HP 4000 Apple iPhone XR Apple Phone XR Apple iPhone XR IBM Thinkpad IBM Thinkpad IBM Thinkpad HP 4000 HP 4000 Apple Phone XR HP 5000 Apple iPhone 11 Issue Date Manufacturer - Decommission Date Employee 2018-05-01 HP 0001 2018-05-01 HP 0002 2018-10-01 HP 0003 2018-10-01 HP 0004 2018-10-01 Samsung 2020-01-23 0001 2018-10-01 Samsung 2020 01 23 0003 2019-01-01 HP 0005 2019-01-01 HP 0009 2019-01-01 Apple 0004 2019-03-28 Apple 0001 2019-03-28 Apple 0003 2019-05-01 Dell 0006 2019-05-01 Dell 0007 2019-05-01 Dell 0010 2019-09-15 HP 0008 2019-09-15 HP 0011 2019-12-21 HP 0012 2020-01-23 Apple 0001 2020-01-23 Apple 0003 2020-01-23 Apple 0006 2020-03-15 IBM 0006 2020-03-15 IBM 0007 2020-03-15 IBM 0010 2020-05-31 HP 0013 2020-05-31 HP 0014 2020-10-15 Apple 2021-01-15 HP 0015 2021-01-15 Apple 0015 DUO EKODOS300000OOOSSEX

Answer & Explanation Solved by verified expert

See Answer