Project 1: Intro
Did you want: Working with Databases: Access 2007/2010/2013
Even though many advanced database programs are available, you will need to know a bit about a plain text database. They are still used a lot behind the scenes.
What is plain text used for?
Example: Installation/Configuration File
A simple list works well for information about how a program was installed. The example in the illustration is from Adobe Reader 7.0.
This example does not have rows and columns. The whole file is a database
with only one
record. Each field is on a separate line in the format:
Example: Log File
A log file is a text database that keeps a list of activities, like computer errors, program updates, or web site activity.
The example below is part of a log of the requests on a certain day to the web server that hosts these lessons. Each web page or image that the browser needs is a separate request. It looks more like what we expect from a database than the previous example, apparently having rows and columns, separated by spaces.
Each record is on one line. The fields appear to be neatly lined up in columns... until you scroll to the right. In some fields the values all have the same number of characters, but in other fields some values have many more characters than others. No more columns.
The first line above the records shows the names of the fields, but the names do not line up over the correct column.
Row of field names: Some text databases do not include the names of the fields as the first row, or any row at all! If you use a text database to move data between programs, you will need to know whether or not the first record holds the field names.
see all of the fields in a single record at once:
But...when word wrapping is turned on, the fields no longer line up in columns. You can now see a complete record in the window at once, but it is much harder to read.
So, you get to choose one or the other:
Text databases need a way to separate the records from each other and to separate the fields in a record. A character that separates data items or records is called a delimiter.
Example: The illustration at the right is of a log of updates to Windows.
What if the delimiter character
is used in a data value?
Transferring data: When you export data to a text database, you must choose a format and you may have a choice of what to use as a delimiter. When you open that text file in a different program, you will have to tell the program what the delimiter is. Some programs do not recognize all of the delimiters listed above, but commas and tabs are almost certainly acceptable.
A format that is often used when transferring data between programs is CSV format (Comma Separated Values). This format puts a comma between each field, like the example at the right. The file may use csv as the file extension, like mydata.csv
CSV format is easy for computers to use, but it not easy for human eyes!
~~ 1 Cor. 10:31 ...whatever you do, do it all for the glory of God. ~~
Last updated: 30 Apr 2012