homework

download You work at the Riverwalk Medical Clinic, a large outpatient medical facility staffed by family physicians, specialists, nurses, and other allied health professionals. Your boss has drafted an information sheet to help seasonal allergy sufferers and asks you to edit and format it so that it is eye catching and attractive.  a. Open the file IL_WD_1-5.docx from the drive and folder where you store your Data Files, save it as IL_WD_1_AllergyInfo, then read the document to get a feel for the content. FIGURE 1-32 shows how you will format the info sheet. FIGURE 1-32 Riverwalk Medical Clinic Advice for Seasonal Allergy Sufferers b. Show the rulers in your document window if they are not already visible. c. Accept or ignore all suggested spelling and grammar changes in the document. d. Insert the Riverwalk Medical Clinic logo file Support_IL_WD_1-6.jpg at the top of the document. Change the height of the logo to 1", then position the logo in the bottom right with...

download Yesterday you interviewed for a job as the administrative assistant in the Business Department at Jericho College. You spoke with several people at the college, including Sonia Alvarado, director of human resources, whose business card is shown in FIGURE 1-33. You need to write a follow-up letter to Ms. Alvarado, thanking her for the interview and expressing your interest in the college and the position. She also asked you to send her some samples of your work as evidence of your Word skills. a. Start Word and save a new blank document as IL_WD_1_AlvaradoLetter to the location where you store your Data Files. b. Begin the letter by clicking the No Spacing button in the Styles group. You use this button to apply the No Spacing style to the document so that your document does not include extra space between paragraphs. c. Type a personal letterhead for the letter that includes your name, address, telephone number, email address, and webpage or LinkedIn address, if ...

download 1. Explore the Word program window. a. Start Word and open a new, blank document. b. Identify as many elements of the Word program window as you can without referring to the module material. c. Click the File tab, then click the Info, New, Open, Save, Save As, Print, Share, and Export commands. d. Click the Back button in Backstage view to return to the document window. e. Click each tab on the Ribbon, review the groups and buttons on each tab, then return to the Home tab. f. Point to each button on the Home tab and read its ScreenTip. g. Click the View tab and click the Ruler checkbox several times to hide and show the ruler. Show the ruler. h. Click the View buttons to view the blank document in each view, then return to Print Layout view. i. Use the Zoom slider to zoom all the way in and all the way out on the document, then return to 120%. 2. Start a document. a. In a new blank document, type Health West International at the top of the page, then ...

download Create the letter shown in FIGURE 1-34. Before beginning to type, click the No Spacing button in the Styles group on the Home tab. Type the letter before formatting the letterhead and applying the theme. To format the letterhead, change the font size of the first line of text to 40 point and apply the Gradient Fill: Blue, Accent 5, Reflection WordArt style. Change the font color of the address line to Blue, Accent 5. Add the bottom border to the letterhead. When the letterhead is formatted, change the font size of the body text to 12 point, apply the Organic theme, then change the font color of the letterhead text to Green, Accent 1. Save the document as IL_WD_1-SakuraDoksa to the location where you store your Data Files, submit the letter to your instructor, then close the document and exit Word.

download It’s important to think about how to set up proper fields for a table before working in Access. Consider the following twelve subject areas: • Contacts • Islands of the Caribbean • Members of the U.S. House of Representatives • College course offerings • Physical activities • Ancient wonders of the world • Restaurant menu • Shopping catalog items • Vehicles • Conventions • Party guest list • Movie listings a. For each subject, create a table in a single Word document named IL_AC_1_SampleTables. The table should contain four to seven columns and three rows. In the first row, enter appropriate field names that you would expect to see in a table used to manage that subject. Note the guidelines for proper field construction below. b. In the second and third rows of each table, enter two realistic records. The first subject, Contacts, is completed as an example to follow. c. Use the following guidelines as you build each table in Word: • Make sure each record represents one...

download You are working for a city to coordinate a series of community-wide preparedness activities. You have started a database to track the activities and volunteers who are attending them. a. Start Access, then open the IL_AC_1-3.accdb database from the location where you store your Data Files. Save it with the name IL_AC_1_Volunteers and then enable content if prompted. b. Open each table’s datasheet to study the number of fields and records per table. c. In a Word document named IL_AC_1_VolunteerTables, re-create the following table and fill in the blanks: d. Close all open tables, then use the Simple Query Wizard to create a query using the following fields in the following order: FirstName and LastName from the Volunteers table, and ActivityName, ActvityDate, and ActivityHours from the Activities table. Show detail records, name the query VolunteerActivity, then open it in Datasheet View. e. In the ActivityName field, change any occurrence of Shelter Fundamentals ...

download 1. Understand relational databases. a. In a Word document, enter your name and the current date. b. Using a bulleted list, identify five advantages of managing database information in Access versus using a spreadsheet. c. Write a sentence to explain how the terms field, record, table, and relational database relate to one another. d. Save the document with the name IL_AC_1_Database then close it and close Word. 2. Open and explore a database. a. Start Access. b. Open the IL_AC_1-2.accdb database from the location where you store your Data Files and save it as IL_AC_1_SupportDesk. Click Enable Content if a yellow Security Warning message appears. c. Open each of the three tables to study the data they contain. Create and complete the following table in the document you started in the previous step, IL_AC_1_Database.docx. d. Double-click the CaseListing query in the Navigation Pane to open the query. Change either occurrence of the last name of “Poole” to Fredrick ...

download Open the IL_AC_1-4.accdb database from the location where you store your Data Files and save it as IL_AC_1_CollegeCourses, then enable content if prompted. Use the Simple Query Wizard to create the query shown in FIGURE 1-23 that contains the ClassNo, Description, and Credits fields from the Classes table, and the SectionNo, MeetingDay, and Time fields from the Sections table. Name the query DepartmentOfferings.

download The CFO at Riverwalk Medical Clinic has hired you to help him analyze departmental insurance reimbursements. He also would like to see what quarterly revenues would look like with a 20% increase in quarterly reimbursements. You’ve been given a worksheet for this project that contains some but not all of the data. a. Open IL_EX_1-3.xlsx from the location where you store your Data Files, then save it as IL_EX_1_Reimbursements. b. Enter the data shown in TABLE 1-4 in the range E4:E11. c. Type your name in cell A17. d. Move the label in cell F2 to cell A15. e. Use the Clipboard to copy and paste the label in cell F3 to cell A12. f. Use the formula bar to correct the spelling error in the label in cell A6. (Hint: The correct spelling is Immunology.) g. Edit cell A8 to correct the spelling error in the label. (Hint: The correct spelling is Ophthalmology.) h. Type Quarter 1 in cell B3, then use Auto Fill to enter Quarter 2, Quarter 3, and Quarter 4 in the range C3...

download As the assistant to the Dean of STEM (science, technology, engineering, and mathematics) at West Shore Commu-nity College, it is your responsibility to review the budgets for the departments in the division and help with a bud-get forecast for the upcoming academic year. You’ve decided to use Excel formulas and functions to help with this analysis. a. Open IL_EX_1-4.xlsx from the location where you store your Data Files, then save it as IL_EX_1_Budgets. b. Move the labels in the range A6:A11 to the range A5:A10. c. Enter Total in cell A11, then use AutoSum to calculate the total 2020 expenses for all departments in cell B11. d. Enter Average in cell A12, then use the AutoSum arrow to enter a function in cell B12 that calculates the average 2020 expenses for all departments. (Hint: make sure you include only the department data.) e. Use the fill handle to copy the formulas in the range B11:B12 to the range C11:C12. f. Using cell references, enter a formula in ce...

download 1. Explore Excel. a. Start Excel. b. Open IL_EX_1-2.xlsx from the location where you store your Data Files, then save it as IL_EX_1_Travel. c. Locate the Name box, formula bar, worksheet window, cell pointer, sheet tab scrolling buttons, mode indicator, and Tell me box. 2. Enter data. a. Click cell B3, type Jan, then confirm the entry. b. Click cell D7, type 202497, then conform the entry. c. Activate cell B3, then use Auto Fill to enter the months Feb and Mar in the range C3:D3. d. Save your changes to the file. 3. Edit data. a. Use F2 to correct the spelling of Maimi in cell A6 (the correct spelling is Miami). b. Click cell C7, then use the formula bar to change the value to 188270. c. Click cell A17, then enter your name. d. Save your changes. 4. Copy and move cell data. a. Select the range G4:G6. b. Copy the selection to the Clipboard. c. Open the Clipboard task pane, then paste the selection to cell A10. d. Delete the labels in the ...

download Open IL_EX_1-5.xlsx from the location where you store your Data Files, then save it as IL_EX_1_Royalties. Complete the worksheet shown in FIGURE 1-27 using the skills you learned in this module. Use functions to calculate the values in B8:B11 and C11. The values in column C are calculated by multiplying the gross revenues in column B by the percentage in cell E2. Adjust your zoom level as necessary to match the figure. Enter your name in cell A14. Submit your work to your instructor as directed.