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.

The Input Mask property is used to change the format of a field having the Text or Date/Time datatype. This property provides the formats for different types of data such as zip-code, phone, date, time, password etc. The InputMask property can be used to make data entry easier and to control the values users can enter in a text box control. When the Input Mask property is set for a field, a user should fill the data in the same format. Any other format is either converted to the given format or remains as it is.

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.