New Perspectives Access 2019 | Module 7: SAM Critical Thinking Project 1c

Описание: New Perspectives Access 2019 | Module 7: SAM Critical Thinking Project 1c #newperspectives

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 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 modify advanced reports.

Open the ConsultantSalaries report and complete the following tasks:
a. Add a title.
b. Modify the title to read Consultant Salaries.
c. Bold the title.
d. Center-align the ID label and the ConsultantID data.

Save and close the report.
2. Open the ClientSoftwareGrouped report in Design View and add a grouping level on the SoftwareCode field. Save and close the report.
3. Open the ConsultantList report in Design View and complete the following tasks:
a. Modify the report to use two columns.
b. Use the Down, then Across layout.

Save and open the ConsultantList report in Print Preview, and then close the report.
4. Open the CountryList report and complete the following tasks:
a. Remove the control layouts from the controls in all the report sections.
b. Remove the Page Header and Page Footer sections and all controls in them.
c. Resize the Country Report label in the Report Header section so that the right edge reaches the 2" mark on the horizontal ruler.

Save the CountryList report.
5. With the CountryList report still open, complete the following tasks:
a. Change the font color for all controls in the report to Automatic (Black).
b. Modify the report to use alternate back colors for each row.

Save and view the CountryList report in Print Preview, as shown in Figure 1, and then close the report.
Figure 1: Final CountryList Report in Print Preview



6. Create a new report using the following options:
a. Set the Record Source for the report to the Revenue query.
b. Add all of the fields from the field list to the top of the Detail section of the report at about the 2" mark on the horizontal ruler.
c. Expand the Detail section to about the 5" mark on the vertical ruler.

Save the report with the name RevenueInfo and then close it.
7. Make a copy of the ClientListing report, and then use ClientDetails as the report name.
8. Open the ClientDetails report and complete the following tasks:
a. Delete the two text boxes in the Page Footer section.
b. Move the ClientID label in the Page Header section and the ClientID text box in the Detail section slightly to the right so that the right edge is at the 3" mark on the horizontal ruler.
c. Use Client Details as the label in the Report Header section. If necessary, resize the label so that the caption is fully visible.

Save the ClientDetails report.
9. While still working in the ClientDetails report, sort the records in ascending order by the ClientName field.

Save and preview the ClientDetails report, a portion of which is shown in Figure 2, and then close it.
Figure 2: Final ClientDetails Report in Print Preview



10. Create labels for consultant files based on the Consultant table as follows:
a. Select the Avery USA 5096 product number. Use a bold Arial 12-point font with the Automatic (1st column, 6th row in the Basic Colors palette) text color.
b. On the first line of the label, insert the LastName and FirstName fields separated by a comma and a space.
c. On the second line of the label, insert the ConsultantID field.
d. On the third line of the label, insert the Reside field.
e. Sort the report by the LastName field.

Save the report, using ConsultantLabels as the name. Confirm that it matches Figure 3 when viewing in Print Preview. Close the report. (Hint: If a message appears warning that not all information is displayed, click OK.)