Microsoft Office for Professional Users

Description

Students will advance their Microsoft Office skills by exploring more advanced topics in Word, Excel and Access. In Word students will create newsletters, web pages and macros. In Excel, students will create 3-D workbooks and link Excel files, create formulas using the financial functions, manage worksheets that contain databases and create macros. In Access, students will create relational databases, and create queries, forms and reports that use relational databases. Students will be introduced to Access macros and VBA. Students will need a basic understanding of Word, Excel and Access to complete this class. Students will need a copy of Office. A 30-day trial version is available.

Objectives

• Students will demonstrate what they can do with Microsoft Office
• Students will use Microsoft Word to create newsletters and web pages.
• Students will use Microsoft Word to create forms and master documents.
• Students will use Microsoft Excel to create three dimensional spreadsheets and to track spreadsheet data using scenarios.
• Students will use Microsoft Excel to manage data and automate repetitive tasks.
• Students will use Microsoft Access to design forms with subforms and create queries that combine data from multiple tables.
• Students will use Microsoft Access to create macros and VBA applications to improve data entry and to automate tasks.
• Students will use VBA to create message and input boxes.
• Students will use VBA to create macros in Word, Excel and Access.
• Students will create a project that uses what they have learned in this course.

Book

Lesson 1: Getting Started

Review

Lesson 2: Microsoft Word

Read Microsoft Word chapters 5 and 6

Lesson 3: Microsoft Word

Read Microsoft Word chapter 7

Lesson 4: Microsoft Excel

Read Microsoft Excel Chapters 5 and 6

Lesson 5: Microsoft Excel

Read Microsoft Excel chapter 7 and pages 367 - 378 of chapter 8.

Lesson 6: Microsoft Access

Read Microsoft Access Chapters 5 and 6

Lesson 7: Microsoft Access

Read Microsoft Access Chapter 7

Lesson 8: VBA

Read A VBA Primer, pp. 1 - 40.

Lesson 9: VBA

Read A VBA Primer, pp. 40 - 62.

Also go back and review or work any of these that interest you.

Word, Chapter 7, pp 332- 344.

Excel, Chapter 8.

Access, Chapter 8.

Lesson 10: Putting it all Together

Review the book

All content of this document is copyrighted by IDEA Solutions and the author. All rights reserved. Content may not be used without permission.