Скачать или смотреть New Perspectives Access 2019 | Module 8 SAM Critical Thinking Project 1c | Global Human Resources

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

https://wa.me/message/PPXGSJS2TLWUA1

Whatsapp Contact Number:
+91 8114420233

Email ID:
[email protected]

PROJECT STEPS
1. You work in the software division of Global Human Resources Consultants (GHRC), which sells modular human resources (HR) software to large international companies. For high-level planning purposes, you have created an Access database to track new clients, the HR software modules they have purchased, and the lead consultant for each installation. In this project, you will build charts and objects using Application Parts. You will also import and export data using HTML and XML file formats.

Open the SoftwareComponents form and complete the following tasks:
a. Add a chart to the left side of the Form Footer section.
b. Use the SoftwareCode and InstallationFee fields from the Revenue query in the chart.
c. Create a Column Chart.
d. Use the sum of the InstallationFee field as the chart data. Use the SoftwareCode field as the axis for the chart.
e. Do not link the form and chart fields.
f. Use Installation Revenue for the chart title, and do not display a legend.
g. Resize the chart to be about 6" wide and about 3" tall.

Save and display the SoftwareComponents form in Form View, as shown in Figure 1, and then close it.
Figure 1: Final SoftwareComponents Form in Form View

2. Open the Revenue report and complete the following tasks:
a. Add a chart to the left side of the Report Footer section.
b. Use the SoftwareCode and MonthlyFee fields from the Revenue query in the chart.
c. Create a 3D Column Chart.
d. Use the SoftwareCode field as the axis for the chart, and use the sum of the MonthlyFee field as the chart data.
e. Do not link the report and chart fields.
f. Use Total Monthly Fees for the chart title, and do not display a legend.
g. Resize the chart to be about 7" wide and 3" tall, and then save the Revenue report.
3. While still in the Revenue report, in the Report Footer section, change the chart's chart type from 3D Column Chart to Column Chart.

Save the Revenue report, display it in Print Preview, navigate to the last page of the report, as shown in Figure 2, and then close the Revenue report.
Figure 2: Last Page of Final Revenue Report in Print Preview

4. Use Application Parts to create a Contacts table. The Contacts table should not have a relationship to any other table in the database.
5. Use Application Parts to create an Issues table using the following instructions:
a. One record in the Client table may be linked to many records in the Issues table.
b. Use the ClientID field in the Client table, do not sort the field, name the lookup column Client, and do not allow multiple values.
6. Import the Support_AC19_CT8c_States.csv file using the following instructions:
a. Specify a comma delimited format.
b. The first row should contain field names.
c. Do not modify the fields; accept the default field options.
d. Choose StateAbbrev as the primary key field.
e. Use StateProv as the new table name.
f. Do not save the import steps.

The StateProv table should have 64 records.
7. Import the Support_AC19_CT8c_NewConsultants.csv file, and then append the records into the existing Consultant table using the following instructions:
a. Specify a comma delimited format.
b. The first row should contain field names.
c. Do not save the import steps.

The Consultant table should now have 44 records.
8. Import the Support_AC19_CT8c_Europe.xml file as a new Access table using the following instructions:
a. Import both the structure and the data.
b. Do not save the import steps.

The Europe table should have 47 records.
9. Export the Client table as an HTML document using the following instructions:
a. Do not include formatting and layout.
b. Save the export steps with the name Export-Client to HTML, and do not include a description.
10. Export the ConsultantList report as an HTML document using the following instructions:
a. Do not open the file after the export is complete.
b. Do not use an HTML template, but do use default encoding.
c. Save the export steps with the name Export-ConsultantList to HTML, and do not include

#samcriticalthinkingproject1c #samprojects #cengageassignments #NP_AC19_8c #NP_ACCESS #access_assignments #access_sam_projects #Module8SamProjectc #global_human_resources #new_perspectives_access #NP_AC19_8c_FirstLastName_1.accdb #NP_AC19_8c_FirstLastName_2.accdb