|  TRAINING SERVICES
 
Home   |  Site Map   |  Careers  
Working Hrs : 8am - 9pm
  Ph. +974 4443 5361 / 4437 0779
Fax. +974 4444 9130
Email: training@fccqatar.com
     
facebook | twitter | LinkedIn | You Tube  
Family Computer Centre - Training Division
  • Become the first Chaos Group Authorized Training Centre (CG ATC) in Qatar
  •  | We are PMI® Accredited global PMP® training provider
  •  | Our PMI® Registered Education Provider (R.E.P.) Id is 2739
  •  | FCC started REVIT courses for architectural design, MEP and structural engineering, and construction
  •  | Family Computer Centre becomes Autodesk authorized certification & Training Centre
  •  | Family Computer Centre joins Pearson VUE Select Network to offer accessible and highly secure certification testing
  •  | Family Computer Centre is an authorized C++ academy to offer certified C++ courses
Courses Offered head
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
      COURSES OFFERED
Download PDF Send an Enquiry
 
M.S Access VBA
Course Duration: 30 Hours

MS Access
Who should do the Course

Using

The Microsoft Access 2010 VBA Training course is designed for experienced Access 2007/2010 users who want to learn advanced VBA programming. In the course students will exchange data with other applications, automate business processes by using VBA code, and learn how to find and fix errors in VBA code.

 
MODULE I: INTRODUCTION & BASICS
Access Application
The development process
Macro / VBA
The VBA IDE
MODULE II: CREATING THE CODE IN VB IDE
Naming Convections
Variables and Data types
Constants and intrinsic constants
Built-in functions
Procedure declaration
Subroutines and functions
Modules
Procedures
Operators and operands
MODULE III: CONTROLLING THE EXECUTION OF PROGRAM

Control Structures
Decision Making
Looping
MODULE IV: USING ACCESS OBJECTS
Object browser
Special Objects
Properties of Objects
Events of Objects
The DAO
DAO V/s ADO
MODULE V: ENHANCE TABLE, FORM AND REPORT USING VBA
Table creation (Using SQL)
Selecting, Closing, Opening, Deleting a table
Opening, Closing, Deleting, Navigating through a Form
Opening, Closing, Deleting, Formatting a report
Switch Board in MS Access
Searching the Database by user defined conditions
MODULE VI: AUTHENTICATING USER
Security
Record Locking
Multiple Users With different Privileges
The DBA
MODULE V: ENHANCE TABLE, FORM AND REPORT USING VBA
Table creation (Using SQL)
Selecting, Closing, Opening, Deleting a table
Opening, Closing, Deleting, Navigating through a Form
Opening, Closing, Deleting, Formatting a report
Switch Board in MS Access
Searching the Database by user defined conditions
MODULE VII: ERROR HANDLING AND DEBUGGING
Error handling
Debugging
Types of errors
Testing
Planning for errors

 
Family Computer Centre,
Al Rayyan Complex, Al Rayyan Road,
P.O.Box 14337, Doha - Qatar,
Ph.(974) 4443 5361 / 4437 0779, Fax. (974) 4444 9130,
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
               
facebook | twitter | LinkedIn | You Tube  
Copyright © Family Computers All Rights Reserved