CIT Skills Assessement (Computer Skills)
This evaluation measures your current knowledge of the chosen topic and helps determine if this course is appropriate for you current skill level. Please check the box which best describes your skill.
"Objectivity Increases Accuracy"
Company
Telphone
First Name
Last Name
Email
Microsoft - Access 2003 Advanced - Specialization
Can Do
Need Help
Cannot Do
1.
Creating macros for data transfer between Access and other applications
2.
Writing SQL statements
3.
Attaching SQL queries to a control in a form
4.
Viewing a crosstab query and using the Crosstab Query Wizard
5.
Creating single-criterion and multiple-criteria parameter queries
6.
Using action queries to append, delete, and modify records in tables and to create a new table
7.
Creating and running macros
8.
Attaching macros to the events of forms and to the command button
9.
Using macros to resize and move forms
10.
Creating data-validation, data-entry, and user-decision macros
11.
Discusssing and examining the SQL statements in Access
12.
Creating AutoKeys and AutoExec macros
13.
Using the Security Wizard to create user groups and to specify permissions on a database and objects
14.
Importing objects form an Access database and a spreadsheet
15.
Exporting objects to another Access database
16.
Exporting and importing XML documents
17.
Linking database objects and updating the links
18.
Using Windows SharePoint Services
19.
Analyzing database performance
20.
Splitting, compacting, repairing, and backing up a database
21.
Replicating and synchronizing databases
22.
Assigning and removing a password from a database
23.
Encrypting and decrypting a database
24.
Creating macros that run a parameter query