Healthcare Data Unit 2 Assignment 2 Access Database Tables Key Assessment LO #3
File Adding Documents to LinkedIn.docx (91.055 KB)
File LinkedIn Assignment Guide.docx (19.641 KB)
File W2A2 SourceData.xlsx (1.63 MB)
File W2A2 Step by Step Instructions to build a table.docx (4.244 MB)
File W2A2 Step01-Build-Tables.accdb (552 KB)
Assignment Objectives:
Meet CAHIIM Curriculum requirement for Bachelor Degree
Domain I. Data Content Structure and Standards
Subdomain I.D. Data Management
Section 4. Apply knowledge of database architecture and design to meet organizational needs
Competencies: Database architecture and design
Assignment Purpose:
Create tables in an Access database
Assignment Description:
In this class, we will be creating and using Access Databases. You must have Microsoft Access on your computer to complete these assignments. IF you do not have Microsoft Access on your computer, go to the Bookstore tab on Blackboard, scroll down to the bottom of the page, there are instructions on how to obtain the Microsoft Office Suite.
There are four main objects that we will be working with in Access Database. They include Tables, Forms, Queries, and Reports. For this assignment, you will be creating tables in an access database using the source data and the access database attached (Step01-Build-Tables)
Download the source data and access database. Follow the attached step-by-step instructions on how to build a table.
Write a 300 word summary describing the process of building a table. How easy/hard was it to do? Where did you have difficulties, if any?
Take a screen shot of your Access Database, showing all eight tables. Submit your screen shot for grading.
(Unit 2) OPTIONAL EXERCISE
Create or Update: ePortfolio documents on LinkedIn
Estimated time to complete: 5 Minutes
Instructions:
In a previous course you may have had an opportunity to create a LinkedIn profile. LinkedIn profiles are a great way to showcase the skills you have learned to potential employers. If you have not yet had an opportunity to create a profile, you can do so anytime by following the instructions in the “LinkedIn Assignment Guide” document included in this assignment.
Once you have your profile established, you can make it even stronger by adding examples of your work to the documents section to create an ePortfolio. If this is your first time adding documents to your profile, you can refer to the “Adding Documents to LinkedIn” guide that is included in this assignment.
This assignment is a great way for you to demonstrate that you have a foundational knowledge of SQL, which is an important skill that is applicable to a variety of software development projects.
We want you to show your best work, so if you did not earn an “A” on this assignment, you should consider re-doing the parts that you did not score well on before uploading your final assignment. You can also ask your instructor how you can strengthen it.
Before uploading your assignment document, consider adding a paragraph at the beginning that states in your own words what you learned in this course, and any personal messages you may have about what you may have enjoyed about it or found most interesting.
Adding examples of the SQL code you wrote to your assignment document would make this an even better example.
If your assignment document does not have a descriptive name, rename it to one that describes the skill(s) you are demonstrating with it. Once satisfied, you can upload to your profile so that you show off some of the skills you have learned at Herzing University!