BUSI 201 Test 4 Liberty University Answers
Add a new Date/Time field to the far right side of the table. Name the field: StartDate
Add a new calculated field named EmployeeCost in the first empty column to the right of the ProviderName field. The new field should calculate the value in the Premium field multiplied by .25. Run the query to view the results.
Create a backup of the database. You do not need to change the backup location.
Create a new query in Design view using the following fields in this order: From the InsurancePlans table, add the InsuranceID, InsuranceType, SubscriptionType, and Premium fields. From the InsuranceProviders table, add the ProviderName field. Run the query.
Create a new relationship between the StaffID field in the Staff table and the Reviewer field in the Reviews table. Enforce data integrity between the two tables.
Create a new table in Datasheet view. Save it with the name: InsurancePlans
Create a new table in Design view. Name the first field: IncreaseID Make the field data type: AutoNumber Add the description: Unique IDSet the field as the primary key. Save the table with the Name: WageIncreases
Export the InsuranceOptions query to Excel, maintaining all data formatting and layouts. You do not need to change the location of the saved file or save the export steps.
Export the InsuranceOptions query to a comma-separated text file. Include field names in the export. You do not need to change the location of the saved file or save the export steps.
From Layout view, group this report by values in the ProviderName field.
From Layout view, group this report by values in the DateOfHire field. Change the grouping to group by the year instead of by quarter.
From Print Preview view, export the Staff Insurance Elections report as a PDF file. Use the suggested location and file name.
From Print Preview view, export the Staff Insurance Elections report as a Word file. Use the suggested location and file name.
Limit the query results to records where the insurance Premium is greater than 250. Run the query to view the results.
Modify the table relationships so that when a record is deleted in the Departments table, the related records in the Staff table will also be deleted.
A zipped file has been downloaded. Move all the files in the selected zipped file to the Documents folder under OneDrive.
Add a subform to the bottom of this form to display all the fields from the WageIncreases table. Accept the relationship suggested by Access, and accept the suggested name for the subform.
Add criteria to this query to return only the records where the value in the Premium field is <500 and the value in the SubscriptionType field is Family. Run the query to view the results.
Add criteria to this summary query to include only records where the value in the DepartmentName field is Management. Do not include the DepartmentName field in the query groups. Run the query.
From Design view, add a list box control to the form below the InsuranceID control. The list box control should display the following three values in this order: MedicalDentalVision Store the selected value in the InsuranceType field. The label should display: InsuranceType
From Design view, add a new label control to the Page Header section above the LastName control. Change the label text to: Last Name