The Potter's School

Microsoft Office Applications 3

• Instructor: Bob Madison
• Prerequisite is completion of Microsoft Office Applications 2
• Required Software: Microsoft Office 2007 to include:
1. Word 2007
2. Excel 2007
3. Access 2007
4. PowerPoint 2007
• Books required! Pay close attention to the ISBNs. NOTE: You need two books: either of the Access books and the Projects for the Entrepreneur book. Also, if you are purchasing a used Access book, inform the bookstore that you need the CD that comes with the book. This CD is NOT the MS Office software. It contains all of the files you need to complete the projects and assessments in the book.
• If you are using Windows XP, get the following:
1. Benchmark Series: Microsoft Access 2007 Level 2 - Windows XP Version, with CD Nita Rutkosky et al, EMCParadigm Pub., ISBN: 978-0-76383-003-8
• If you are using Windows Vista or Windows 7, get the following:
1. Benchmark Series: Microsoft Access 2007 Level 2 - Windows Vista Version, with CD Nita Rutkosky et al, EMCParadigm Pub., ISBN: 978-0-76383-069-4
• REQUIRED: Projects for the Entrepreneur Blanc and Vento, Course Technology, Cengage Learning, ISBN: 978-1-4239-0422-9

Course Content Information

We will cover one chapter per week from the Access text book. For each class there will be assessments for the students to do and to submit to me via studyplace. Every four chapters, there will be a performance evaluation which is a timed, open-book set of assessments that will be monitored by a parent. There will be two of these timed performance evaluations in Access.

Level 2 Access 2007

When the students finish the Access portion of the course, they will have used all of the skills necessary to take the official Microsoft Office Specilaist (MOS) exam in Access. They might want to review the Level 1 objectives from the second of the MS Office courses before taking the MOS exam. The MOS exams are optional. For more information on certification exams, click here.

Level 2 Access Topics (Eight Chapters and two Performance Evaluations).

Unit 1: Advanced Tables, Relationships, Queries, and Forms

• Designing the Structure of Tables
• Designing and Building Relationships and Lookup Fields
• Advanced Query Techniques
• Creating and Using Custom Forms
• Unit 1 Performance Evaluation

Unit 2. Advanced Reports, Access Tools, and Customizing Access

• Creating and Using Custom Reports
• Using Access Tools and Managing Objects
• Automating, Customizing, and Securing Access
• Integrating Access Data
• Unit 2 Performance Evaluation

Integrated Projects

For extensive detail on the projects, click here.

How Much Time Will You Spend Per Week in This Course?

This is the most popular question that I get. The honest answer is I don't have a clue. The reason is that all of you are different in the way that you learn. Some of you will need more time than others, and some will need less. But, if I really needed to put an amount of time to this, I would say you will spend 2 to 4 hours per week in this course outside of class.

Hope to "See" you in September! God Bless!