PRACTICE SOLUTIONS GRADED A+
● Long Text. Answer: used to store larger amounts of text. This data
type is limited to 65,536 characters and can contain any combination of
letters, numbers, and symbols.
● Number. Answer: used to store positive and negative numbers, may
contain decimal places, must be used when you expect to perform
calculations on the data in a field.
● Date/Time. Answer: used to store date or time information. can be
formatted to display dates or times several different ways.
● Currency. Answer: data type is a Number data type that places a
currency symbol ($) in front of the number.
● AutoNumber. Answer: a Number data type. As the name implies,
Access will automatically insert that value for the field when a new
record is added to a table. can be set to add 1 to the last number used for
the field or it can assign a randomly generated number. In either case,
will insert a unique value for each record added.
● Yes/No. Answer: used to store data that has only two possible values
such as yes or no, true or false, and on or off.