MOS - Microsoft  ® Office Access 2010

Course details

Microsoft ® Access 2010 teaches the participants to design data tables, select appropriate data types and relate tables logically. Participants will create and modifydatabase objects including tables, forms, reports, queries and macros and will apply intermediate skills to streamline data entry, ensure data integrity, automatetasks and analyze data. Participants will use the Expression Builder to create expressions and insert identifiers as property settings, use advanced form controls to locateinformation and restrict data entry and will set form properties that respond to events.

Prerequisite:

• Working knowledge on computing and desktop application (windows).

Certificate of Attendance :

• Certificate of Attendance will be issued to participants completing the course achieving minimum 75% attendance. 

Training Methodology & Materials:

• Practical hands-on sessions, 75% lab-based and 25% theory-based.
• Well-designed labsessions to enhance further understanding of the courseware

Course Outline:

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