Skill Sets: Activities
Access 2000 Advanced
| ACCESS 2000 EXPERT USER SKILL SETS FOR Microsoft Office Specialist CERTIFICATION This table below lists the skill sets and activities performed by individuals as Expert Users. |
|
Skill Sets: Activities |
Access 2000 Advanced |
| Building and modifying tables | |
| Set validation text |
|
| Define data validation criteria | |
| Modify an input mask | |
| Create and modify Lookup Fields | |
| Optimize data type usage (double, long, int, byte, etc.) | |
| Building and modifying forms | |
| Create a form in Design View | |
| Insert a graphic on a form | |
| Modify control properties | |
| Customize form sections (headers, footers, detail) | |
| Modify form properties | |
| Use the Subform Control and synchronize forms | |
| Create a Switchboard | |
| Refining queries | |
| Apply filters (filter by form and filter by selection) in a query's recordset | |
| Create a totals query | |
| Create a parameter query | |
| Specify criteria in multiple fields (AND vs. OR) | |
| Modify query properties (field formats, caption, input masks, etc.) | |
| Create an action query (update, delete, insert) | |
| Optimize queries using indexes | |
| Specify join properties for relationships |
|
| Producing reports | |
| Insert a graphic on a report |
|
| Modify report properties |
|
| Create and modify a report in Design View |
|
| Modify control properties |
|
| Set section properties |
|
| Use the Subreport Control and synchronize reports |
|
| Defining relationships | |
| Establish one-to-one relationships |
|
| Establish many-to-many relationships |
|
| Set Cascade Update and Cascade Delete options |
|
| Utilizing web capabilities | |
| Create hyperlinks |
|
| Use the group and sort features of data access pages |
|
| Create a data access page |
|
| Using Access tools | |
| Set and modify a database password |
|
| Set startup options |
|
| Use Add-ins (Database Splitter, Analyzer, Link Table Manager) |
|
| Encrypt and Decrypt a database |
|
| Use simple replication (copy for a mobile user) |
|
| Run macros using controls |
|
| Create a macro using the Macro Builder | |
| Convert database to a previous version | |
| Data Integration (New Skill Set) | |
| Export database records to Excel | |
| Drag and drop tables and queries to Excel | |
| Present information as a chart (MS Graph) | |
| Link to existing data | |
| Back to top | ||
| Back to Microsoft Office Specialist for Office 2000 | ||
 | ||
|