MOS Access 2007 Central Area, Central

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 is divided in two sections; the first section introduces the skills required to design and plan a simple database using a standard database package; the second section introduces the skills required to retrieve information from an existing database by using the query, select and sort tools available in the data-base. The trainee shall also be able to create and modify reports.

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

COURSE OUTLINE

• Module 1. Creating Tables
• Module 2. Setting Field Properties
• Module 3. Working with Tables
• Module 4. Finding and Filtering Data
• Module 5. Printing Data
• Module 6. Creating Relationships
• Module 7. Using Simple Queries
• Module 8. Modifying Query Results
• Module 9. Using Operators in Queries
• Module 10. Designing Advanced Queries
• Module 11. Using Advanced Query Wizards
• Module 12. Creating Basic Forms
• Module 13. Manipulating Form Controls in Design View
• Module 14. Using Other Form Techniques
• Module 15. Using PivotTables and PivotCharts
• Module 16. Creating Basic Reports
• Module 17. Using Advanced Report Design
• Module 18. Using Advanced Database Features
• Module 19. Using Access Database Security
• Module 20. Exporting Data