lecture

Goal Seek
within the PMT function

I can fiddle with some numbers

Solver -- more advanced -- goal seek on steroids

Solver can fiddle with multiple cells
Solver can solve for a maximum or minimum
Solver can work within constraints

Pivot Table
Pivot Chart

CSV file = comma separated value

difference between raw data and information
PivotTables and PivtoChartsCharts are more dynamic than Subtotal

Filtering and Advanced Filtering

in advanced filtering, within same row, it means AND
within diff rows, means OR

Financial Formulas

1) What function should I use?
FV, PV, PMT, RATE, NPER

2) Once I determine that, what should be the parameters

Wildcards:
*
?

J*sh
______
Josh
Jish
Jash
Joosh
Jsh

but not
Joshua

What about J?sh
____
Josh
Jish
Jash
Not Joosh
Not Jsh


Microsoft Access requires an actual file to work against. diff from word and excel

Many changes to your Access file cannot be undone.
Many changed to your Access file are automatically saved.

RDBS - relational database system
store your data, has ways of processing, viewing, asking questions about your data

Database: collection of Tables
Table: collection of records
Record: collection of fields
Field: one unit of information