Sunday, December 16, 2012


microsoft ultimate steal
http://www.microsoftstore.com/store/msstore/cat/categoryID.37826100

* import from Excel into Access
my advice: make sure that data type of foreign keys
and primary keys are set to what you want on import.
otherwise, you will problems in establishing relationships
in the relationship window.
set the primary key on Import

* In queries, here are the wildcards:
* means match anything, including nothing
j*sh
will match:
jsh
josh
jithsh
? means matching exactly one characted
j?sh
will match
josh
jish
NOT match jsh
NOT match jiiiish
contains Excel
*Excel*
Learning Excel Formulas
Excel Formulas 2010
Learning Excel
begins with
G*
Grauer
ends with
*ing
Starling

Like "*Excel*"


Today's date: Dec 16
Publish Date: Dec 1
Today's Date MINUS Publish Date <= 60
DATE() - PublDate <= 60


SELECT Book.Title, Book.Price, Book.PublDate
FROM Book
WHERE Book.PublDate > Date()-60;

joshwaxman@gmail.com

Sunday, December 2, 2012


w3schools.com

select * from Accounts, Branch
where Accounts.BranchId = Branch.BranchID

SELECT Accounts.AccountID, Accounts.CustomerID, Accounts.BranchID, Accounts.Balance
FROM Branch INNER JOIN Accounts ON Branch.BranchID = Accounts.BranchID
WHERE (((Accounts.BranchID)="b50"))
ORDER BY Accounts.AccountID;

http://eniac.cs.qc.edu/~svitak/cs12/

quiz next week, based on multiple choice from
Access ch 1, 2, 3


SELECT Agents.FirstName, Agents.LastName, Properties.DateListed, Properties.ListPrice, Properties.SalePrice, Properties.SqFeet, Properties.Sold, [ListPrice]/[Beds] AS PricePerBR, ListPrice / (Beds + Baths) As PricePerRoom
FROM Agents INNER JOIN Properties ON Agents.AgentID = Properties.AgentID
WHERE (((Properties.Sold)=No));

Practice Access Exams

Practice Access Exam 1.
Practice Access Exam 2.

PracticeExamFiles.zip

Practice Access 1

Practice Access 2:

Sunday, November 11, 2012


Next week, Excel Exam

Microsoft Access

Why? (Compared with Excel)

* more secure
* faster
* smaller
* more powerful
* more features

Database: stores your data, gives you ways of accessing your data, querying your data, changing your data

Database: a bunch of tables
Table: a bunch of records
Record: a bunch of fields
Field: col, or actually just one unit of data

Query: SQL:
select first, last, salary from Customers where Age >= 34 order by last

Also, query designer in Access

Forms: to view and edit your data
Reports: for printing
Macros: programming

Homework:
Ch 1, practice exercise 2, custom coffee
If you cannot do step j, don't worry about it.

Also, think to your major. Make an Access database, with the following tables. Eventually you are going to link them. Tables to make:
* Faculty
* Students
* CourseCatalog
* Rooms
* Spring2012
* The_Name_of_One_Specific_Course

Figure out which will be primary keys and which will be foreign keys. Don't put too much into the data. Think 3 to 5 records for each.

Sunday, November 4, 2012


The wayback machine.

archive.org

www.bugmenot.com

www.retailmenot.com

google drive (google docs)

google groups (Usenet and more)

google books

google translate

* Goal Seek
* Solver
* Pivot Tables
Import / Export
* Macros
* VBA
* UDFs
* Express edition VB.NET Visual Studio

* CS courses
http://www.cs.qc.cuny.edu/

http://venus.cs.qc.cuny.edu/~ryba/

google reader
rss feed (XML) - extensible markup language

project gutenberg


Sunday, October 21, 2012


grace hopper, debugging

relative vs. absolute references, naming cells, mixed references

Homework:
Excel, ch 2, practice exercise 1

to submit homeworks, send to joshwaxman@gmail

colon operator
comma operator
space operator