Microsoft Access 2007 Basic & Intermediate

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.

COURSE OUTLINE

• Module 1. Exploring Access
• 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. Using Simple Queries
• Module 8. Modifying Query Results
• Module 9. Using Operators in Queries
• Module 10. Creating Relationships
• Module 11. Creating Basic Forms
• Module 12. Using Design View
• Module 13. Creating Basic Reports
• Module 14. Using Advanced Report Design