two ways of finding information from your raw data

read ch 6
quickchecks

pivottables, subtotal

Microsoft Access

Relational Database software

Database: a bunch of tables, and ways of manipulating the data in the tables

Database: a way of storing a whole bunch of data, and operations for manipulating that data

Table: a collection of records

Record: A collection of fields

Field: One unit of data

MSACCESS

is diff from Excel, Word
doesn't start you out with a blank document

You actually have to create a file

Two different views:
See the actual data in your table: Datasheet view
See the meta-data

Field Name, Data Type are properties of the field


You can have a table.

Query, Report, Form
Query: ask a question about your data
SQL
http://www.w3schools.com/sql/default.asp

Report: usually printed
don't edit the data

Form: also lets you edit. provides a user interface to the underlying table

Wildcard:
*
?

* means match anything, including nothing
? means match exactly one symbol

Works in Word, Access, Google searches

That is basic wildcard matching in Word

Advanced wildcard matching in Word
regular expressions

Go through these examples.
http://office.microsoft.com/en-us/help/add-power-to-word-searches-with-regular-expressions-HA001087305.aspx
http://office.microsoft.com/en-us/support/putting-regular-expressions-to-work-in-word-HA001087304.aspx?CTT=5&origin=HA001087305
Nothing to hand in at this time.