Friday, February 11, 2011

Dear Class:


Edit your Report
Use handout
Change font, color, alignment, border, fill
Paintbrush

Publish it to WORD and EXCEL
What can you do with it???

Watch this tutorial: Export Access to Excel or Word

I want your data exported into Excel. I want to do more with it. The following is a new category for Excel that I want put in:

Expenses per day:
Trent 2.43
Hayden 3.40
Loren 2.10
Helena 1.25
Michael 1.75
Kevin Guan 2.24
Ngai 3.10
Kevin McGill 2.00
Ana 1.55
Paul 2.02
Naragan 3.10
Trung 2.25
Nahu 1.11
Brent 2.00
Ryan 3.22
Gabriel 2.22
Felix 1.25
Richard 2.25
Raymond 2.10
Kevin Tomlin 1.11
Josue 2.00
Jason 2.24

Please put in the costs. Total will be "=cell*174" (a year of school will be 174 days). Make sure you copy the formula down by putting your pointer on the "fill handle" (the small black square on the bottom right corner of the cell) and dragging the formula down.
Sort the First names from A-Z
Create a graph. The Graph will reflect the first names and the total spent for year at David Douglas. This will be done by selecting the first name column and then holding down the control key and then selecting the "Total Yearly Expenses". Select two other columns of your choosing. Choose the bar graph for this. Save but do not print. I will look at them next time I am in class.

Print a copy—from WORD?? EXCEL?? OR ACCESS???
Must have enhancements
Correct Spelling—watch caps
Centered on Page
Name on bottom left/period on bottom right
We will do in class.

Watch the following Youtube tutorials together:

Relational databases
Microsoft Access ® 2003 Sales Invoice: 1 Relationships

Query databases
Microsoft Access ® 2003 Sales Invoice: 2 Query

Microsoft Access ® 2003 Sales Invoice: 3 Report


Open DATABASE NOTES
wildcards—* ?
comparison operators—like < > +
compound criteria—using two sets of criteria

Go back to your original database.

QUICK SORT
Filtering—a temporary sort
Filter by selection
Highlight something and click on filter by selection icon
Can only select one criteria
Run filter
Remove filter
Filter by form
Click on Filter by form and enter a criteria
Can select more than one criteria
Run filter
Remove filter
This will be the icon that looks like a "funnel" which I told you about.

Permanent Sort
Creating a Query—extracting specific information
How do you do a query? Go to youtube for a tutorial (Watch as a class)

Using design view
Add a table and select fields
Options:
Sort
Show
Criteria
Or—more than one criteria
When using check boxes yes/no
Criteria:
“smith” matching Smith
“Smith” or Larson” matching both
Not “Smith” everything but Smith
S* everything that begins with S
*s everything that ends with s [a –d]* begins with a through d, ends with anything
between 10 and 15 shows 10 through 15
“Johns?n” shows Johnson and Johnsen

Make sure you understand the query part that adds, limits, and shows data.

We will finish this. I have a handout that we will finish that will end our Database and a quiz on the vocabulary of Database on Tuesday.

Sincerely,
Mr. Green-Hite