 |
Microsoft Access 2007 Core Requirements for Microsoft Certified Application Specialist Exam 77-605 |
| Essential Skills measured by Exam 77-605 | |
| Structuring a Database | |
| Define data needs and types. Define and print table relationships. Add, set, change, or remove primary keys. Split databases. |
|
| Creating and Formatting Database Elements | |
| Create databases. Create tables. Modify tables. Create fields and modify field properties. Create forms. Create reports. Modify the design of reports and forms. |
|
| Entering and Modifying Data | |
| Enter, edit, and delete records. Navigate among records. Find and replace data. Attach documents to and detach from records. Import data. |
|
| Creating and Modifying Queries | |
| Create queries. Modify queries. |
|
| Presenting and Sharing Data | |
| Sort data. Filter data. Create and modify charts. Export data. Save database objects as other file types. Print database objects. |
|
| Managing and Maintaining Databases | |
| Perform routine database operations. Manage databases. |
|
 |