Changing from Regular Numbers to Scientific Notation
Changing to Microsoft Access scientific notation is a fairly simple process that usually will not require much help. First, change to design mode for your table. Do this by clicking "Table Tools" above the ribbon and then selecting "Views" and then "Design View."
You now see the design sheet for your table. It will look something like the following image.
Place your cursor in the field you wish to display as scientific notation (in this case the field name is called "National Debt"). In the "Field Properties" section of the screen (toward the bottom), you will see the "Field Size" which in this case is "Double" (very large numbers will usually need to be set as Double. To change this, click on the drop down arrow on the right end of the field.
The "Format" field and click on the drop down arrow. Select "Scientific"
When the "Property Update Options" button appears, click its down arrow and choose "Update Format everywhere NationalDebt is used" (Microsoft Access will insert the name of the field being modified into this sentence). This option makes it very easy to update forms and reports where the "NationalDebt" field is located. When the "Update Properties" window appears, confirm that you want to change the field in the listed locations by clicking the "Yes" button.
Notice that Microsoft Access does not prompt you to update the "NationalDebt" field that is in the query. This is because the query preserves the formatting of the table.
Close the table. Now let's see how Microsoft Access scientific notation looks after making the change. This will be the last step of this Microsoft Access Tutorial.