Create simple query from the employees table including name

Assignment Help Computer Engineering

Reference no: EM133586709

Assignment: Creating Database Access

Due to the increasing amount of employee discipline for technology violations, you created a Microsoft Excel workbook to use for tracking employees and their Netiquette violations in your department. Your boss loves it! She has pitched the idea to the company President that this system should be used across all departments company-wide. You feel this task can better be accomplished using Microsoft Access, as the company has several hundred employees.

Instructions

Import the Data

A. Create a new blank Access database.

B. Save the Access database as "Violations_MEID.accdb." Note: Replace MEID with your MEID number.

C. Import the Violations-Import.xlsx Excel spreadsheet as external data.

D. Be sure to check the First Row Contains Column Headings. Let Access add the Primary Key. Name the new table Employees. Once you finish your import, open the Employees table to verify your data has imported correctly and is sorted in ascending order by Name.

E. Make the following field property changes: Name: Change the field size to 50. Note: Increase the field size if needed to match the longest Name you created and entered.

F. Repeat the above process for Position.

G. Length of Employment: Change the caption to 'Months of Employment'.

H. Save the design changes.

I. Choose yes if you receive the "Some data may be lost" warning.

Create a Form

A. Create a new form with a title of Employee Violation and input fields for each of your six data points.

1. Adjust the data field sizes so they all fit on the page.

2. Apply a theme of your choice to the form for visual interest.

3. Save the form as Employee Violations.

B. Go back into Design Mode for the Form

1. Remove the Department field.

2. Create a new Drop Down object where you will type in the choices for the departments. Bind the drop down to the Department field. (HINT: You should type in all departments that exist in your data).

C. Verify your new Employee Violations form works by entering a new violation record using your instructor's name, position of "Supervisor" and 36 months of employment. You may choose the data for the other fields.

Create a Query

A. Create a simple query from the Employees Table including the Name, Department, Financial Impact, and Nbr of Incidences. Title the query Employees by Violation.

1. Sort by Financial Impact descending.

2. Create a new expression within the Query called "Per Impact Cost" that divides the Financial Impact by the Nbr of Incidences. Format this new field as Currency.

3. Run the query to ensure that the calculated field was created correctly.

4. Close and Save the query.

Create a Report

A. Create a new report using your Employees by Violation query. (Hint: Use the Report Wizard)

1. Include all fields from the query on the report.

2. Group the report by Department.

3. Sort the report by Name.

4. Change the report title to Employees by Department and ensure your fields fit within the report page borders.

5. Apply a theme of your choice to the report and save the report.

6. Create an embedded macro within the Report that displays a reminder box each time it is closed, the box should display "Be sure to send reports to your supervisor weekly!"

7. Close and save the report.

8. Reopen the report and then close it again to ensure that your macro runs and displays the message box as intended.

Reference no: EM133586709

Questions Cloud

Explain the effect of implementing the topics in the domains : Each bullet point should contain sub-bullet point in which you use your own words to fully explain the effect of implementing the topics in specified domains.

What are some of the criticisms noted about the social : What are some of the criticisms noted about the social gerontological and thanatological models when applied to athletic transitions (specifically athletic

Explain how both cultural awareness and cultural competence : Explain how both cultural awareness and cultural competence help promote cultural safety when working with Aboriginal and Torres Strait Islander clients.

What treatment/service should the recreation therapist : Recognizing the importance of healthy leisure participation on health, what treatment/service should the recreation therapist provide?

Create simple query from the employees table including name : Create a simple query from the Employees Table including the Name, Department, Financial Impact, and Nbr of Incidences. Title the query Employees by Violation.

What do you think, caused you to react differently : Describe a situation or event in your life in which youreacted emotionally in a way that was differentthan someone else who experienced the SAMEevent.

How are you going to tell the person knowing that you are : How are you going to tell the person knowing that you are from France and they are from China? Justify your answer.

Why is the language we use so important in all : Why is the language we use so important in all of our interactions, but perhaps most critically so when dealing with crisis situations?

Develop different demand forecast models : Outline how the dataset, visualisations and forecasts could be improved and Describe how a retail organisation could use the forecast for its operation

User Account

All Pages