Update Queries

This video explains how to add an update query in Microsoft Access. Update query. The tutor covers how to do two update queries. The first update query uses a calculation to increase wages by 10%. The second update query covers how to update a date checked field. The tutor uses parameter queries to explain how the update works. The parameter query gives more flexibility when running an update. The tutor also warns that an update query when run will update data, so if a user is not sure don’t run it. This is a Microsoft Access tutorial covering Update query, parameter query and calculations.

Vlookup in 60 seconds

This video explains how to create a Vlookup. This is a 60 second preview on how to create a Vlookup in Microsoft Excel. The tutor uses named cells and named ranges to explain how a Vlookup works. This is a Microsoft Excel tutorial covering Vlookup, named cells and named ranges. Vlookup in 60 secs.