Microsoft Access

Training Needs Questionnaire:
Microsoft Access

 
|   Home    |    Training    |    TNAs  |   Courseware   |   Course Outlines   |   About   |   Contact   |   Index   |
   
  The answers you give in this questionnaire will be used to evaluate your experience of using Microsoft Access and to help plan an appropriate schedule of training. The questions are divided into a number of sections covering the different functions of the program. Items marked with a red asterisk (*) must be filled in.

After completing the questionnaire, click the Submit Questionnaire button at the bottom of the page. If you wish to print a copy of this questionnaire for your own reference, you can click here or scroll to the bottom of the page and click the Print button.

About You

Please supply some information about yourself...

*First Name:
  
*Last Name:
  
*E-mail address:
 
 Company Name:
  
 Job Title:
  
 

About Your Current Knowledge of Access

To answer the questions in this section simply place a tick in the box next to the item if you can say "I know how to do this" or "I am confident in doing this task". If you are not confident in performing the task, or have never done it or don't know what it is, leave the box empty.

Working with Access Tables

Tick the boxes where you can confidently say "I know how to..."
 Build a table in design view  Set or change field properties  Set a Primary Key field
 Create a drop-down (lookup) list  Use an OLE field  Use a Hyperlink field
 Create an Index for a table  Create relationships between tables  Enforce Referential Integrity
 Link to a table in another database  Import data from Excel or a text file  Make a copy of a table
     
Tick the boxes where you think "I would like to learn more about..."
 Table design  Validation rules  Creating indexes
 Number data types  Indexing fields  Using relationships
 Input masks  Using Lookups  Referential integrity
     
If there is any other aspect of Access Tables that you do not understand or would like
to learn more about, please indicate your requirements in the box below:

Working with Access Queries

Tick the boxes where you can confidently say "I know how to..."
 Build a query in design view  Use a Make Table query  Use an Append query
 Use a Delete query  Use an Update query  Build a Crosstab query
 Add a calculated field to a query  Use the Totals tool  Use the Build tool
 Create a Parameter query    
     
Tick the boxes where you think "I would like to learn more about..."
 Query criteria  Calculated fields  Working with dates
 Action queries  Using totals  Parameter queries
 Crosstab queries    
     
If there is any other aspect of Access Queries that you do not understand or would like
to learn more about, please indicate your requirements in the box below:

Working with Access Forms

Tick the boxes where you can confidently say "I know how to..."
 Build a form in design view  Put a Combo Box on a form  Use a List Box on a form
 Use an Option Group on a form  Use a Tab Control on a form  Use a Command Button on a form
 Use an ActiveX control on a form  Create a calculated field on a form  Build a form with a Sub Form on it
 Build a Switchboard  Build a Splash Screen  Build a Dialog Box
 Change the properties of a control  Change the properties of a form  Set the Tab Order of a form
     
Tick the boxes where you think "I would like to learn more about..."
 Form design  Option Groups  Control Properties
 Combo boxes  ActiveX controls  Form properties
 List boxes  Command buttons  
     
If there is any other aspect of Access Forms that you do not understand or would like
to learn more about, please indicate your requirements in the box below:

Working with Access Reports

Tick the boxes where you can confidently say "I know how to..."
 Build a report in design view  Set Grouping Levels on a report  Put a Page Break on a report
 Put page numbers on a report  Add totals or subtotals to a report Build a sub-report on a report
 Create a chart on a report  Export a report to Word or Excel  
     
If there is any other aspect of Access Reports that you do not understand or would like
to learn more about, please indicate your requirements in the box below:

Working with Access Macros

Tick the boxes where you can confidently say "I know how to..."
Build an Access Macro  Create an AutoExec macro  Assign a macro to a command button
 Assign a macro to a control event Apply conditions to a macro Convert a macro to VBA code
     
If there is any other aspect of Access Macros that you do not understand or would like
to learn more about, please indicate your requirements in the box below:

Access Database Management

Tick the boxes where you can confidently say "I know how to..."
 Set Start Up options for a database  Set a Database Password  Set up Database Security permissions
 Compact a database  Replicate and Synchronise a database  Split a database
     
If there is any other aspect of Access Database Management that you do not understand or would like
to learn more about, please indicate your requirements in the box below:


Thank you for completing the Microsoft Access Training Needs questionnaire.
Please click the Submit Questionnaire button.

 

^ top

 
  2006 Martin Green. All rights reserved. Contact: training@fontstuff.com