You work in the software division of Global Human Resources Consultants (GHRC), which sells modular Human Resource (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 in Layout View and complete the following:
a. Add a title.
b. Modify the title to add a space between the words Consultant and Salaries.
c. Bold the title.
d. Center-align the ID label and the data in the first column that identifies the ConsultantID data.
Save and close the ConsultantSalaries report.
|
You work in the software division of Global Human Resources Consultants (GHRC), which sells modular Human Resource (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 in Layout View and complete the following:
a. Add a title.
b. Modify the title to add a space between the words Consultant and Salaries.
c. Bold the title.
d. Center-align the ID label and the data in the first column that identifies the ConsultantID data.
Save and close the ConsultantSalaries report.
|
You work in the software division of Global Human Resources Consultants (GHRC), which sells modular Human Resource (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 in Layout View and complete the following:
a. Add a title.
b. Modify the title to add a space between the words Consultant and Salaries.
c. Bold the title.
d. Center-align the ID label and the data in the first column that identifies the ConsultantID data.
Save and close the ConsultantSalaries report.
|
Open the ClientSoftwareGrouped report in Design View, and add a grouping level on the SoftwareCode field. Save and close the report.
|
Open the ConsultantList report in Design View and complete the following:
a. Use 2 as the number of columns.
b. Use a Down, then Across layout.
Save and open the ConsultantList report in Print Preview, and then close the ConsultantList report.
|
Open the ConsultantList report in Design View and complete the following:
a. Use 2 as the number of columns.
b. Use a Down, then Across layout.
Save and open the ConsultantList report in Print Preview, and then close the ConsultantList report.
|
Open the CountryList report in Design View and complete the following:
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.
|
Open the CountryList report in Design View and complete the following:
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.
|
Open the CountryList report in Design View and complete the following:
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.
|
With the CountryList report still open in Design View, complete the following:
a. Select all controls on the report and change the font color to Automatic (Black).
b. Set the Alternate Back Color to Alternate Row for the Detail section.
Save and view the CountryList report in Print Preview as shown in Figure 1, and then close the CountryList report.
|
With the CountryList report still open in Design View, complete the following:
a. Select all controls on the report and change the font color to Automatic (Black).
b. Set the Alternate Back Color to Alternate Row for the Detail section.
Save and view the CountryList report in Print Preview as shown in Figure 1, and then close the CountryList report.
|
Create a new report in Design View using these options:
a. Apply the Record Source property 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.
Save the report with the name RevenueInfo and close it.
|
Create a new report in Design View using these options:
a. Apply the Record Source property 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.
Save the report with the name RevenueInfo and close it.
|
In the Navigation Pane, copy the ClientListing report and paste it, using ClientDetails as the name.
|
Open the ClientDetails report in Design View and complete the following:
a. Delete the two text boxes in the Page Footer section.
b. Move the ClientID label in the Page Header section and 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.
Save the ClientDetails report.
c. Use Client Details as the caption for the label in the Report Header section. If necessary, resize the label so that the caption is fully visible.
Save the ClientDetails Report.
|
Open the ClientDetails report in Design View and complete the following:
a. Delete the two text boxes in the Page Footer section.
b. Move the ClientID label in the Page Header section and 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.
Save the ClientDetails report.
c. Use Client Details as the caption for the label in the Report Header section. If necessary, resize the label so that the caption is fully visible.
Save the ClientDetails Report.
|
Open the ClientDetails report in Design View and complete the following:
a. Delete the two text boxes in the Page Footer section.
b. Move the ClientID label in the Page Header section and 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.
Save the ClientDetails report.
c. Use Client Details as the caption for the label in the Report Header section. If necessary, resize the label so that the caption is fully visible.
Save the ClientDetails Report.
|
While still working in Design View of the ClientDetails report, add a sort order to sort the records in ascending order by ClientName.
Save and preview the report, a portion of which is shown in Figure 2, and then close the ClientDetails report.
|
Use the Label Wizard to create labels for consultant files based on the Consultant table as follows:
a. Select the Avery USA 5096 product number. Use the Arial font with a font size of 12, a Bold font weight, and Automatic (1st column, 6th row in the Basic Colors palette) text color.
b. On the first line of the label, insert the LastName field, followed by a comma and a space and the FirstName field.
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 LastName.
Save the report, using ConsultantLabels as the name. Confirm that it matches Figure 3, and then save and close it. (Hint: If a message appears warning that not all information is displayed, click OK.)
|
Use the Label Wizard to create labels for consultant files based on the Consultant table as follows:
a. Select the Avery USA 5096 product number. Use the Arial font with a font size of 12, a Bold font weight, and Automatic (1st column, 6th row in the Basic Colors palette) text color.
b. On the first line of the label, insert the LastName field, followed by a comma and a space and the FirstName field.
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 LastName.
Save the report, using ConsultantLabels as the name. Confirm that it matches Figure 3, and then save and close it. (Hint: If a message appears warning that not all information is displayed, click OK.)
|
Use the Label Wizard to create labels for consultant files based on the Consultant table as follows:
a. Select the Avery USA 5096 product number. Use the Arial font with a font size of 12, a Bold font weight, and Automatic (1st column, 6th row in the Basic Colors palette) text color.
b. On the first line of the label, insert the LastName field, followed by a comma and a space and the FirstName field.
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 LastName.
Save the report, using ConsultantLabels as the name. Confirm that it matches Figure 3, and then save and close it. (Hint: If a message appears warning that not all information is displayed, click OK.)
|
Open the SoftwareComponents report in Design View and then complete the following:
a. Add page numbers to the report using the Page N of M format positioned in the left side of the Page Footer.
b. Add the date (but not the time) to the report using the Medium Date (28-Feb-19) format.
Save the SoftwareComponents report.
|
Open the SoftwareComponents report in Design View and then complete the following:
a. Add page numbers to the report using the Page N of M format positioned in the left side of the Page Footer.
b. Add the date (but not the time) to the report using the Medium Date (28-Feb-19) format.
Save the SoftwareComponents report.
|
With the SoftwareComponents report still open in Design View, complete the following:
a. Adjust the Report Footer section to be about 0.5" tall.
b. Add a text box to the right side of the Report Footer section directly below the MonthlyFee text box in the Detail section.
c. Within the text box, add an expression to sum the MonthlyFee field for the entire report.
d. Enter Total Monthly: as the caption for the new label in the Report Footer section. If necessary, resize the label so that the caption is fully visible.
Save the SoftwareComponents report.
|
With the SoftwareComponents report still open in Design View, complete the following:
a. Adjust the Report Footer section to be about 0.5" tall.
b. Add a text box to the right side of the Report Footer section directly below the MonthlyFee text box in the Detail section.
c. Within the text box, add an expression to sum the MonthlyFee field for the entire report.
d. Enter Total Monthly: as the caption for the new label in the Report Footer section. If necessary, resize the label so that the caption is fully visible.
Save the SoftwareComponents report.
|
With the SoftwareComponents report still open in Design View, complete the following:
a. Adjust the Report Footer section to be about 0.5" tall.
b. Add a text box to the right side of the Report Footer section directly below the MonthlyFee text box in the Detail section.
c. Within the text box, add an expression to sum the MonthlyFee field for the entire report.
d. Enter Total Monthly: as the caption for the new label in the Report Footer section. If necessary, resize the label so that the caption is fully visible.
Save the SoftwareComponents report.
|
With the SoftwareComponents report still open in Design View, complete the following:
a. Left-align the left edge of the new text box in the Report Footer section with the MonthlyFee text box
|