Google: Fusion Tables - Tools DB

Import a data file from your computer

Download the file (DB 1 Tool Import File - Data.csv) attached to this page.

This is a Comma Separated File, known as a csv file.

This type of file can be read by most database programs and allows easy importing of data into the database.

The file looks like:

TOOL NAME,DESCRIPTION,SUPPLIER,UNIT PRICE,QUANTITY

saw,circular,B & D,45.99,3

drill,variable speed,B & D,45.99,3

TheĀ  first row contains the field (column) names, each field name is separated by a comma

The each row that follows contain the data for one record (row), the data is also separated by commas.

Once the file is on your computer, create a new Fusion Table. You will need to import the .csv file from your computer.

Add a calculated field

Create a new field: Edit>Add formula Column

Name: Invoice Total

Formula: 'UNIT PRICE'*QUANTITY

Set an appropriate format for this type of data.

Note:

Simple Queries: Sorting Records

A query when a question is asked of a database. The data is converted into information.

Simple queries can be answered by sorting by different fields

Answer the following simple queries:

Add a Summary

A summary can hold more than one for these queries.

Queries created by a summary tab can be more complex.

Rename your Summary tabs to describe the information it contains

Note:

Add a Filter

A filter can also be added.

Create a new Summary tab similar to #1 above (for each supplier, determine the total of the Invoice Total), but include a filter that only includes the supplier B & D