For this assignment there are 2 deliverables. The first is the group deliverable of a PowerPoint presentation and the second is the individual deliverable of a Microsoft Access database.Group Assignment Details (100 points):In collaboration with your team develop a PowerPoint presentation of 6-8 slides that explains how a specific small powerful portable computer that you can find available for purchase on the Internet can be fully leveraged by a corporate Sales and Marketing Team in pursuit of its business objectives.In your presentation address the following: What specific computer by manufacturer and model did you select for this assignment? What are some of the specific functionalities this computer offers to users? What are some of the logical objectives of a typical Corporate Sales and Marketing team?How can some of the specific functionalities provided by the computer you selected help a Corporate Sales and Marketing team achieve its objectives?Demonstrate your ability to use the PowerPoint Speaker Notes function and graphics in your presentation. Ensure your presentation includes Agenda and Summary slides.
Submit a single file for the team to Group Submissions within the Unit 2 Group Project Submissions area.Human Resource DatabasesDatabase Scenario:The Environmental Expert is a locally owned business that provides training to small businesses regarding environmental regulations that may affect them It has a staff of 8 people. Up until this point it has been using paper-based records to keep track of customers who come in to sell used music; realizing this system is very outdated and problematic the store has called you and asked you to create a simple Microsoft Excel workbook so it can keep track of both customers selling music and its employees.Individual Assignment Details (100 points):Each individual should create an create an Excel workbook that includes 2 different tables: an employee table and a customer table. Each table must appear on a different tab in the Excel workbook.
Field titles for the employee table should be as follows: Employee ID numberFirst nameLast nameAddressDate of hireDate of birthSocial security numberHourly wage Field titles for the customer table should be the following: Customer ID numberFirst nameLast nameAddressPhone numberNumber of items sold to store For the employee table enter 8 hypothetical employees into the tableFor the customer table enter 10 hypothetical customers into the tableAppropriately title each submit a single Excel file to the Individual Submissions within the Unit 2 Group Project Submissions area.