Chat with us, powered by LiveChat You are employed at Healthy Myles Fitness Center a - Writemia

You are employed at Healthy Myles Fitness Center a

You are employed at Healthy Myles Fitness Center and are in charge of consolidating the company’s records and other important information into a database. You have already set up the basic structure of the database, created relationships between tables, and created queries. You will now work with forms and reports to enter and view data.Open the frmEmployeeList form in Layout view and make the following changes:Apply the Facet theme to the frmEmployeeList form only.Change the form title to Employee List.Change the font color of the form title to Dark Green, Accent 2.Save the form, and then switch to viewing the frmEmployeeList form in Form View.In Form View, navigate to the fifth record (with the Employee ID field value 114) in the frmEmployeeList form, and then change the Employee Last field value to Summers. Navigate to the last record (with the Employee ID field value 155), and then change the Title field value to Billing Manager. Save and close the form.Use the Form Wizard to create a form based on the tblBilling table. Include all fields in the form, use the Columnar layout, and specify the title frmBillingData.Switch to Layout View, and then edit the form title in the frmBillingData form so that it appears as Billing Data (two words). Save the form.Switch to Form View, and then use the Find command to find the record with the Billing ID field value A80565 in the frmBillingData form. Change the Sessions to 8 and the Amount to $800.Using the data shown in Figure 1 below, add a new record to the frmBillingData form, and then close the form.Select the TrainerID, FirstName, and LastName fields from the tblTrainer table for the main form. Select the ClientID, StartDate, and EndDate fields from the tblBilling table. Choose the option to view the data by tblTrainer. Select the Datasheet layout for the subform. Specify the title frmTrainerBilling for the main form and frmBillingSubform for the subform.Switch to Layout View, change the title in the main form to Trainers and Billing, then use the mouse to resize the subform to approximately 4.5” wide (or wide enough to display the full EndDate column). Your form should now look like Figure 2 below.In Form View, use the Find command to find the record with the Trainer ID field value 585 in the frmTrainerBilling form, and then change the FirstName field value to Cameron. Save and close the form.Use the Report Wizard to create a report based on the tblTrainer table and the related tblBilling table, as described below: Select the TrainerID, FirstName, LastName, and Certification fields from the tblTrainer table. Select all fields from the tblBilling table except for the TrainerID field. Choose the option to view the data by tblTrainer, and do not select any additional grouping levels for the report. Sort the records in ascending order by BillingID. Select the Outline layout and Landscape orientation for the report. Specify the report title rptTrainerBilling.Switch to Layout View, and then change the report title for the rptTrainerBilling report to Trainer Billing (two words). Save and close the report.Open the rptClientBilling report in Layout View and complete the following steps:Apply the Integral theme to the rptClientBilling report only.Increase the width of the StartDate controls to 1.2′.Move the StartDate controls so that the right edge is aligned with the StartDate field title. Move the Amount controls so that the right edge is aligned with the Amount field title.Change the Sessions field title to right alignment.Scroll to the bottom of the report, and then use an arrow key to move the page number control to the right so that its right edge aligns with the right edge of the Sessions field in the report. Save the report.Open the frmEmployeeList form in Layout view and make the following changes:Apply the Facet theme to the frmEmployeeList form only.Change the form title to Employee List.Change the font color of the form title to Dark Green, Accent 2.Save the form, and then switch to viewing the frmEmployeeList form in Form View.In Form View, navigate to the fifth record (with the Employee ID field value 114) in the frmEmployeeList form, and then change the Employee Last field value to Summers. Navigate to the last record (with the Employee ID field value 155), and then change the Title field value to Billing Manager. Save and close the form.Use the Form Wizard to create a form based on the tblBilling table. Include all fields in the form, use the Columnar layout, and specify the title frmBillingData.Switch to Layout View, and then edit the form title in the frmBillingData form so that it appears as Billing Data (two words). Save the form.Switch to Form View, and then use the Find command to find the record with the Billing ID field value A80565 in the frmBillingData form. Change the Sessions to 8 and the Amount to $800.Using the data shown in Figure 1 below, add a new record to the frmBillingData form, and then close the form.Select the TrainerID, FirstName, and LastName fields from the tblTrainer table for the main form. Select the ClientID, StartDate, and EndDate fields from the tblBilling table. Choose the option to view the data by tblTrainer. Select the Datasheet layout for the subform. Specify the title frmTrainerBilling for the main form and frmBillingSubform for the subform.Switch to Layout View, change the title in the main form to Trainers and Billing, then use the mouse to resize the subform to approximately 4.5” wide (or wide enough to display the full EndDate column). Your form should now look like Figure 2 below.In Form View, use the Find command to find the record with the Trainer ID field value 585 in the frmTrainerBilling form, and then change the FirstName field value to Cameron. Save and close the form.Use the Report Wizard to create a report based on the tblTrainer table and the related tblBilling table, as described below: Select the TrainerID, FirstName, LastName, and Certification fields from the tblTrainer table. Select all fields from the tblBilling table except for the TrainerID field. Choose the option to view the data by tblTrainer, and do not select any additional grouping levels for the report. Sort the records in ascending order by BillingID. Select the Outline layout and Landscape orientation for the report. Specify the report title rptTrainerBilling.Switch to Layout View, and then change the report title for the rptTrainerBilling report to Trainer Billing (two words). Save and close the report.Open the rptClientBilling report in Layout View and complete the following steps:Apply the Integral theme to the rptClientBilling report only.Increase the width of the StartDate controls to 1.2′.Move the StartDate controls so that the right edge is aligned with the StartDate field title. Move the Amount controls so that the right edge is aligned with the Amount field title.Change the Sessions field title to right alignment.Scroll to the bottom of the report, and then use an arrow key to move the page number control to the right so that its right edge aligns with the right edge of the Sessions field in the report. Save the report. Use the Form tool to create a form based on the tblTrainer table, and then save the form as frmTrainerList. Close the frmTrainerList form. Figure 1: New Record for the frmBillingData Form 7.Use the Form Wizard to create a form containing a main form and a subform as described below: Figure 2: frmTrainerBilling Form Use conditional formatting in the rptClientBilling report to format the Sessions field values that are greater than or equal to 7 in a bold, red font, as shown in Figure 3 on the next page. Display the report in Print Preview and review its pages, and then save and close the report.1.You are employed at Healthy Myles Fitness Center and are in charge of consolidating the company’s records and other important information into a database. You have already set up the basic structure of the database, created relationships between tables, and created queries. You will now work with forms and reports to enter and view data. Use the Form tool to create a form based on the tblTrainer table, and then save the form as frmTrainerList. Close the frmTrainerList form. Figure 1: New Record for the frmBillingData Form 7.Use the Form Wizard to create a form containing a main form and a subform as described below: Figure 2: frmTrainerBilling Form Use conditional formatting in the rptClientBilling report to format the Sessions field values that are greater than or equal to 7 in a bold, red font, as shown in Figure 3 on the next page. Display the report in Print Preview and review its pages, and then save and close the report.vvv

Do you need an answer to this or any other questions?

About Writemia

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Place Order” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order