Temperature Conversion Tool for Microsoft Access

In this Microsoft Access tutorial, I'm going to teach you how to enter temperature readings in any scale, whether it's Fahrenheit, Celsius, or Kelvin, and be able to convert between all three at the same time.

Daisy from Atlanta, Georgia (a Platinum Member) asks: I loved your lesson on converting between Fahrenheit and Celsius, but that assumes you're always getting readings in one or the other. In my lab, we can sometimes get temperatures in any of the three scales (F, C, or K), and we have to be able to convert to the other ones. So, is there a way to have it so the user specifies the scale when they add the value to the table?

Prerequisites

• F to C
• Switch Function
• Value List Combo

Links

• Validation Rules
• Tab Stop, Order, Cycle

Up Next

• F, C, or K, Part 2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, temperature conversion, enter temperature scale, Celsius to Fahrenheit, Fahrenheit to Kelvin, Kelvin to Celsius, convert temperature Access, lab temperature management, Access temperature database, specify temperature scale Access, temp value field, temperature conversion form, combo box selection, Access switch function, temperature unit conversion, Access form tutorial, Access sample database