1. Provide a critical evaluation of the resources you used in completing the following 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.
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.
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. 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, create 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. • Create 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. • Create 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. Final submission should include the Access Database, Excel Spreadsheet, and a one-page narrative addressing the following items.