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 discussion 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.
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 discussion, follow these steps:
Download the Access database: Week 5 Database .
Export the data from the Customer table in the Access database file to a spreadsheet software.
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.
Attach the exported data files to your initial post.
Initial Post Instructions
In your initial post, 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?
Secondary Post Instructions
In your secondary posts, help classmates who got stuck during the process, offer links to resources that you plan to save for future reference, explore pros and cons of using the Access software, etc.
Your secondary posts need to be within 12 hours apart from each other. Meaning if you post your 1st Secondary Post at 11:30am on Saturday then you must wait until 11:30pm on Saturday to post your 2nd Secondary Post.
Writing Requirements
Initial post 350 words
Cite 2 different sources in initial post
Secondary posts 250 words
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more