+44 7743 307695
Dec 05, 2023

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.


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.

Recent Post

Order this Assignment now

Total: GBP120

fables template