Home > MS Office Assessments > Access TNA

Access Training Needs Assessment

Name
Company
Department & Manager
Date of Training
Telephone No
Email Address
Which version of Microsoft Access are you currently using? 2007
2010
2013
2016
Unknown
Briefly describe your job and how you use or are planning to use Microsoft Access

How often do you use Microsoft Access? If you have never used Access before or have very basic skills, please complete this question then move to the end of the form and click Submit. Never
Occassionally
Frequently
Are you confident with how to open and save a database? Not Confident
Somewhat, but would like training
Confident
Are you confident with how to move between records? Not Confident
Somewhat, but would like training
Confident
Are you confident with how to create a table in design view? Not Confident
Somewhat, but would like training
Confident
Are you confident with how to create a table using the wizard? Not Confident
Somewhat, but would like training
Very Confident
Are you confident with how to format the fields in a table, for example, to make a date field. Not Confident
Somewhat, but would like training
Confident
Are you confident with entering data into a database table? Not Confident
Fairly Confident
Very Confident
Are you confident with filtering data in a table to only show certain records? Not Confident
Somewhat, but would like training
Confident
Can you confidently set one of the fields in your table to be the primary key? Not Confident
Somewhat, but would like training
Confident
Are you confident with adding and deleting records? Not Confident
Somewhat, but would like training
Confident
Are you confident with amending records? For example if somebody changed their surname. Not Confident
Somewhat, but would like training
Confident
Could you sort the records in a database into ascending order by a field? For example, sort customers in ascending order by their surname. Not Confident
Somewhat, but would like training
Confident
Are you confident with searching for records in a table? Not Confident
Somewhat, but would like training
Confident
Can you create a form which displays all of the fields in a table? No
Somewhat, but would like training
Yes
Could you confidently create a field in your form that has a drop down box which allows the user to select options? Not Confident
Somewhat, but would like training
Confident
Can you add a field in your form which allows the user to select a checkbox. For example for Yes or No answers. No
Somewhat, but would like training
Yes
Can you use a filter to only display the records that have the yes checkbox ticked? Not Confident
Somewhat, but would like training
Confident
Are you confident with how to create a query from a table? For example to only show customers that have spent over £1000. Not Confident
Somewhat, but would like training
Confident
Do you know how this wildcard character * can be used in a query? No
Somewhat, but would like training
Yes
Are you confident with how to create a query using fields from more than one table? Not Confident
Somewhat, but would like training
Confident
Could you create a report based on a query that you have created? Not Confident
Somewhat, but would like training
Confident
Are you confident with how to change the orientation of your reports? Not Confident
Somewhat, but would like training
Confident
Are you confident with how to print and print preview your reports? Not Confident
Somewhat, but would like training
Confident

If you have answered No, Not Confident or Somewhat, but would like training to the majority of the questions so far and are happy to study Level 1, please complete this question then click Submit at the end of the form. If you wish to add any comments for the trainer please add below. Alternatively continue with the questions.

I wish to study Access Level 1
Comment
Are you confident with how to create a database using a built in template? Not Confident
Somewhat, but would like training
Confident
Could you confidently change the properties of a field to only accept 16 characters? No
Somewhat, but would like training
Yes
Can you create an input mask for a telephone number field in a table to only accept numbers in the following format (01455) 550622? No
Somewhat, but would like training
Yes
Can you create an input mask for a customer number field which only accepts codes that start with FF? No
Somewhat, but would like training
Yes
Are you confident with how to import data from Microsoft Excel into an Access database? Not Confident
Somewhat, but would like training
Confident
Can you create a form from a table using the form wizard? No
Somewhat, but would like training
Yes
Are you confident with adding a header and footer to a form? Not Confident
Somewhat, but would like training
Confident
Are you confident with how to create a relationship between two tables so that the data is linked? Not Confident
Somewhat, but would like training
Confident
Do you know how to view all of the relationships that exist in your database? No
Somewhat, but would like training
Yes
Could you create a switchboard which contains a menu that allows users to navigate around your database? No
Somewhat, but would like training
Yes
Could you then set your switchboard to appear as soon as your database was opened? No
Somewhat, but would like training
Yes

If you have answered No, Not Confident or Somewhat, but would like training to the majority of the questions so far and are happy to study Level 2 please complete this question then click Submit at the end of the form. If you wish to add any comments for the trainer please add below. Alternatively continue with the questions.

I wish to study Access Level 2
Are you confident with how to create a subform within a form? Not Confident
Somewhat, but would like training
Confident
Are you confident with how to change the properties of a subform, for example so that it displays the data in rows rather than a standard form view? Not Confident
Somewhat, but would like training
Confident
Can you create a calculated control within a form that took two fields and multiplied them to display a result? For example, Total = [Quantity]*[Unit Price] No
Somewhat, but would like training
Yes
Are you confident with how to use the expression builder? Not Confident
Somewhat, but would like training
Confident
Could you create a text box in the form footer to calculate the totals of one of the fields in your form? No
Somewhat, but would like training
Yes
Are you confident with how to use functions in a query. For example to count the number of records in a query? Not Confident
Somewhat, but would like training
Confident
Can you confidently use the Totals row which is avalible for each record in a query? No
Somewhat, but would like training
Yes
Are you confident with how to create your own expression in a query. For example a field that displays the total of two of the other fields in your query? Not Confident
Somewhat, but would like training
Yes

Are you confident with how to create a parameter query? This is a query that prompts the user for a value each time the query is executed. Not Confident
Somewhat, but would like training
Confident
Are you confident with how to create a parameter query which asks for more than one value? Not Confident
Somewhat, but would like training
Confident
Are you confident with how to create a cross tab query to analyse large amounts of data? Not Confident
Somewhat, but would like training
Confident
Can you use an append query to add a record from one table to the end of another table? No
Somewhat, but would like training
Yes
Are you confident with how to add a background picture to a report? Not Confident
Somewhat, but would like training
Yes
Can you use the format painter to change the format of fields within your reports? No
Somewhat, but would like training
Yes
Could you add a button to your form which allows user to close the form? No
Somewhat, but would like training
Yes
If you have a particular training requirement and wish to add further details, please enter below.