Assignment: Data Relationships
Assignment Objectives:
1. Meet CAHIIM Curriculum requirement for Bachelor Degree
1. Domain III. Informatics, Analytics and Data Use
2. Subdomain III.A. Health Information Technologies
3. Section 5. Evaluate system architecture, database design, data warehousing
4. Competencies: Data relationships
Assignment Purpose:
Create data relationships in an Access databas
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 relationships between tables in an access database using the access database attached (Step02-Build-Relationships - Between-Tables).
Download access database. Follow the attached step-by-step instructions on how to build relationships between tables.
Follow the step by step instructions, taking screen shots at different points.
Develop a paragraph (About 300 words) which discusses data relationships.
The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.