Скачать или смотреть New Perspectives Access 365 | Module 1: End of Module Project 2 | Deerfield Insurance Group

New Perspectives Access 365 | Module 1: End of Module Project 2 | Deerfield Insurance Group

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,

Whatsapp Contact Link:
https://api.whatsapp.com/message/4B6N...

Whatsapp Number:
+919116641093
+918005564456

Gmail Id:
[email protected]

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English.


PROJECT STEPS
1. You are a project assistant for Deerfield Insurance Group, a company that provides auto, property, and life insurance to customers in the United States. Deerfield offers training to employees in areas ranging from claims and customer care to data analytics and information technology. You are developing an Access database application to help manage the training programs.

Open the Employees table in Datasheet View and add a new record with an ID value of 99900, FirstName value of Liang, LastName value of Cho, and a DOB value of 6/15/2002. Leave the Dept field blank; and then close the table.
2. In the Navigation pane, rename the Employees form using EmployeeEntry as the new form name so the form is not confused with the Employees table.
3. Create a new query using the Simple Query Wizard to list employees by name. Choose the ID, FirstName, and LastName fields from the Employees table. Title the new query EmployeeList, open the query to view information, a portion of which is shown in Figure 1, and then close it.
Figure 1: EmployeeList Query in Datasheet View



4. Create a new form with the Form Wizard to use for entering employee information. Choose the ID, FirstName, and LastName fields in the Employees table. Choose a Columnar layout. Title the form EmployeeInfo, open the form to view information as shown in Figure 2, and then close it.
Figure 2: EmployeeInfo Form in Form View



5. Create a new report using the Report Wizard to list employees in alphabetic order by their names. Choose the ID, FirstName, and LastName fields from the Employees table. Do not add any grouping levels. Sort the records in ascending order by LastName and then in ascending order by FirstName. Use a Tabular layout and a Portrait orientation. Use EmployeeName as the title of the report, preview the report, a portion of which is shown in Figure 3, and then close it.
Figure 3: EmployeeName Report in Print Preview



6. Create a table in Design View to store data about training courses. Add a field named CourseID with an AutoNumber data type, CourseTitle with a Short Text data type, and CourseStartDate with a Date/Time data type. Save the table with the name Courses, do not create a primary key field, and then close the table.
7. In Datasheet View of the Employees table, correct employee data by deleting the record for ID 12268 (Eddie Dent 4/7/1997) and modifying the FirstName value for the record with ID 12468 (Francis Cox 3/9/1990), using Fatima as the new value.
8. Switch the Employees table to Design View to make the data more comprehensive and easy to use. Add a field named StartDate with a Date/Time data type, add a field named Email with a Hyperlink data type, and add a field named Reimbursement with a Currency data type. Rename the DOB field to DateOfBirth, rename the Dept field to Department, and then save and close the Employees table.
Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the website to submit your completed project.