MOS Access 2010

Course details

Microsoft® Access 2010 Core teaches students how to design data tables, select appropriate data types and relate tables logically. Students will create and modify database objects including tables, forms, reports, queries and macros, and will apply intermediate skills to streamline data entry, ensure data integrity, automate tasks and analyze data. Students will use the Expression Builder to create expressions and insert identifiers as property settings, use advanced form controls to locate information and restrict data entry, and will set form properties that respond to events.Students who complete this course will have reviewed all of the exam objectives and be on their way to preparing for Microsoft Access 2010 Core Exam #77-885.

Course Prerequisites

This course is designed for studentswho arefamiliar with personal computers, using a keyboard and using a mouse. The course assumes that students have completed the Microsoft Windows course or have equivalent Microsoft Windows knowledge and experience.

• start and run Windows
• use the taskbar
• use the Start button
• use the Help feature
• use Minimize, Restore Down/Maximize, or Close
• use the left and right mouse buttons appropriately
• understand file management techniques
• navigate between files, folders, or drives

About This Courseware

• Lesson 1: Exploring the Access Environment
• Lesson 2: Building Tables
• Lesson 3: Retrieving the Data You Want
• Lesson 4: Working with Forms
• Lesson 5: Designing Reports

Appendices

• Appendix A: Courseware Mapping
• Appendix B: Glossary of Terms
• Appendix C: Index