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)
Assignment: Importing and Exporting Data
Our Service Charter
1. Professional & Expert Writers: Topnotch Essay only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.
2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.
3. Plagiarism-Free Papers: All papers provided byTopnotch Essay are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.
4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Topnotch Essay is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.
5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.
6. 24/7 Customer Support: At Topnotch Essay, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.