Homework answers / question archive / Illustrated Access 2019 | Module 4: SAM Project 1a Global Human Resources Consultants CREATING FORMS AND REPORTS GETTING STARTED •             Open the file IL_AC19_4a_FirstLastName_1

Illustrated Access 2019 | Module 4: SAM Project 1a Global Human Resources Consultants CREATING FORMS AND REPORTS GETTING STARTED •             Open the file IL_AC19_4a_FirstLastName_1

MS Access

Share With

---

Illustrated Access 2019 | Module 4: SAM Project 1a

Global Human Resources Consultants

CREATING FORMS AND REPORTS

GETTING STARTED

•             Open the file IL_AC19_4a_FirstLastName_1.accdb, available for download from the SAM website.

•             Save the file as IL_AC19_4a_FirstLastName_2.accdb by changing the “1” to a “2”.

o             If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

•             Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.

                PROJECT STEPS

1.            As project manager, you need to be able to view records for all consultants, clients, and projects as well as prepare reports for various departments. Open the ClientControl form in Design View and perform the following tasks:

a.            Select the Balance and Total text boxes and align the left edge of the controls with the left edge of the Paid text box (Hint: Do not resize the text boxes).

b.            Resize the Paid text box to be the same size as the ClientName text box above it.

c.             Move the Close command button so that the left edge of the command button is at the 6" mark on the horizontal ruler.

d.            Add a label with the caption Human Resources to the Form Header section at the 3" mark on the horizontal ruler. 

 

Save the ClientControl form, switch to Form View as shown in Figure 1, then close the form.

                Figure 1: ClientControl Form in Form View

 

 

 

2.            Open the ConsultantData form in Design View and perform the following tasks:

a.            Add the Reside field to the form. Position the Reside text box so that the left edge of the control aligns with the left edge of the other five text boxes.

b.            Delete the Reside label.

 

Save the changes to the Consultant Data Form and close it.

3.            Open the StackedClient form in Layout View. Select the 10 controls in the Detail section of the form and apply a Stacked layout. Save the changes to the form and close it.

4.            Open the TabularProject form in Layout View. Select all the controls on the form and arrange the controls in a Tabular layout. Save the changes to the form and close it.

5.            Use the Form Wizard to create a form based on the Client table with the following options:

a.            Include all fields from the Client table in the form.

b.            Select the Columnar layout for the form.

c.             Enter ClientEntry as the form title and then open it in Layout View.

6.            With the ClientEntry form open in Layout View, right-align the text in the five labels in the Detail section. Bold the five labels in the Detail section. Save the Form and open it in Form View.

7.            Use the ClientEntry form to navigate to the record with ClientID field value 9. Change the Balance field value of this record, using $25,000 as the new value.

8.            Use the ClientEntry form to add a new record to the Client table with the field values shown in Table 1. (Hint: The Total field is a calculated field.) Close the form.

                Table 1: Field Values for New Record

 

ClientID                ClientName        Paid       Balance

16           Intrazio 25000    0

 

9.            Open the ConsultantSalary form in Design View and perform the following tasks:

a.            Delete the Human Resources label control in the Form Header.

b.            Add the StartDate field to the form then position it just below the Salary label and text box.

c.             Change the Salary label to Current Salary in the Detail section, and the ConsultantSalary label to Consultant Salary in the Form Header section by adding a space between the words.

d.            Underline the salary: label in the Form Footer section.

 

Save the ConsultantSalary form and close it.

10.          Use the Report button to create a report based on the Country table. Save the report, using CountryList as the name. With the report open in Layout View, change the Country label to Country Report in the Report Header section. Save the report.

11.          With the CountryList report still open in Layout View, update the CountryCode label, using Code as the new name, and update the CountryName label, using Name as the new name. Resize the height of the text box that counts the number of records in the left side of the Report Footer section to clearly display the count as shown in Figure 2. Save the report and close it.

                Figure 2: CountryList Report in Layout View

 

 

 

12.          Use the Report Wizard to create a report based on the Project and Consultant tables with the following options:

a.            Include the Description and Months fields from the Project table and the LastName from the Consultant table in the report.

b.            Choose to view your data by Consultant.

c.             Use LastName as the grouping field.

d.            Sort the records by Description in ascending order.

e.            Select Stepped as the layout and Portrait as the orientation.

f.             Change the title of the report, using ProjectsByConsultant as the new title, and preview it. Close the ProjectsByConsultant report.

13.          Open the ConsultantsByProject form in Layout View, open the property sheet, and perform the following tasks:

a.            Change the border style of the Description label to Transparent.

b.            Change the font size of the Global Human Resources Consultants label in the Form Header to 20. Save the ConsultantsByProject form and close it.

14.          Open the Client report in Design View and perform the following tasks:

a.            Select all of the labels in the Page Header section and group them on the ClientID field.

b.            Bold the group.

Save the Client report and close it.

15.          Open the Consultant report in Design View and apply conditional formatting to the values in the Salary text box so that if the field value is equal to 71,000, the field's font color is set to red (row 7, column 2 on the standard color palette) and the font is bold. Save the report.

16.          With the Consultant report still open in Design View, change the font color of the label in the Report Header section to dark blue (row 7, column 9 in the Standard Colors palette.) Save the Consultant report, view it in Report View to review the changes, and close the report.

17.          Open the ConsultantStartDate form in Design View and perform the following tasks:

a.            Resize the width of the form to the 6.5" mark on the horizontal ruler.

b.            Change the background color for the Consultant StartDate label in the Form Header section to Light Blue 2 (row 3, column 5 in Standard Colors palette).

c.             Change the font for the Consultant StartDate label in the Form Header section to Georgia.

d.            Use the Format Painter to copy the formatting from the Consultant ID label in the Detail section to the Start Date label in the Detail section.

 

Save the ConsultantStartDate form and close it.

18.          Open the ProjectLandscape report in Layout View and apply the Georgia font scheme from the theme fonts to this object only. Save and close the report.

19.          Open the ConsultantResides report in Layout View and perform the following tasks:

a.            Change the layout of the report to Portrait.

b.            Move the Reside column so that it appears between the ConsultantID and Lastname columns.

 

Save the ConsultantResides report and close it.

20.          Open the ClientFees form in Design View and perform the following tasks:

a.            Delete the =Date() and =Time() text boxes in the Form Header section.

b.            Remove the layout from the controls in the Detail section of the form.

c.             Apply the Office Theme to this object only.

 

Save the ClientFees form and close it.

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 SAM website to submit your completed project.