Flashcards in Chapter 7 - Organizing Big Data Deck (13)
List the 2 formats that can be imported into Excel
1. Text data
2. Database tables
List 4 examples of databases that can be imported into Excel
What is an example of the text data format that can be imported into Excel?
List the 3 types of text file formats
1. Free format
3. Fixed width
In which text file format does the reader have to determine the text that will be included in the field?
The free format
Which text file format separates the fields by a certain character?
The delimited format
In which text file format is the field width determined?
The fixed width format
What is a collection of records called?
What is one complete set of fields called?
What is a single piece of information called?
When importing data from a database what is imported into the table?
When importing data from a database what information is imported into the rows?