Tuesday, March 27, 2012


UDF: user defined function

Alt-F11: launches VB editor
Insert/Module: add new module

then type:
Function MySum(X, Y)
    MySum = X + Y
End Function


HW: write a UDF called MyProduct
which will be X times Y

why use names? self-documenting formulas

you can also Name relative refs and mixed refs
name manager
DiagonalUp

MonthlyPayment
='HO3-4'!$H9

databases
record: row in Excel
table: collection of records, tab, worksheet
database: collection of tables and methods of interacting with those tables
field: corresponds cell (or column?)

Access is a relational database
what does that mean?
*shrugs*

HW:
design a table to store course information,
make up information to fill that table
course number, number of credits, faculty, faculty rating

design a table to store faculty information,\
msaccess

No comments:

Post a Comment