Access Assignment
The two files below are for the publicly available 2010 version of the National Hospital Discharge File
from the Centers for Disease Control.
Instructions:
Load the NHDS2010 Exercise.txt file into an Excel file and label each column using the NHDS
2010 Documentation file. The relevant pages for these are pages 15 through 18. The file should
look like the one below. What was the easiest part of this exercise? What was the most difficult
part of the exercise?
Although the NHDS file is not a relational file, can answer the following relational database
questions.
a. Identify the data elements which might be broken out into a separate table for a relational
database.
b. Identify which âtablesâ would be used for more than one of the data elements.
Load the NHDS file into a single Access table and save the file. Note that ICD-9-CM codes did not
load correctly for several of the records. This does not prevent you from completing the
remainder of the assignment. Delete the Table 1 and the table with errors.
a. Use the Query Wizard to run a Select Query.
Access Assignment The two files below are for the publicly available 2010 versio
Need help Working on This or a Similar Assignment?
We specialize in custom-written, original papers. No prewritten essays here—order your plagiarism-free and AI-free paper today for guaranteed originality.