William works for a nationwide real estate agency. he uses the agency's website to promote the latest homes. he uses access to store information concerning the home and excel to analyze the data. fall open houses include homes in seattle, chicago, and denver. spring open houses include tours of homes in washington,

d. c., new mexico, alaska, and montana. summer home tours include paris, rome, denmark, and australia. william wants excel to automatically refresh the connection between his excel workbook and his access database whenever the workbook is opened. he should click the refresh data when opening the file check box in the connection properties dialog box. what steps should he take to open the connection properties dialog box?

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