MOS Access 2007

Course details

Microsoft® Office Access 2007 teaches students how to create simple databases, create and modify database objects including tables, forms, reports and queries. You will use a variety of commands, functions, and Microsoft Office Access 2007 capabilities. It is designed for computer users who are new to database programs or who only plan to use Access occasionally.Students who complete this course will have reviewed all of the exam objectives and be on their way to preparing for a Microsoft Office Specialist Exam #77-605.

Course Length

The Microsoft Business Certification Series can adapt to meet various course length requirements. There are two types of exercises in this book: Learn the Skill and Practice the Skill (refer to the Conventions and Graphics section to identify the different icons used for each type).For the shortest course lengths, students can perform just the Learn the Skill exercises. For longer course lengths, students can complete both the Learn the Skill and Practice the Skill exercises.Instructors should refer to the Instructor Resources for this book to learn more about how the material can be adapted.

Course Prerequisites

This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse.The course assumes that students have completed the Microsoft Windows Level 1 course or have equivalent Microsoft Windows knowledge and experience.Students who wish to become proficient using the features of Microsoft Office Access 2007 will benefit from taking this course.

Course Outline

About This Courseware

• Lesson 1: Introducing Access
• Lesson 2: Creating and Modifying Tables
• Lesson 3: Manipulating a Table
• Lesson 4: Data Manipulations
• Lesson 5: Sorting and Filtering
• Lesson 6: Select Queries
• Lesson 7: Relating Multiple Tables
• Lesson 8: Maintaining Databases
• Lesson 10: Working with Reports
• Lesson 11: Advanced Table Design
• Lesson 12: Advanced Queries
• Lesson 13: Advanced Forms and Reports
• Lesson 14: Customizing Forms and Reports
• Lesson 15: Using Subforms and Subreports

Appendices

• Appendix A: A Quick Review of the Basics
• Appendix B: Apply the Skill Exercises
• Appendix C: Answers to Review Questions
• Appendix D: Courseware Mapping
• Appendix E: Glossary of Terms
• Appendix F: Index