MOS Access 2013

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 2013
• Module 2. Creating Tables
• Module 3. Setting Field Properties
• Module 4. Working with Tables
• Module 5. Editing Tables
• Module 6. Finding and Filtering Data
• Module 7. Creating Relationships
• Module 8. Using Simple Queries
• Module 9. Using Operators in Queries
• Module 10. Modifying Query Results
• Module 11. Designing Advanced Queries
• Module 12. Creating Action Queries
• Module 13. Using Advanced Query Wizards
• Module 14. Creating Basic Forms
• Module 15. Manipulating Form Controls inDesign View
• Module 16. Using Other Form Techniques
• Module 17. Using Advanced Form Design
• Module 18. Creating Basic Reports
• Module 19. Using Controls and Layouts
• Module 20. Using Editing Tools
• Module 21. Using Advanced Report Design
• Module 22. Using Advanced Database Features