View data types by using commands on the Datasheet tab The data type set for each table field provides the first level of control over what you can and cannot enter into a field.In some cases, a data type setting prevents you from entering any information at all.You use this type of field when you want to display data from a file created in another program.For example, you can display a text file, an Excel chart, or a Power Point slide deck in an OLE Object field.In turn, those design principles affect how you enter data.Remember these facts about database objects and design as you proceed.For information about entering new data in a database, see the article Add one or more records to a database.Read this section if you are new to Access or unfamiliar with the concepts behind relational databases.
When you click a field that is set to this data type, Access displays either a check box or a drop-down list, depending on how you format the field.
You can use the commands on the Datasheet tab, or you can open the table in Design view.
The following sets of steps explain how to use both techniques.
You can enter any data in this type of field, and Access wraps it in a Web address.
For example, if you type a value in the field, Access surrounds your text with Uniform Resource Locator (URL) text, like so: