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 work with different form and report controls. You will also create a split form.

Create a split form from the Consultant table. Save the form with the name ConsultantSplit as shown in Figure 1, and then close it.

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 work with different form and report controls. You will also create a split form.

Create a split form from the Consultant table. Save the form with the name ConsultantSplit as shown in Figure 1, and then close it.

Modify the ClientEntry form in Form Design View by completing the following:

a. Change the Record Source for the form to the ClientSortedByName query.
b. Change the tab order so that the ClientID field is in the first position in the Detail section.

Save the ClientEntry form.

Modify the ClientEntry form in Form Design View by completing the following:

a. Change the Record Source for the form to the ClientSortedByName query.
b. Change the tab order so that the ClientID field is in the first position in the Detail section.

Save the ClientEntry form.

With the ClientEntry form still open in Form Design View, notice that the records are now sorted by Client Name. Use the Combo Box Wizard to add a combo box using the following instructions:

a. Add the new combo box below the existing ProjectStart text box at approximately the 2" mark on the horizontal ruler.
b. Get the values for the combo box from another table.
c. Select the ConsultantID, FirstName, and LastName fields from the Consultant table for the combo box.
d. Sort the records by the LastName field in Ascending order.
e. Hide the key field, and do not adjust column widths.
f. Store the value in the ConsultantID field.
g. Enter Consultant as the label for the combo box.
h. Switch to Form View.
i. Use the new combo box to select Sharilyn Sipes as the Consultant for the first record (ClientID 15 Ainyx Steel).

Save and close the ClientEntry form.

With the ClientEntry form still open in Form Design View, notice that the records are now sorted by Client Name. Use the Combo Box Wizard to add a combo box using the following instructions:

a. Add the new combo box below the existing ProjectStart text box at approximately the 2" mark on the horizontal ruler.
b. Get the values for the combo box from another table.
c. Select the ConsultantID, FirstName, and LastName fields from the Consultant table for the combo box.
d. Sort the records by the LastName field in Ascending order.
e. Hide the key field, and do not adjust column widths.
f. Store the value in the ConsultantID field.
g. Enter Consultant as the label for the combo box.
h. Switch to Form View.
i. Use the new combo box to select Sharilyn Sipes as the Consultant for the first record (ClientID 15 Ainyx Steel).

Save and close the ClientEntry form.

With the ClientEntry form still open in Form Design View, notice that the records are now sorted by Client Name. Use the Combo Box Wizard to add a combo box using the following instructions:

a. Add the new combo box below the existing ProjectStart text box at approximately the 2" mark on the horizontal ruler.
b. Get the values for the combo box from another table.
c. Select the ConsultantID, FirstName, and LastName fields from the Consultant table for the combo box.
d. Sort the records by the LastName field in Ascending order.
e. Hide the key field, and do not adjust column widths.
f. Store the value in the ConsultantID field.
g. Enter Consultant as the label for the combo box.
h. Switch to Form View.
i. Use the new combo box to select Sharilyn Sipes as the Consultant for the first record (ClientID 15 Ainyx Steel).

Save and close the ClientEntry form.

With the ClientEntry form still open in Form Design View, notice that the records are now sorted by Client Name. Use the Combo Box Wizard to add a combo box using the following instructions:

a. Add the new combo box below the existing ProjectStart text box at approximately the 2" mark on the horizontal ruler.
b. Get the values for the combo box from another table.
c. Select the ConsultantID, FirstName, and LastName fields from the Consultant table for the combo box.
d. Sort the records by the LastName field in Ascending order.
e. Hide the key field, and do not adjust column widths.
f. Store the value in the ConsultantID field.
g. Enter Consultant as the label for the combo box.
h. Switch to Form View.
i. Use the new combo box to select Sharilyn Sipes as the Consultant for the first record (ClientID 15 Ainyx Steel).

Save and close the ClientEntry form.

With the ClientEntry form still open in Form Design View, notice that the records are now sorted by Client Name. Use the Combo Box Wizard to add a combo box using the following instructions:

a. Add the new combo box below the existing ProjectStart text box at approximately the 2" mark on the horizontal ruler.
b. Get the values for the combo box from another table.
c. Select the ConsultantID, FirstName, and LastName fields from the Consultant table for the combo box.
d. Sort the records by the LastName field in Ascending order.
e. Hide the key field, and do not adjust column widths.
f. Store the value in the ConsultantID field.
g. Enter Consultant as the label for the combo box.
h. Switch to Form View.
i. Use the new combo box to select Sharilyn Sipes as the Consultant for the first record (ClientID 15 Ainyx Steel).

Save and close the ClientEntry form.

Modify the ConsultantSalary form in Form Design View by completing the following:

a. Add a check box control below the Current Salary text box and at approximately the 1.5" mark on the horizontal ruler.
b. Modify the Control Source property of the check box to the ContractEmployee field.
c. Use Contract Employee? as the Caption of the accompany label. (Hint: If necessary, resize the label to make the caption fully visible.)

Save and view the form in Form View as shown in Figure 2, and then close the ConsultantSalary form.

Modify the ConsultantSalary form in Form Design View by completing the following:

a. Add a check box control below the Current Salary text box and at approximately the 1.5" mark on the horizontal ruler.
b. Modify the Control Source property of the check box to the ContractEmployee field.
c. Use Contract Employee? as the Caption of the accompany label. (Hint: If necessary, resize the label to make the caption fully visible.)

Save and view the form in Form View as shown in Figure 2, and then close the ConsultantSalary form.

Modify the ConsultantSalary form in Form Design View by completing the following:

a. Add a check box control below the Current Salary text box and at approximately the 1.5" mark on the horizontal ruler.
b. Modify the Control Source property of the check box to the ContractEmployee field.
c. Use Contract Employee? as the Caption of the accompany label. (Hint: If necessary, resize the label to make the caption fully visible.)

Save and view the form in Form View as shown in Figure 2, and then close the ConsultantSalary form.

Modify the CountryEntry form in Form Design View by completing the following:

a. Select the four controls in the Detail section and apply a Stacked Layout to them.
b. Expand the Detail section to be about 3" tall.
c. Use the Subform Wizard to create a subform control using all of the fields from the Consultant table.
d. Show Consultant for each record in Country using CountryCode.
e. Use ConsultantsByCountry to name the subform
f. Position the subform just below the Country Name label at approximately the 0.5" mark on the horizontal ruler.
g. Save and view the CountryEntry form in Form View, and then navigate to the third record for Canada as shown in Figure 3.

Close the CountryEntry form.

Modify the CountryEntry form in Form Design View by completing the following:

a. Select the four controls in the Detail section and apply a Stacked Layout to them.
b. Expand the Detail section to be about 3" tall.
c. Use the Subform Wizard to create a subform control using all of the fields from the Consultant table.
d. Show Consultant for each record in Country using CountryCode.
e. Use ConsultantsByCountry to name the subform
f. Position the subform just below the Country Name label at approximately the 0.5" mark on the horizontal ruler.
g. Save and view the CountryEntry form in Form View, and then navigate to the third record for Canada as shown in Figure 3.

Close the CountryEntry form.

Modify the CountryEntry form in Form Design View by completing the following:

a. Select the four controls in the Detail section and apply a Stacked Layout to them.
b. Expand the Detail section to be about 3" tall.
c. Use the Subform Wizard to create a subform control using all of the fields from the Consultant table.
d. Show Consultant for each record in Country using CountryCode.
e. Use ConsultantsByCountry to name the subform
f. Position the subform just below the Country Name label at approximately the 0.5" mark on the horizontal ruler.
g. Save and view the CountryEntry form in Form View, and then navigate to the third record for Canada as shown in Figure 3.

Close the CountryEntry form.

Modify the CountryEntry form in Form Design View by completing the following:

a. Select the four controls in the Detail section and apply a Stacked Layout to them.
b. Expand the Detail section to be about 3" tall.
c. Use the Subform Wizard to create a subform control using all of the fields from the Consultant table.
d. Show Consultant for each record in Country using CountryCode.
e. Use ConsultantsByCountry to name the subform
f. Position the subform just below the Country Name label at approximately the 0.5" mark on the horizontal ruler.
g. Save and view the CountryEntry form in Form View, and then navigate to the third record for Canada as shown in Figure 3.

Close the CountryEntry form.

Modify the CountryEntry form in Form Design View by completing the following:

a. Select the four controls in the Detail section and apply a Stacked Layout to them.
b. Expand the Detail section to be about 3" tall.
c. Use the Subform Wizard to create a subform control using all of the fields from the Consultant table.
d. Show Consultant for each record in Country using CountryCode.
e. Use ConsultantsByCountry to name the subform
f. Position the subform just below the Country Name label at approximately the 0.5" mark on the horizontal ruler.
g. Save and view the CountryEntry form in Form View, and then navigate to the third record for Canada as shown in Figure 3.

Close the CountryEntry form.

Modify the CountryEntry form in Form Design View by completing the following:

a. Select the four controls in the Detail section and apply a Stacked Layout to them.
b. Expand the Detail section to be about 3" tall.
c. Use the Subform Wizard to create a subform control using all of the fields from the Consultant table.
d. Show Consultant for each record in Country using CountryCode.
e. Use ConsultantsByCountry to name the subform
f. Position the subform just below the Country Name label at approximately the 0.5" mark on the horizontal ruler.
g. Save and view the CountryEntry form in Form View, and then navigate to the third record for Canada as shown in Figure 3.

Close the CountryEntry form.

Modify the SoftwareComponents form in Design View by completing the following:

a. Add a new text box to the form and position it just below the Installation Fee label and text box at approximately the 1.5" mark on the horizontal ruler.
b. Use Monthly Fee as the Caption for the accompanying label. (Hint: If necessary, resize the label to make the caption fully visible.)
c. Use MonthlyFee as the Control Source property for the text box.

Save the SoftwareComponents form.

Modify the SoftwareComponents form in Design View by completing the following:

a. Add a new text box to the form and position it just below the Installation Fee label and text box at approximately the 1.5" mark on the horizontal ruler.
b. Use Monthly Fee as the Caption for the accompanying label. (Hint: If necessary, resize the label to make the caption fully visible.)
c. Use MonthlyFee as the Control Source property for the text box.

Save the SoftwareComponents form.

Modify the SoftwareComponents form in Design View by completing the following:

a. Add a new text box to the form and position it just below the Installation Fee label and text box at app