Microsoft Access

Data in databases sometimes require updating, perhaps it is a product name that has changed and needs to be changed in many places or maybe it is a change to the system of stock codes, area codes or perhaps a change to costs of a specific product. In Microsoft Access you can do this using an update query. Gary Schwartz from http://www.jargonfreehelp.com shows us how.

In more recent versions of the Microsoft Office programs there is a greater list of recent files, however, there may be files that you want to make as favourites, you can do this by pinning them to the recent list. Gary Schwartz from http://www.jargonfreehelp.com shows us how.

If you have imported data or just collected data into another table in a database you may need to copy it from the one table to another to consolidate the data. Here using an append query you can do just that. Gary Schwartz from http://www.jargonfreehelp.com shows us how. This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0 For more tutorials see my website http://www.jargonfreehelp.com I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

It is really important that if you are using a delete query you have made a copy or backed up your data. An Access delete query will delete data based on criteria you set. You cannot undo it. It is good, however, for removing old data that is no longer required, although there is usually a backup of it somewhere. Here Gary Schwartz from http://www.jargonfreehelp.com shows us how.

The make table query is really useful for backing up data in Access. You can get it to create a new table based on criteria and save it either in the current database or add it to another Access database. This can help create a snapshot of your data or help speed up your database if you can look through a smaller table. I have also used this to create a lookup table. This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0 For more tutorials see my website http://www.jargonfreehelp.com I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.

Want to get started with Access 2003 then watch this video tutorial by Gary Schwartz from http://www.jargonfreehelp.com

A quick way to search on an Access form is to use a combo box (drop down list). This way you can choose something from the list or it will display options as you type. Here in this video from http://www.jargonfreehelp.com you will find out how to do this. I've seen this come up on the ECDL advanced test for Microsoft Access.

Forms provide you with a way of presenting your data that is in a table or query in a more structured way. It also allows you to add features like drop down lists, option buttons and buttons to run macros or VBA. In this video Gary Schwartz from http://www.jargonfreehelp.com shows us how to create these forms.

When setting a field that is a number in Microsoft Access it is very important to choose the correct number type. Here Gary Schwartz from http://www.jargonfreehelp.com shows you which one to choose.