Name:
Company
Department & Manager
Date
Telephone No
Email Address:
Briefly describe your job and how you use or are planning to use Microsoft Access
Please answer this assessment as accurately as possible as your training will be based on the answers.
The course content will depend on your current knowledge, number of days booked and company training requirements.
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.
Are you confident with how to open and save a database?
Are you confident with how to move between records?
Are you confident with how to create a table in Access?
Are you confident with how to format the fields in a table, for example, to make a date field.
Are you confident with entering data into a database table?
Are you confident with filtering data in a table to only show certain records?
Can you confidently set one of the fields in your table to be the primary key?
Are you confident with adding and deleting records?
Are you confident with amending records? For example if somebody changed their surname.
Could you sort the records in a database into ascending order by a field? For example, sort customers in ascending order by their surname.
Are you confident with searching for records in a table?
Can you create a form which displays all of the fields in a table?
Could you confidently create a field in your form that has a drop down box which allows the user to select options?
Can you add a field in your form which allows the user to select a checkbox. For example for Yes or No answers.
Can you use a filter to only display the records that have the yes checkbox ticked?
Are you confident with how to create a query from a table? For example to only show customers that have spent over £1000.
Do you know how this wildcard character * can be used in a query?
Are you confident with how to create a query using fields from more than one table?
Could you create a report based on a query that you have created?
Are you confident with how to change the orientation of your reports?
Are you confident with how to print and print preview your reports?
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.
Comment
Are you confident with how to create a database using a built in template?
Could you confidently change the properties of a field to only accept 16 characters?
Can you create an input mask for a telephone number field in a table to only accept numbers in the following format (01455) 550622?
Can you create an input mask for a customer number field which only accepts codes that start with FF?
Are you confident with how to import data from Microsoft Excel into an Access database?
Can you create a form from a table using the form wizard?
Are you confident with adding a header and footer to a form?
Are you confident with how to create a relationship between two tables so that the data is linked?
Do you know how to view all of the relationships that exist in your database?
Could you create a switchboard which contains a menu that allows users to navigate around your database?
Could you then set your switchboard to appear as soon as your database was opened?
3 Are you confident with how to create a subform within a form?
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?
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]
Are you confident with how to use the expression builder?
Could you create a text box in the form footer to calculate the totals of one of the fields in your form?
Are you confident with how to use functions in a query. For example to count the number of records in a query?
Can you confidently use the Totals row which is available for each record in a query?
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?
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.
Are you confident with how to create a parameter query which asks for more than one value?
Are you confident with how to create a cross tab query to analyse large amounts of data?
Can you use an append query to add a record from one table to the end of another table?
Are you confident with how to add a background picture to a report?
Can you use the format painter to change the format of fields within your reports?
Could you add a button to your form which allows user to close the form?
If you have a particular training requirement and wish to add further details, please enter below.
.gif)
