Computer Science, asked by prashantjangade7967, 8 months ago

what is data type of roll no. in ms access

Answers

Answered by XxBrainlyLordxX
5

• Fields and Datatypes

Working with Database Fields

Microsoft Access database fields are created by entering a field name and a field data type in each row of the field entry area of the database table window. The field description is an option to identify the fields purpose; it appears in the status bar during data entry. After you enter each field's name and data type, you can specify how each field is used by entering properties in the property area. Before you enter any properties, however, you should enter all of you fields names and data types.

Naming a Database Field

A field name identifies the field to both you and to Microsoft Access. For information regarding field names please see the article: Tables and Fields

Specifying a Microsoft Access Data Type

After you name a field, you must decide what type of data the field will hold. Before you begin entering data, you should have a grasp of the data types that your system will use. Ten basic data types are shown in the table below; some data types (such as numbers) have several options

• For numeric data types, the field size enables you to further define the type of number, which in turn determines the storage size. The table below shows the seven possible settings in the Numeric Field Size property.

You should make the field size the smallest one possible; Access runs faster with smaller field sizes. Note the first three settings don’t use decimal points, but allow increasingly larger positive or negative numbers. Single and Double permit even larger numbers: Single gives you 7 decimal places, and Double allows 15. Use the Double setting when you need many decimal places or very large numbers.

• Caution: If you convert a large FieldSize setting to a smaller one in a field that already contains data, you might lose data. For example, if you change the FieldSize setting for a Text data type field from 255 to 50, data beyond the new 50-character setting will be discarded.

If the data in a Number data type field doesn't fit in a new FieldSize setting, fractional numbers may be rounded or you might get a Null value. For example, if you change from a Single to an Integer field size, fractional values will be rounded to the nearest whole number and values greater than 32,767 or less than –32,768 will result in null fields.

Tip: You can use the Currency data type if you plan to perform many calculations on a field that contains data with one to four decimal places. Single and Double data type fields require floating-point calculation. Currency data type fields use a faster fixed-point calculation.

HOPE

ITZ

HELP

YOU......✌️

PLZ MARK AS BRAINLIST ANSWER.

Answered by rs0117820
0

Answer:

this is the answer

Explanation:

plz follow me if it help and mark me as Brainlist

Attachments:
Similar questions