Access courses Access Training computer training Free IT Training Resources

Access courses

Access courses for update queries

Microsoft Access courses are delivered in two formats, classroom based and online based.  If you wish to complete an online course check out . Classroom based course details can be found here.

You can assess your knowledge levels by completing the Excel document here Check Skill Level Once you have completed the document email to You can book courses via email or by calling 01670 732139.

Prices and location can be found here General information about IT’s Easy Training and delivery methods can be found here

Update Queries

This video explains how to create an update query and how to qualify the query with a filtered field. The tutorial mentions that an update query does not display the result of the query, as is the case with a basic select query. An update query carries out the request and changes the data in the underlying table. It is very important that users understand that an update query can be dangerous if clicked and ran without understanding what will happen. Each time the query runs the data may be changed.

The example shown uses the parameter query feature to demonstrate the best way to create a flexible query. The parameter query uses the small square bracket symbols displayed on the keyboard to provide space for a data entry prompt. [Enter the city] for example.

Calculations in a query

The video explains how to create a calculation at query level. The example shown is a simple divide and multiplication calculation. This information is covered on the intermediate and advanced Access courses. Details can be found here.