Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

why is the previews not available for this :

why is the previews not available for this :     Scenario You are a Human Resources (HR) Representative working for XYZ Imports, a small business that has recently experienced a great deal of growth and expansion. XYZ Imports has been a small company managing its own payroll system. Now that the company is experiencing significant growth, there is an immediate need to outsource the payroll to a third-party organization. The CEO has selected ADP, one of the largest payroll organizations in the United States. In order to set up the payroll with ADP, you must first provide the company with information related to each employee as mandated under the Fair Labor Standards Act (FLSA). ADP has asked to receive this information in the form of both an Excel Spreadsheet and an Access Database. Your job is to help prepare for this transition. To begin, you must first research what information is needed for each employee to be in compliance with FLSA standards. Using the Virtual Library and other industry-specific resources, locate credible sources to determine what information will be needed by ADP. A great place to start is on the ADP website: http://www.adp.com/tools-and- resources/compliance-connection/payroll-resources/record-keeping.aspx After determining what information you will need, arrange the applicable entries in Microsoft Excel. When entering your information, ensure that you are formatting the cells so that the information will transfer well into Access for the appropriate data type. Enter 25 employee records with a range of staff and hourly employees. Once the data has been entered, design a  chart on a new sheet that graphically represents a comparison of the hourly employees and salaried employees. After the information is completed in Excel, import the data into Microsoft Access as ADP has requested. Arrange the data into two tables: Personal Information and Workplace Information. Important Note: The employees names (first and last) need to appear in both tables. • Join the two (2) tables based on the Last Name field with referential integrity enforced. • Perform a simple query based on the two (2) tables using any criteria you feel appropriate. • design a  parameter query based on the two (2) tables using any criteria you feel applicable. • Produce a form based on the records in the Personal Information table. Select a form design you believe represents the data in the most professional manner. •design a form based on the records in the Workplace table. Use a different layout and design for the form than the one you utilized in your Personal Information form. • Generate a report based on the simple query you created. Your final submission should include the Access Database, Excel Spreadsheet, and a one page narrative addressing the following items: 1. Provide a critical evaluation of the resources you used in completing this portfolio project. 2. Even though an organization may not use Microsoft Access specifically, most organization's today use some type of database driven technology. Identify how today businesses utilize databases. Support your claims with research following guidelines. 3. Describe what knowledge and skills you believe today's employers are looking for as it relates to the use of spreadsheet and database software. 4. Explain how you believe these technologies can improve productivity in the workplace. 

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question