CompTIA A+ OS/Hardware – 3/28/2006

Tonight we covered the LAST (well, second to last if you count Ch 24 that I skipped) chapter in the book – maintaining WinNT!  On Monday, we’ll have a test over Chapters 11-16, and then cover the “missing chapter” 24.  

Homework:

• Chapter 16 – Questions 1-10

MS Office – 3/28/2006

I turned over the reigns to you guys today as we watched everyone give their PowerPoint presentations.  Everyone did an excellent job, and watching them was a lot of fun.  Hopefully you guys had as much fun as I did!

Homework:

• No homework, be ready to start the Access chapter next week!

Network + Training – 3/28/2006

Today we took Test #3, the last test of the class (excluding the final).  Afterwards, we started in on Transcenders.  Next week, be prepared to do more Transcenders, with the exception that you will need to answer the questions on your own, without any help.  In the meantime, make sure you live and breathe these Transcenders!  

Homework:

• Practice, practice practice!  
• Remember, if you take and pass your Net+ Certification before the end of the class, you get an automatic A!

CompTIA A+ OS/Hardware – 3/27/2006

We discussed Chapter 15 – Windows 9x tonight.  A lot of information was new, but a lot of it wasn’t so hopefully everyone got something out of last night’s class.  Tomorrow night is Chapter 16!  See ya then.

Homework:

• Questions 1-10

MS Word – 3/27/2006

Today we did Chapter Seven, which covers creating Tables of Contents, Figures and Authorities as well as creating Indexes.  This chapter is one of my favorites because it covers some very powerful, time-saving topics.  Hopefully you guys liked it too!

Remember, we have a test next week over Expert Chapters 1-4, and 7.  See ya next time!

Homework:

• Matching 1-11
• Skill Assessment #1

MS Access – 3/22/2006

Today was a “study” day for the test next week, which will be over Chapters 5-7 (NOT chapter 8 as we had previously discussed).  This study day consisted of going through the Skills Assessments that are after Specialist Chapter 8.  I also passed out a study guide, which I’ll include below.

Homework:

• Study, study, study!

Microsoft Access Test Two (Study Guide)

• A PivotTable or PivotChart is a highly specialized, highly customizable way of presenting data that’s contained in a table or query.
• Access database files have the extension .mdb.
• An input mask automatically formats input for you.  You would use an input mask when you want phone numbers or social security numbers to all look the same.  (270) 843-6750.
• If you want to have Access create a form for you by asking you a series of questions (like an interview), you would start the Form Wizard.
• In designing a form, you can “tie” a field to a text box by indicating the field in the text box’s Control Source property.
• Know the proper structure to calculate values in queries using existing fields.  For example, to divide the TotalUnits field by the TotalPrice field you would type [TotalUnits]/[TotalPrice].
• Know the various ways to create tables, forms, and reports.
• Make sure you can do all of the skill assessments in the purple section of your book, just after Specialist Chapter 8.
• Making a forms makes your data entry process easier and more attractive.
• Navigation buttons are the buttons that allow you to navigate from one record to another inside tables, forms and reports.
• Queries allow you to pull up only certain information such as your male customers in Kentucky under the age of 35
• Reports allow you to arrange your data in an easy-to-read format on paper.
• Tables are the basic storage units in a database
• The difference between a page header and a report header is that the page header appears on the top of each page, the report header appears at the beginning of each report.  
• The Object Dependencies task pane allows you to view each object and everything that is tied to it with a relationship.  You can turn this feature on by clicking View, Object Dependencies.
• Turning on the form header can be accomplished by simply clicking View, Form Header/Footer.
• When you export data to a Word file, that Word file has the file extension .doc.
• When you export data to an Excel file, that Excel file has the file extension .xls.
• When you want your Access table to be automatically updated whenever you update a certain Excel file and vice versa, you would link the table to the Excel file.  To do that, you would click on File, Get External Data, Link Tables.
• Your Clipboard task pane allows you to hold up to 24 objects that you can later paste into various Office files.

CompTIA OS/Hardware – 3/21/2006

I’m sitting here while Keith and Amy are dismantling this huge tower of a computer.  We’re done with tonight’s class which discussed the installation and upgrading of various Windows operating systems.  We practiced what I preached by installing Windows XP, which went flawlessly for everyone.  

Homework:

• Chapter 14 – Questions 1-10

MS Office – 3/21/2006

More work today on your presentations.  Remember, they are due next week!

CompTIA Network+ Training – 3/21/2006

We today finished the last two chapters in the book – Chapters 19 & 20.  Be ready for a test next week over Chapters 15-20, and afterwards, we’ll jump right into Transcenders.  

Homework:

• Chapter Nineteen – 1-10
• Chapter Twenty – 1-10

CompTIA OS/Hardware – 3/20/2006

Tonight we covered Chapter 13, which dealt with the command prompt.  Make sure you know how to do the various commands we covered tonight, such as DIR, CD, MD, RD, XCOPY/XMOVE, etc.

Homework:

• Chapter 13 – Questions 1-10