Quiz material. From here:
http://qccs12.blogspot.com/2011/03/lecture_09.html
WEDNESDAY, MARCH 9, 2011

until here:
http://qccs12.blogspot.com/2011/03/more-financial-formulas-solver-2.html
WEDNESDAY, MARCH 30, 2011

intro to CSS

http://www.w3schools.com/css/default.asp

selectors and declarations

back to MS Access
field properties

to ask questions about the data, we use Queries

SQL - a standard query language you can use to talk to databases
http://www.w3schools.com/sql/default.asp

SELECT * FROM Customers
WHERE FirstName = "Peter"

query wizard:
what table?
what fields?
what shall we name this query?

then, we will need to fine-tune it in Design View.

SELECT Customers.Title, Customers.FirstName, Customers.LastName, Customers.PhoneNumber, Customers.FullAddress, Customers.SSN, Customers.CreditCardNumber, Customers.DOB
FROM Customers;

we added the where clause using the design view, in the Criteria row.

SELECT Customers.Title, Customers.FirstName, Customers.LastName, Customers.PhoneNumber, Customers.FullAddress, Customers.SSN, Customers.CreditCardNumber, Customers.DOB
FROM Customers
WHERE (((Customers.FirstName)="Peter"));

Access databases will typically have Tables, Queries, Forms, Reports

wildcards: * ?
* means match any number of characters, including zero character

j*sh

____________

josh
jish
joshua -- only this one won't match
jsh
jjsh
jaash

MSACCESS
first, create a database
don't need to save data
do need to save meta-data
no undo

Microsoft Access is a relational database

A database: data and ways of maintaining that data

Database: a collection of tables
Table: a collection of records
Record: a collection of fields
Field: one unit of data. e.g. the SSN field of a given record

Table design = meta-data of the table. the table structure

* when designing tables, find the smallest unit
* data type = the type of data. number, text, date, etc.
* MUCH better to store values that don't need constant updating. Date of birth instead of age
* calculate things rather than storing duplicate information wherever possible
. Quality Points and GPA but not Credits. save space, less likely to have inconsistent data.

possibility of duplicate records
999,999,999

http://www.snopes.com/business/taxes/woolworth.asp

primary key: unique identifier for a record

ipmt, ppmt

find out: is lab instructor doing pivottables?

how to extend Excel's function

Visual Basic for Applications: a programming language

record a macro.

when we make a macro, we cannot save the file as .xlsx
instead, it is a .xlsm

Sub is for subroutine
function calculates a value and sends it back

UDF = user defined function
HW: make a macro, any macro
HW: make a UDF, any UDF
for example:
Function WaxmanCoefficient(X, Y)
WaxmanCoefficient = (X + 2) ^ Y
End Function

prenhall.com/grauer

Making web pages
http://eniac.cs.qc.edu/~svitak/cs12/webpageassign.html

plus, there will be some more

CSS
cascading style sheets
http://www.w3schools.com/css/default.asp

took a lot of the formatting and the "deprecated" it
font tag: allows font color, typeface, etc.
css instead

more financial formulas

solver (2 examples)
1) take nominal rate (APR) and divide it by freq for year. (e.g., if compounds monthly, divide by 12). that is called the periodic effective rate.
2) calculate: (1 + PeriodicEffectiveRate)^NPER - 1. that is called the annual effective rate



quiz up to this point

next time:
back to invoice
pivottable and pivotchart

we got up to and including 15.

limitations of goal seek:
1) only fiddle with one cell
2) only "seek" for a specific value
3) cannot impose constraints

special tool, Goal Seek on steroids:
Solver

ch 8 if you have it, in the lab book for excel.
but i'll be going over it next time anyway.

Quiz 2