“Tables”College of Alameda

pmcdermott@peralta.edu

Copyright © 2008 Patrick McDermott

“In its simplest form, a table is just a list of information presented in an ordered fashion.”—digital diagrams

How is this Data

Organized?

red lion cola pepper sapphire blue bear frappe salt diamond green alligator martini msg topazpink flamingo espresso garlic rubywhite giraffe milk cumin emeraldblack penguin beer saffron amethystgray dog water cinnamon turquoise

red lion cola pepper sapphireblue bear frappe salt diamondgreen alligator martini msg topazpink flamingo espresso garlic rubywhite giraffe milk cumin emeraldblack penguin beer saffron amethystgray dog water cinnamon turquoise

Representing Tables• Table in the World

– The relation exists in reality

• Spreadsheet Table– Rows & Columns– “Official” XL Table– PivotTable

• HTML Table• Database Table

– Microsoft ® Access

a.k.a. Table• Array• List• Vector• Column• Table• Matrix• DB Relation

• QueueThe Tower of BabelThe Bedford HoursParis, c. 1423-1430

An Array Affray

You often need a table of data—as a reference, for example. An array is also an easy way to keep a lot of data “the poor programmer’s database”. Arrays are just tables but there are some subtleties involved in their use.

Into the Fray with an Array

A Table can be a Book!

Great Nightstand Reading!

Periodic Table of the Elements

Examples of Tables• Tangible• Intangible• People• Places• Things• Events

– Timetable• Organization Table• Table of Contents• TO&E

You can use a Table if…• There’s a form

– XL, Access, HTML for Form Entry– XL, Access to track items

• There’s a file• There’s a number

– Numbered form• There are several copies

– Share• It’s Important