As mentioned in the previous section, the Microsoft Access 2010 exam goes into greater depth than the Microsoft Access 2007 exam did. One area in which you can expect to really see a lot more questions has to do with building forms. Although forms were covered on the Access 2007 exam, they were relatively minor topic. However, Microsoft devotes a number of questions on the Access 2010 exam to the creation and management of forms.
Obviously, you will need to know how to use the Form Wizard to create a new form, but you will also need to know how to use the Form Designed Tools. Specifically, you will need to know how to use things such as controls, headers and footers, tool groups, and themes.
This exam also places a heavy emphasis on creating and managing queries. Make sure that you know not only how to construct queries, but also how to add, remove, and rearrange fields. You also need to know how to calculate totals and how to generate calculated fields.
You can also expect to see a lot of questions pertaining to designing reports. Make sure that you know how to use the Report Design Tools and the Report Wizard. As was the case for building forms, you will need to know how to work with headers and footers, tool groups, controls, and themes. You will also need to know how to do things like adding color and background images, performing conditional formatting, and setting up page sizes and page layouts.
Finally, make sure that you have the basics covered. Know how to create and manage databases, as well as how to perform basic maintenance tasks such as compacting, repairing, and encrypting databases.
Recommended Study Resources
There are a variety of study resources available for exam 77-885. Some of the better resources include:
Exam 77-885 Microsoft Access 2010 (Microsoft Official Academic Course)