Access 2016 Intermediate

Access 2016

Lesson 1 – Setting Field Properties

Format

Description

General Number

Displays a number exactly as it is entered; this is the default format Displays a dollar sign, a thousands separator, and two decimal places; the defaults for this format are determined by the system settings Displays a euro sign, a thousands separator, and two decimal places; the defaults for this format are determined by the system settings Displays at least one digit and is rounded to the default number of decimal places; the defaults for this format are determined by the system settings Displays a thousands separator and is rounded to the default number of decimal places; the defaults for this format are determined by the system settings Multiplies the number by 100, displays a percent sign (%), and is rounded to the default number of decimal places; the defaults for this format are determined by the system settings Expresses numbers in standard scientific notation (as multiples of exponents of 10)

Currency

Euro

Fixed

Standard

Percent

Scientific

Selecting a number format

OFFICEPRO, Inc.

Page 7