Assignment Importing and Exporting Data
Due Sunday, April 12, 2020, 11:59 PMTime remaining: 1 day 10 hours
Introduction
A given company may have many datasets used as part of regular business; however, those datasets may be located in different software or online. Luckily, many software programs, whether installed on a computer or online, allow users to export the data to a file which is compatible with a spreadsheet software. This could be a spreadsheet file itself or a basic text file. Almost all software will allow data to be imported from a text file, including spreadsheets. Because dataset compatibility is a feature in spreadsheets for both importing and exporting, it is very easy to manipulate and analyze data collected from a variety of organizational avenues.
For this assignment you will first go through the process of exporting data from an Access database file to an Excel spreadsheet file. Then, you will export the data to a text file. Last you will write a 1 to 2-page paper on the experience
Note: If you do not have the Access software, remember that Tiffin University gives all students access to download Microsoft Office using a Microsoft Windows account through your Tiffin email.
To prepare for the Assignment, follow these steps:
1.     1. Download the Access database (attached to this assignment)
2.     Export the data from the Customer table in the Access database file to a spreadsheet software.
3.     Export the data from the Invoice table to a text file. You will need to search the Internet for instructions on how to do this.
4.     Attach the exported data files with your submission.
Instructions
In your paper, consider the following:
·        Describe your experience in completing this task. Did you find any particularly good resources to help you complete the task? If so, which?
·        Analyze the technical aspects: comment on the makeup of the attributes of the exported text file. What other types of files does Access allow you to export? What are these types of files? Open Excel and investigate and explain the different options for importing data into Excel. Are there other means to import/export data into the software?
·        Evaluate the potential benefit of this process: In your own words, and using sources to back up your comments, how does importing/exporting common file types benefit data analysis? How might you use this in your current or future career?
Writing Requirements
·        1-page paper not including title page or reference page
·        Cite 1 different sources in paper
Weekly Learning Goal(s): [No.2]
2.     Importing/exporting data into a spreadsheet model. (CLO #3)