MOS Access 2010

Course details

The course empowers the trainee to understand the basic concepts of databases and demonstrate the ability to use a database on a personal computer. The course introduces the skills required to design and plan a database using a standard database package as well as how to retrieve information from an existing database by using queries, select and sort tools available in the data-base. The trainee shall also be able to create and modify forms and reports.

This course prepares the participants for the Microsoft Office Specialist exam.

COURSE OUTLINE

• Module 1. Exploring Access 2010
• Module 2. Customizing the Navigation Pane
• Module 3. Creating Tables
• Module 4. Setting Field Properties
• Module 5. Working with Tables
• Module 6. Editing Tables
• Module 7. Finding and Filtering Data
• Module 8. Creating Relationships
• Module 9. Using Simple Queries
• Module 10. Using Operators in Queries
• Module 11. Modifying Query Results
• Module 12. Designing Advanced Queries
• Module 13. Creating Action Queries
• Module 14. Using Advanced Query Wizards
• Module 15. Creating Basic Forms
• Module 16. Manipulating Form Controls inDesign View
• Module 17. Using Other Form Techniques
• Module 18. Using Advanced Form Design
• Module 19. Creating Basic Reports
• Module 20. Using Controls and Layouts
• Module 21. Using Editing Tools
• Module 22. Using Advanced Report Design
• Module 23. Using Access Database Security
• Module 24. Using Advanced Database Features