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:
- Methods of creating databases.
- Various ways of formatting database objects.
- Ways of managing databases.
- Ways of inserting, retrieving, and deleting data.
- Ways of formatting data.
- Use of datatypes.
- Ways of connecting forms and reports to a table in a database.
- Ways of implementing constraints.
- Ways of deleting database objects.
- Ways of implementing indexes.
- Different types of SQL statements.
- Ways of importing and exporting data.
- Different types of views of a table, form, and reports such as Design view.
- Ways of relating tables.
