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.

By getting MCAS certified, you can prove your expertise in using the latest Microsoft Office programs and the Windows Vista operating system. Getting certified will help you to differentiate yourself in today’s competitive job market, broaden your employment opportunities by displaying your advanced skills, and result in higher earning potential. Research indicates that certified individuals have increased competence, productivity, and credibility with their employers, co-workers, and clients.

Candidates must pass one certification exam in order to earn the MCAS credential:

1. MCAS: Windows Vista for the Business Worker (Exam 77-600)
2. MCAS: Microsoft Office Word 2007 (Exam 77-601)