|
Skills:
|
Not
Confident
|
Very
Confident
|
| 0 |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
| Navigate Windows |
|
|
|
|
|
|
|
|
| Use a mouse and keyboard |
|
|
|
|
|
|
|
|
| Open, close, and save files |
|
|
|
|
|
|
|
|
| |
0 |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
| Work with database objects (tables, queries, forms, reports) |
|
|
|
|
|
|
|
|
| Understand the basics of key fields and relationships |
|
|
|
|
|
|
|
|
| Explore different object views |
|
|
|
|
|
|
|
|
| Create a blank database using the Database wizard |
|
|
|
|
|
|
|
|
| Create a table |
|
|
|
|
|
|
|
|
| Modify table design and set field properties |
|
|
|
|
|
|
|
|
| Sort and filter records |
|
|
|
|
|
|
|
|
| Create a select query |
|
|
|
|
|
|
|
|
| Use queries to perform calculations |
|
|
|
|
|
|
|
|
| Create and modify forms |
|
|
|
|
|
|
|
|
| Locate, filter and organize records using forms |
|
|
|
|
|
|
|
|
| Create and print a report |
|
|
|
|
|
|
|
|
| Import and export XML documents |
|
|
|
|
|
|
|
|
| |
0 |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
| Establish table relationships |
|
|
|
|
|
|
|
|
| Work with and maintain referential integrity |
|
|
|
|
|
|
|
|
| Create and modify look up lists |
|
|
|
|
|
|
|
|
| Utilize subdatasheets |
|
|
|
|
|
|
|
|
| Index tables |
|
|
|
|
|
|
|
|
| Establish field properties such as input masks, validation rules, and default values |
|
|
|
|
|
|
|
|
| Create outer join and self join queries |
|
|
|
|
|
|
|
|
| Work with Crosstab queries |
|
|
|
|
|
|
|
|
| Design Create, Append, and Make-Table queries |
|
|
|
|
|
|
|
|
| Perform calculations within forms |
|
|
|
|
|
|
|
|
| Enhance a form with conditional formatting, charts and various functions |
|
|
|
|
|
|
|
|
| |
0 |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
| Create and modify PivotTables and PivotCharts |
|
|
|
|
|
|
|
|
| Incorporate startup forms within a database |
|
|
|
|
|
|
|
|
| Create and attach macros to database objects |
|
|
|
|
|
|
|
|
| Use AutoKey and AutoExec macros |
|
|
|
|
|
|
|
|
| Perform database optimization tasks |
|
|
|
|
|
|
|
|
| Replicate and synchronize a database |
|
|
|
|
|
|
|
|
| Incorporate database security and user level security |
|
|
|
|
|
|
|
|
| Work with modules |
|
|
|
|
|
|
|
|
| Understand MDE files |
|
|
|
|
|
|
|
|