Introduction to MS Visio and MS Access
Order ID 53563633773 Type Essay Writer Level Masters Style APA Sources/References 4 Perfect Number of Pages to Order 5-10 Pages Description/Paper Instructions
Introduction to MS Visio and MS Access
- Lab #: BSBA BIS245A-1
- Lab 1 of 7: Introduction to MS Visio and MS Access
- Lab Overview—Scenario/Summary
COs:
- Given a business situation in which managers require information from a database, determine, analyze, and classify that information so that reports can be designed to meet the requirements.
- Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool.
Scenario:
You have been asked to create two conceptual database models using MS Visio database notation template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conceptual model (entity-relationship diagram or ERD) of a database. You will create two conceptual models.
You will then open an existing access database to explore database objects and to experiment with simple data manipulation using filters and sorts and to begin elementary work with relationships.
Upon completing this lab, you will be able to
- relying on detailed instructions, create a simple conceptual model for a two-table database using MS Visio;
- use experience gained in creating the first model to construct a similar conceptual model without the instructions; and
- download an existing Microsoft Access database file. Open the database; find and identify different database objects in this database.
- Deliverables
Section Deliverable Points Part B Step 4 YourName_Lab1.vsdx (Visio Diagram) Part C Step 8 YourName_Lab1C_ScreenPrints.docx
- Lab Steps
Preparation
- Download the database file.
- Download Lab1_Nwind.accdb file from the Week 1 Lab page, and save the file to your local drive.
- Create a new MS Word document named Lab1C_ScreenPrints.docx from the Week 1 Lab page, and save the file to your local drive.
- Using Citrix for MS Visio and/or MS Access
- If you are using the Citrix remote lab, follow the login instructions located in the lab area in Introduction and Resources.
- You will have to upload the Lab1_NWind.accdb file to your Citrix drive. Follow the instructions for uploading files to Citrix, located in the lab area in the Introduction and Resources area.
Lab
Part A: Become Familiar With MS Visio Step 1: Locate the Microsoft Office Applications a. If you are using Cirtix, click on the Microsoft Office applications folder. b. If you are using Visio on a local computer, select it from your program list. You may need to select Microsoft Office from your program menu, and then select Visio.
Step 2: Start Visio a. Click on Microsoft Visio and it should open like the following screen. Notice that the list of diagrams is shown. At the upper left-hand side, there are two tab options: featured and categories. Click on the categories section, as shown circled in red below. b. Select the database and software option from the categories listed, as seen below. c. From the template categories, click to select the software and database category. See the next screen capture. The database notation diagram template is selected. d. Under choose a template, double-click the database model diagram to select the template set, opening the template as follows. (An alternate method is to select the UML database notation model diagram template, and then click the create button to open the new file.) Step 3 Set Visio Database Options for Crow’s Foot Notation a. Change Visio setting to use Crow’s Foot notation for the model diagrams. NOTE: This notation will most closely match the models used in your textbook. From the top menu bar, select connectors. From the menu bar on the left, select More Shapes. Select software and database from the first list. From the second list, select UML database notation. From the last Window, make sure that UML database notation is selected as well as Crow’s Foot notation. Please see the figure below. b. Click to select the view tab to see the view ribbon (toolbar). Select zoom from the list and select at least 75%. This allows display of more detail in your diagram. See the diagram below. Step 4: Conceptual Model for a Two-Table Database Now that all settings are correct, it’s time to model a simple database. The database will include two entities. a. To create the first entity, drag and drop the entity shape from the shapes toolbox on the left to your open, empty diagram worksheet. Notice (See drawing below.) that the entity shape is selected showing the sizing handles. No properties are shown. This version of Visio uses GUI to create the table.
b. Click on the new entity. There are four parts. The entire entity (green outline), the entity name (at the top), the attribute name with a key, which is the primary key, and remaining attribute names. Once you have the entity name box selected, double click entity name and enter CUSTOMERS. See below. c. Double click the key attribute name after you have selected the box and enter CustID. Continue entering the following information in attribute name boxes by double clicking each and typing in the name. There are only two listed, and you will need seven total. To add additional attribute names, right click the attribute name border until you see insert attribute before/after in the list of options. Add five additional attribute names, and complete this step by adding the following information. CustFirstName
CustLastName
CustStreet
CustCity
CustST
CustPostalCode
CustPhone.
Your Visio diagram should match the figure below.
d. Create the second entity in the same manner beginning with dragging and dropping a second entity shape from the toolbox on the left. Name the entity ORDERS. e. Add the following attributes to the orders entity. OrderNumber (as primary key)
OrderDate
OrderQty
OrderStatus
Your Visio ERD should now look like the one shown below.
f. Now define the relationship between the two entities. To do this, drag and drop the relationship shape from the toolbox on the left. To connect the two entities, first add another attribute (CustID) to the orders table. Next, click and drag the connector to the diagram surface. Click and drag the end with two lines and drop it on CustID in the customers table. A green circle should appear when the entity is connected. Pick up the other end of the connector (with Crow’s feet) and drag it to the attribute list, and connect it with a green circle to CustID on the orders table. After connecting one end to the customers table, if the unconnected end of the connector does not have a Crow’s feet, right click the relationship, select “Set End Symbol” from menu, and choose “1 or more.” See below. Step 5: Modify the Database Model The diagram is good, but could use a few improvements. The diagram may be easily modified. a. First, change the customers entity. Click on the entity to select it. From here, you can click the bold, font color, and font size from the Home tab as you would in any other Microsoft program, and make changes such as bold, black font color, and 14 font size.
b. Select the orders entity and do the same formatting.
c. Select and right click the relationship line. Select edit text from the options in the dropdown menu. Type in the action that takes place between these two tables. Hint: Orders are placed. Results should look like the results below with font size and colors changed.
Step 6: Deliverable for Lab 1 Part A The diagram is not complete. As you move through the course, you will create more sophisticated diagrams. However, the purpose of this lab is to just build familiarity with the Visio program and its database options. Save your diagram as YourName_Lab1A.vsdx. We will use this file for Part B.
End of Part A Part B: Create a New Conceptual Model Diagram (ERD) Step 1: Open the Visio diagram file. a. Open the same Visio file created in the Part A Lab. b. Rename the page 1 Lab Part A.
c. Go to the insert menu and insert a blank page.
d. Double click on the page tab, and rename it to Lab1 Part B also.
Step 2: Create a New ERD Use the new page to develop an ERD showing the following. 1. Entity for suppliers with the following attributes:
a. SupplierID (Primary Key)
b. SupplierCompanyName
c. SupplierContactName
d. SupplierContactTitle
e. SupplierAddress
f. SupplierCity
g. SupplierRegion
h. SupplierCountry
i. SupplierPhone
j. SupplierFax
k. SupplierHomePage
2. Entity for products with the following attributes.
a. ProductID (primary key)
b. ProductName
c. ProductPrice
d. ProductDescription
The relationship between suppliers and products: in this case, the suppliers provide products.
Step 3: Modify the Diagram Modify the model by making all attributes of both entities related using a shared primary key in the related table. Step 4: Deliverable for Lab 1 Part B Be sure you save your diagram before closing as YourName_Lab1B.vsd. End Part B Part C: Navigating MS Access Preparation a. Download the Lab1_Nwind.accdb file from the Week 1 Lab page, and save it to a local drive on your computer. b. If you are using Citrix for MS Access, you will have to upload the Lab1_Nwind.accdb file to your Citrix drive or allow Citrix access to your system. Follow the instructions for uploading files to Citrix, located in the Lab area under the Introduction and Resources area.
c. Download the Lab1C_ScreenPrints.docx file from the Week 1 Lab page. Save the file to your local drive as YourName_Lab1C_ScreenPrints.docx. Open the file so you can provide the answers as you go through the steps in Part C.
Step 1: Locate MS Office Applications a. If you are using Citrix, click on Microsoft Office Applications folder. b. If you are using Access on a local computer, select Microsoft Office from your program menu.
Step 2: Start MS Access c. Click on Microsoft Access, and Microsoft Access should open like the following screen. Step 3: Open Lab1_Nwind.accdb database file. Click the open button on the menu on the left as indicated with the red circle below. a. Navigate to locate the Lab1_Nwind.accdb file on your local drive or in Citrix. b. Click to open the database. You should see the following screen. You will not log in, so click the close button on the login form.
Step 4: View the Tables a. Notice the all access objects list on the left side of your screen. Click on all tables to expand the list to show all tables in Northwind traders database. From the list of tables, double click on suppliers to open the suppliers table. See instructions for 2016 below. b. Close the Window for the starting form.
c. Close the login dialog box, selecting the red X in the upper right corner.
d. Select “Show All” under tables.
Left click and drag the suppliers table to the workspace on the right.
.
e. Notice that the entire table is not visible. Use the horizontal scroll bar to view the remaining fields in the suppliers table. Complete your response to Question 1 in the Lab1C_Questions document.
Step 5: Examine the Field Names a. Open the customer table and examine the field names. Notice that each has a small down arrow at the right side of the field name at the top of the field. These are used to filter the table based on specified criteria. Scroll over, and click the filter arrow in the city field. Your screen should appear as follows. b. Simple sort of data. Click the sort A to Z option at the top of the list of options. Notice that all records in the table are now sorted in alphabetical order by city. Answer Question 2 in the Lab1CQuestions document.
c. Simple filter of data: Click the state/province down arrow. Click on the select all option or deselect the list of states. Now scroll down the list and click on TN so that only customers in Tennessee are selected. Click the OK button to apply the filter. Answer Question 3 in the Lab1C_Questions document.
d. Remove the filter by selecting the select all option in the state/province down arrow menu. Close the customer table by clicking the x on the customer tab. When prompted to save the customers table, select no.
Step 6: Relationships a. Click to open the database tools ribbon (toolbar). b. Click the relationships button. This allows you to view the database schema made up of the tables with attributes and keys and relationships between tables. (See below.) Scroll bars can be used to view parts of the diagram not on the screen. The key symbol indicates which fields act as primary keys for the tables.
c. Based on the information in the diagram, answer Questions 4 and 5 in the Lab1C _Questions document.
Step 7: Queries a. Click the close button on the database tools tab to close the relationships diagram. b. Click queries from the all access objects list on the left to display the list of queries available.
c.
d. Open the suppliers list query.
e. Select the view option in the upper left tool bar. Click once to see query design and take a screen print. Click the view option again and the query results return. Take a screen print of the query results. Add both screen prints to a word document for the Part C deliverable.
f. Close access.
Step 8: Deliverable for Part C Save your Lab1C_Questions document as YourName_Lab1C_ScreenPrints. Make sure you have provided your answers. End of Part C Lab 1 Final Deliverables a. YourName_Lab1.vsd (Visio Diagram) – from Lab 1 Part B
b. YourName_Lab1C_ScreenPrints.docx – from the Lab 1 part C.
c. Submit these files.
END OF LAB
RUBRIC
QUALITY OF RESPONSE NO RESPONSE POOR / UNSATISFACTORY SATISFACTORY GOOD EXCELLENT Content (worth a maximum of 50% of the total points) Zero points: Student failed to submit the final paper. 20 points out of 50: The essay illustrates poor understanding of the relevant material by failing to address or incorrectly addressing the relevant content; failing to identify or inaccurately explaining/defining key concepts/ideas; ignoring or incorrectly explaining key points/claims and the reasoning behind them; and/or incorrectly or inappropriately using terminology; and elements of the response are lacking. 30 points out of 50: The essay illustrates a rudimentary understanding of the relevant material by mentioning but not full explaining the relevant content; identifying some of the key concepts/ideas though failing to fully or accurately explain many of them; using terminology, though sometimes inaccurately or inappropriately; and/or incorporating some key claims/points but failing to explain the reasoning behind them or doing so inaccurately. Elements of the required response may also be lacking. 40 points out of 50: The essay illustrates solid understanding of the relevant material by correctly addressing most of the relevant content; identifying and explaining most of the key concepts/ideas; using correct terminology; explaining the reasoning behind most of the key points/claims; and/or where necessary or useful, substantiating some points with accurate examples. The answer is complete. 50 points: The essay illustrates exemplary understanding of the relevant material by thoroughly and correctly addressing the relevant content; identifying and explaining all of the key concepts/ideas; using correct terminology explaining the reasoning behind key points/claims and substantiating, as necessary/useful, points with several accurate and illuminating examples. No aspects of the required answer are missing. Use of Sources (worth a maximum of 20% of the total points). Zero points: Student failed to include citations and/or references. Or the student failed to submit a final paper. 5 out 20 points: Sources are seldom cited to support statements and/or format of citations are not recognizable as APA 6th Edition format. There are major errors in the formation of the references and citations. And/or there is a major reliance on highly questionable. The Student fails to provide an adequate synthesis of research collected for the paper. 10 out 20 points: References to scholarly sources are occasionally given; many statements seem unsubstantiated. Frequent errors in APA 6th Edition format, leaving the reader confused about the source of the information. There are significant errors of the formation in the references and citations. And/or there is a significant use of highly questionable sources. 15 out 20 points: Credible Scholarly sources are used effectively support claims and are, for the most part, clear and fairly represented. APA 6th Edition is used with only a few minor errors. There are minor errors in reference and/or citations. And/or there is some use of questionable sources. 20 points: Credible scholarly sources are used to give compelling evidence to support claims and are clearly and fairly represented. APA 6th Edition format is used accurately and consistently. The student uses above the maximum required references in the development of the assignment. Grammar (worth maximum of 20% of total points) Zero points: Student failed to submit the final paper. 5 points out of 20: The paper does not communicate ideas/points clearly due to inappropriate use of terminology and vague language; thoughts and sentences are disjointed or incomprehensible; organization lacking; and/or numerous grammatical, spelling/punctuation errors 10 points out 20: The paper is often unclear and difficult to follow due to some inappropriate terminology and/or vague language; ideas may be fragmented, wandering and/or repetitive; poor organization; and/or some grammatical, spelling, punctuation errors 15 points out of 20: The paper is mostly clear as a result of appropriate use of terminology and minimal vagueness; no tangents and no repetition; fairly good organization; almost perfect grammar, spelling, punctuation, and word usage. 20 points: The paper is clear, concise, and a pleasure to read as a result of appropriate and precise use of terminology; total coherence of thoughts and presentation and logical organization; and the essay is error free. Structure of the Paper (worth 10% of total points) Zero points: Student failed to submit the final paper. 3 points out of 10: Student needs to develop better formatting skills. The paper omits significant structural elements required for and APA 6th edition paper. Formatting of the paper has major flaws. The paper does not conform to APA 6th edition requirements whatsoever. 5 points out of 10: Appearance of final paper demonstrates the student’s limited ability to format the paper. There are significant errors in formatting and/or the total omission of major components of an APA 6th edition paper. They can include the omission of the cover page, abstract, and page numbers. Additionally the page has major formatting issues with spacing or paragraph formation. Font size might not conform to size requirements. The student also significantly writes too large or too short of and paper 7 points out of 10: Research paper presents an above-average use of formatting skills. The paper has slight errors within the paper. This can include small errors or omissions with the cover page, abstract, page number, and headers. There could be also slight formatting issues with the document spacing or the font Additionally the paper might slightly exceed or undershoot the specific number of required written pages for the assignment. 10 points: Student provides a high-caliber, formatted paper. This includes an APA 6th edition cover page, abstract, page number, headers and is double spaced in 12’ Times Roman Font. Additionally, the paper conforms to the specific number of required written pages and neither goes over or under the specified length of the paper. GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDER
CLICK ON THE LINK HERE: https://www.perfectacademic.com/orders/ordernow
Also, you can place the order at www.collegepaper.us/orders/ordernow / www.phdwriters.us/orders/ordernow
Do You Have Any Other Essay/Assignment/Class Project/Homework Related to this? Click Here Now [CLICK ME]and Have It Done by Our PhD Qualified Writers!!