Question

Which of the following field type is similar to the text field but the characters are not displayed to the user? *​

Answer 1

Answer:

For more information about creating and using lookup fields, see the article Create or delete a multivalued field.

Finally, data types provide a basic form of data validation because they help ensure that users enter the proper types of data in your table fields. For example, you cannot enter text in a field set to accept only numbers.

Change data types

Before you follow these steps, remember that changing a data type might truncate (cut off) some or all of the data in a field, and in some cases may remove the data entirely. For information about how Access changes data when you change a data type, see the section Restrictions on changing data types, later in this article.

Note: In Access, you can set the data types for your table fields by working in either Datasheet view or Design view. Steps in this section explain how to set the data type in both views. When you set data types in Design view, you see an extra choice, Lookup Wizard. That choice is actually not a data type. Instead, you use the Lookup Wizard to create lookup fields, which link foreign key fields to other tables. By default, Access sets lookup fields to the Number data type.

Change data types in Datasheet view

In the Navigation Pane, locate and double-click the table that you want to change.

Access opens the table in Datasheet view.

Select the field (the column) that you want to change.

On the Fields tab, in the Properties group, click the arrow in the drop-down list next to Data Type, and then select a data type.

Save your changes.