Using the Microsoft Access database for PigTab |
Top Previous Next |
Remember: you shouldn't use the supplied database without making a copy for yourself. (It will work, but if you ever uninstalled or reinstalled PigTab, this file might be replaced or lost. It is much safer to make your own copy and set up ODBC to use your copy.)
When supplied, the database is called "PigTab database (sample).mdb". Make a copy before using it!
You need Microsoft Access (97 or higher) to use this database. Sorry about that.
When you open the database, it looks like this:
PigTab will store its results here. The table "ZZZ INFO: about the tables in this database" summarizes the information held in each table. Click a table and click Design to view a list of all the fields. Here, for example, is the design view for the DMTL_Results table (which stores results information for the Delayed Matching To Location task):
Don't modify anything in Design view unless you know what you're doing!
If you close the Design view and click Open instead, you see the contents of this table. Here is the contents of the DMTL_Results table (holding results for the Delayed Matching To Location task). I entered some sample results into this table.
Feel free to explore the tables.
When you want to extract data for analysis, you may want to create queries to do so. (Queries are listed in the "Queries" section of the main database screen.) Queries can be created using Access's visual query design system, or using the language SQL (Structured Query Language). A little on relational database principles and SQL follows. |