MS Access Assignment

Project Background: Irrigation Equipment Specialists employs 100 employees who specialize in purchasing parts and supplies (inbound logistics), shipping products to customers (outbound logistics), order fulfillment (sales and marketing), product support (service), and the administrative functions of information technology infrastructure / systems development, planning, research and development,  human resources, and financial management.   IES’s management recognizes that its employees have different health care needs, and thus, provides them with a flexible benefits plan.  For medical insurance, an employee must enroll with either a preferred provider organization (PPO) or a health maintenance organization (HMO). IES currently pays the monthly medical premiums for its employees. However, if an employee enrolls in a dental or vision plan, the employee must pay a small monthly premium for the optional plan. An employee may carry, medical, dental, and/or vision coverage for one or more o