칸아카데미 SQL기초와 심화 SQL문제들을 MS Access로 변환하여(case대신에 switch 그리고 as의 alias

Insurance companies have internal controls in place to protect assets, monitor the accuracy of accounting records and encourage operational efficiencies and adherence to policies. these internal controls are generally of two types: administrative controls and accounting controls. administrative controls are the policies and procedures that guide the daily actions of employees. accounting controls are the policies and procedures that delineate authorizations of financial transactions that are done, safeguard assets, and provide reports on the company’s financial status in a reliable and timely manner. internal controls should include both preventative and detective controls. the purpose of preventative controls is to stop problems and errors before they occur. detective controls identify problems after they have occurred. preventative controls are usually more effective at reducing problems, but they also tend to be more expensive. internal controls must be flexible to adjust for changes in laws and regulations in addition to adding new products or modifying current ones. companies must also do regular analyses to ensure that the benefits of implementing the controls are worth their costs. when concerned about paying unwarranted insurance claims which type of control would be useful?

Consider a consumer who is contemplating a new automobile purchase. she has narrowed her decision down to two brands, honda accord and ford taurus. she has identified gas mileage, price, warranty, and styling to be important attributes to consider in her decision

Need with an adjusting journal entrycmc records depreciation and amortization expense annually. they do not use an accumulated amortization account. (i. e. amortization expense is recorded with a debit to amort. exp and a credit to the patent.) annual depreciation rates are 7% for buildings/equipment/furniture, no salvage. (round to the nearest whole dollar.) annual amortization rates are 10% of original cost, straight-line method, no salvage. cmc owns two patents: patent #fj101 and patent #cq510. patent #cq510 was acquired on october 1, 2016. patent #fj101 was acquired on april 1, 2018 for $119,000. the last time depreciation & amortization were recorded was december 31, 2017.before adjustment: land: 348791equpment and furniture: 332989building: 876418patents 217000