Office 1 Chapter Remarks
 | All Chapters
 | Don't forget to save with proper name. These names are on your
Goals&Effort Assignment sheet. |
| Save everything in the Office1 folder.
 | All Access chapter documents go in the My
Documents\Office1\Access folder. |
| All Word chapter documents go in the My Documents\Office1\Word
folder. |
| All Excel chapter documents go in the My Documents\Office1\Excel
folder. |
|
| Put in your three line document ID (Name, Date, Filename) in all documents
| In Word and Excel you use View, Header/Footer. |
| In Access you use File, Properties and put the three lines in
the Comments section. |
|
| Do not print unless Mr. Winter specifically says to print on this
page, on the whiteboard, or he tells you orally. |
| Fill in the Chapter Notes assignment as you are reading the chapter.
This has the highest level of points (25). This means the HIGHEST grade
you can get if you don't complete them is a C. They are good though
because if you do more than 10 you get extra credit. |
|
| Excel
| Make sure you put in formulas and not just numbers in all spreadsheets. |
| Make sure you put a header on all documents. View, Header and Footer,
Header/Footer tab, Custom Header button, Left section. |
|
| Excel 1
| E 1.37 - Make sure you don't highlight or include the totals in the
chart. |
| Tutorial (do this if you did not
understand the chapter or want to review it). |
|
| Excel 2
| E 2.40 - Make sure you do conditional formatting and not just highlight
cells. |
| E 2.58-2.62 - Make sure you do the Web query to add a new sheet to the
workbook. |
| E 2.63-2.64 - Read to learn how, but do not e-mail the document. |
|
| Excel 3
|
| Access
| Saving in Access is different than Word, Excel, PowerPoint and many
other programs. Think of the filename as a big box (database) to put all
your items in. Then you save objects such as tables, queries, forms, and
reports inside the box into the database window. Click on each of the
object buttons on the left to see that you've saved them. |
| Save the file names with the long filename, but use the names in the
Access Object Name in your Goals & Effort sheet for the objects. |
| Access Chapter 1
|
| Access Chapter 2
| Click here to
see what your Database Windows should look like. |
| Click here to see what your results will look like.
Save all queries with page numbers
for the Project and step numbers for Apply Your Knowledge and Lab.
Some students don't read this and have to go back and redo all of
Access chapter 2. |
| Make sure you understand Figure 2-54 on page A 2.35. Total
Amount is the name of the calculated field (anything before the
colon :). Field names go in square brackets [Amount Paid] and
[Current Due]. Look on your numeric keypad on the far end of
your keyboard. Above the 8 is / for division. * is multiplication. -
is subtraction. + is addition. |
|
| Access 3
|
Word
| Word 1
| WD 1.66 Step 3 - Choose Arial Black instead of Albertus Extra Bold |
|
| Word 2
| WD 2.54 - Read to learn how, but do not e-mail the document. |
|
| Word 3
| WD3.58 - Instead of printing the envelope (remember you don't print
unless Mr. Winter says), click the Add to Document button shown on Figure
3.79. |
|
| Word 4 |
| Word 5 |
|
|