Microsoft Certified Application Specialist (MCAS)

The Microsoft exam 77-605 consists of simulation questions. In the simulation type questions, you will be given an environment of Microsoft Access 2007 and you have to perform a given task. The Microsoft test 77-605 measures your ability to design databases and database objects. Before taking the 77-605 test, you should practice the following:

1. Methods of creating databases.
2. Various ways of formatting database objects.
3. Ways of managing databases.
4. Ways of inserting, retrieving, and deleting data.
5. Ways of formatting data.
6. Use of datatypes.
7. Ways of connecting forms and reports to a table in a database.

A module is a collection of user-defined functions, subroutines, and global variables written in VBA code. These objects can then be used/called from anywhere in your Access database. In MS Access, all code is stored in “Modules”. Most of these Modules are associated with Forms and Reports. In other words, modules are used to make routines re-usable. A collection of re-usable routines is sometimes called a library.