Module 2 Building Tables and Relationships - Independent Challenge 1

As the manager of Riverwalk, a multi-specialty health clinic, you have created a database to manage the schedules that connect each healthcare provider with the nurses that provider needs to efficiently handle patient visits. In this exercise, you create the primary keys and relationships required to create a relational database.
a. Start Access. Open the IL_AC_2-3.accdb database from the location where you store your Data Files and save it as IL_AC_2_Riverwalk. Click Enable Content if a yellow Security Warning message appears.
b. Open the Relationships window. Drag the ScheduleItems table from the Navigation Pane to the Relationships window, positioning it between the existing four tables. (Hint: You can also add tables to the Relationships win-dow by clicking the Show Table button in the Relationships group on the Design tab.)
c. Now that all four tables are in the Relationships window, notice that each table has a primary key field except for the ScheduleItems table. Open the ScheduleItems table in Design View, set the TransactionNo field as the pri-mary key field, then save and close the table to return to the Relationships window.
d. To connect the tables, you have to decide how “one” record in a parent table relates to “many” records in a child table. In this case, the ScheduleItems table is the child table to each of the four other tables. Therefore, build four one-to-many relationships with referential integrity as follows: • Drag the ScheduleNo field from the ScheduleDate table to the ScheduleNo field of the ScheduleItems table. • Drag the LocationNo field from the Locations table to the LocationNo field of the ScheduleItems table. • Drag the DoctorNo field from the Providers table to the DoctorNo field of the ScheduleItems table. • Drag the NurseNo field from the Nurses table to the NurseNo field of the ScheduleItems table.
e. Be sure to enforce referential integrity on each relationship. Doing so will add the “1” and “infinity” symbols to the relationship line. If they are missing, double-click the relationship line to open the Edit Relationships dialog box, where you can check the Enforce Referential Integrity check box. FIGURE 2-19
f. Click the Relationship Report button in the Tools group on the Design tab to create a rela-tionships report, as shown in FIGURE 2-19.
g. Save and close the report with the default name of Relationships for IL_AC_2_ Riverwalk, then save and close the Rela-tionships window.
h. Compact and repair the database then close Access.

Comments

Post a Comment

Popular posts from this blog

Module 1 Getting Started with Excel - Independent Challenge 1

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...
Read more

Module 1 Creating Documents with Word - Visual Workshop

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.
Read more

Module 1 Creating Documents with Word - Independent Challenge 1

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...
Read more