Database – FormsIn this project, you continue working with Robert Iko, the information manager for MovinOn. Robert asks you to begin buildingforms that let users view and enter data. He suggests that you start by building some simple forms that will be used for enteringdata into the customers, drivers, employees, trucks, and warehouses tables. He also needs a few more sophisticated forms thatyou can base on queries or multiple tables. Complete the following:1. Open the MovinOn.accdb database.2. Robert states that he wants to have simple data-entry forms for each of the following tables: customers(frm02_CustomerData), drivers (frm02_DriverData), employees (frm02_EmployeeData), vehicles (frm02_VehicleData),and warehouses (frm02_WarehouseData). Create those forms and save them in the database using appropriate form names.As you create the forms, consider the design and layout of the form. Make selections that you feel are most appropriate forthis application.3. Open each form and view it from the perspective of the user. As you observe the form, make decisions as to what fieldsneed to be rearranged, sized, aligned, and so on. You might even decide that a particular field doesn’t need to be on thedata-entry form. For example, when you are entering a customer’s records, would you need the balance field for thatcustomer? Be sure each form is attractive.4. While you have been working, Robert located the logo for MovinOn (MovinOn-logo.jpg located on Blackboard). He asksyou to include the logo as well as a title on each of your forms, and continue including them on all forms you create in thefuture.5. When Robert reviews the employee data form, he notices a modification that would improve the look of the form. Robertthinks it would look better to remove the comments field from the form and replace it with a button that will bring up aseparate form where the user can record notes about the employee. The form should display the employees name as Last,First in a single text box along with the comments field. The form does not need to contain the company logo, but it shouldgive the user the instruction to enter notes about the employee. Robert cautions you that the user should not be able tonavigate this form and should not be able to change the name of the employee from the form. Name this formfrm05_EmployeeList6. The human resources department has asked that you create a form with which they can view the warehouses and theemployees who work in each warehouse. This form is not to be used for data entry, rather the HR department will use it toview employee assignments and review the salaries by warehouse. Robert has assigned you to create this form. In the mainform, Robert asks that you place the pertinent data from the warehouse table. In this case, you do not need to add all thefields from the table. In the subform, Robert asks that you place data from the employees table that shows the employeesfor each warehouse, their position title, and what they are paid. (Note: Remember that some of the employees are paid asalary and some are paid an hourly rate. For this form, you will need both fields included.) As always, check your workcarefully and make any adjustments you feel are necessary. Name this form frm06_WarehouseAndEmployees.7. When you present the form to Robert, he states that human resources may want to add employees from this form; hesuggested that you add a command button that will open the form used for entering new employees. You should alreadyhave a form for entering employees. Create the necessary command button, making sure that it properly opens theemployees form.8. Robert tells you that the human resources department has made another request. As they reviewed employee data, theynoticed that employee reviews have not been recorded in the database. Prior to the creation of this database, employeereviews were done on paper and stored in a file cabinet. Human resources plans to record their reviews directly into thedatabase. They have requested a form they can use to enter the results of their employee review. The information will berecorded in the Review memo field with a free format (that is, the HR representative who does the review will simply writenotes into this memo field). Reviews are done every three years. Your form, then, should display only those employees whohave been employed more than three years. Create a query that will limit the data to employees who fit this specification,and then create a form that will properly display the employee data (all fields). Name the formfrm08_Employee3YearReviews, and use a similar name for the corresponding query.Database – FormsIn this project, you continue working with Robert Iko, the information manager for MovinOn. Robert asks you to begin buildingforms that let users view and enter data. He suggests that you start by building some simple forms that will be used for enteringdata into the customers, drivers, employees, trucks, and warehouses tables. He also needs a few more sophisticated forms thatyou can base on queries or multiple tables. Complete the following:1. Open the MovinOn.accdb database.2. Robert states that he wants to have simple data-entry forms for each of the following tables: customers(frm02_CustomerData), drivers (frm02_DriverData), employees (frm02_EmployeeData), vehicles (frm02_VehicleData),and warehouses (frm02_WarehouseData). Create those forms and save them in the database using appropriate form names.As you create the forms, consider the design and layout of the form. Make selections that you feel are most appropriate forthis application.3. Open each form and view it from the perspective of the user. As you observe the form, make decisions as to what fieldsneed to be rearranged, sized, aligned, and so on. You might even decide that a particular field doesn’t need to be on thedata-entry form. For example, when you are entering a customer’s records, would you need the balance field for thatcustomer? Be sure each form is attractive.4. While you have been working, Robert located the logo for MovinOn (MovinOn-logo.jpg located on Blackboard). He asksyou to include the logo as well as a title on each of your forms, and continue including them on all forms you create in thefuture.5. When Robert reviews the employee data form, he notices a modification that would improve the look of the form. Robertthinks it would look better to remove the comments field from the form and replace it with a button that will bring up aseparate form where the user can record notes about the employee. The form should display the employees name as Last,First in a single text box along with the comments field. The form does not need to contain the company logo, but it shouldgive the user the instruction to enter notes about the employee. Robert cautions you that the user should not be able tonavigate this form and should not be able to change the name of the employee from the form. Name this formfrm05_EmployeeList6. The human resources department has asked that you create a form with which they can view the warehouses and theemployees who work in each warehouse. This form is not to be used for data entry, rather the HR department will use it toview employee assignments and review the salaries by warehouse. Robert has assigned you to create this form. In the mainform, Robert asks that you place the pertinent data from the warehouse table. In this case, you do not need to add all thefields from the table. In the subform, Robert asks that you place data from the employees table that shows the employeesfor each warehouse, their position title, and what they are paid. (Note: Remember that some of the employees are paid asalary and some are paid an hourly rate. For this form, you will need both fields included.) As always, check your workcarefully and make any adjustments you feel are necessary. Name this form frm06_WarehouseAndEmployees.7. When you present the form to Robert, he states that human resources may want to add employees from this form; hesuggested that you add a command button that will open the form used for entering new employees. You should alreadyhave a form for entering employees. Create the necessary command button, making sure that it properly opens theemployees form.8. Robert tells you that the human resources department has made another request. As they reviewed employee data, theynoticed that employee reviews have not been recorded in the database. Prior to the creation of this database, employeereviews were done on paper and stored in a file cabinet. Human resources plans to record their reviews directly into thedatabase. They have requested a form they can use to enter the results of their employee review. The information will berecorded in the Review memo field with a free format (that is, the HR representative who does the review will simply writenotes into this memo field). Reviews are done every three years. Your form, then, should display only those employees whohave been employed more than three years. Create a query that will limit the data to employees who fit this specification,and then create a form that will properly display the employee data (all fields). Name the formfrm08_Employee3YearReviews, and use a similar name for the corresponding query.
We Write Essays for Students
Tell us about your assignment and we will find the best writer for your paper
Get Help Now!The post Database – FormsIn this project, you continue working with Robert Iko, the infor appeared first on Infinite Essays.
Welcome to originalessaywriters.com, our friendly and experienced essay writers are available 24/7 to complete all your assignments. We offer high-quality academic essays written from scratch to guarantee top grades to all students. All our papers are 100% plagiarism-free and come with a plagiarism report, upon request
Tell Us “Write My Essay for Me” and Relax! You will get an original essay well before your submission deadline.
