CS12 Sunday Fall 2012 - Understanding Personal Computers
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:
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 28, 2012
Subscribe to:
Posts (Atom)