how to change data type in access

Considering there are so many different types of data, Access offers several different types of fields. A field's data type determines the type of information that can be stored in a field, as shown in figure. Table lists the diverse data types available in Admission.

A field's data type helps forbid data-entry errors considering it restricts what type of information you tin enter in a field. For instance, you cannot enter text in a number information-type field.

A field's data blazon determines what blazon of information the field can store.

If you lot've been working with Admission for a while, you probably already know some of this stuff. Just consider this lesson a quick review.

Brand sure the tblCustomers tabular array is open up in Design view.

First you need to select the field whose data type yous desire to change.
Click the DOB field.

The blinking cursor should announced in the DOB field name. Since the DOB field stores the employee's appointment of nativity, it should be a Appointment/Time field instead of a Text field. Here's how to change a field's data type:
Click the Data Blazon box next to the DOB field.

A listing pointer appears on the right side of the DOB Data Type box.
Click the listing arrow and select Date/Time from the listing.

The DOB field will at present only accept date and time information. The new also makes your database more flexible and powerful because at present you can sort birthdays past appointment or use a person's altogether in a calculationfor example, to determine a person's age.

Once you accept finished modifying a tabular array, you have to salve your changes.
Click the Save button on the toolbar to salve your changes.

Other ways to save a database object are to press Ctrl + S, or select File » Save from the menu.

Data Types

Text

Legal Name: John Doe
Stores text, numbers, or a combination of both, up to 255 characters long. Text fields are the most common of all data types.

Memo

Notes: Emerge displays a loftier amount of...
Stores long text entriesup to 64,000 characters long (the equivalent of 18 pages of text!). Apply memo fields to shop notes or annihilation else that requires a lot of space.

Number

Age: 31
Stores numbers that can be used in calculations.

Date/Time

Birthday: April 7, 1969
Stores dates, times, or both.

Currency

Toll: $84.95
Stores numbers and symbols that represent coin.

AutoNumber

Invoice Number: 187001
Automatically fills in a unique number for each record. Many tables frequently contain an AutoNumber field that is besides used as their primary fundamental.

Yep/No

Employed?: Yep
Stores just one of 2 values, such equally Yes or No, True or Imitation, etc.

OLE Object

Photo:

Stores objects created in other programs such every bit a graphic, Excel spreadsheet, or Word certificate.

Hyperlink

Web Site: www.amazon.com
Stores clickable links to files on your computer, on the network, or to Spider web pages on the Internet.

Lookup Wizard

Purpose of Trip:

A wizard that helps you lot create a field whose values are selected from another table, query, or a preset list of values.

To change the data blazon for a field:

Display the table in design view.
Click the field'due south type box, click the list pointer, and select the data type.

Source: https://www.brainbell.com/tutorials/ms-office/Access_2003/Changing_A_Fields_Data_Type.htm

Posted by: buttsnessiogs93.blogspot.com