Which field type can store photos? A. Hyperlink B. OLE C. Both of these can be used D. Access tables can’t store photos

Hyperlink
OLE
Both of these can be used
Access tables can't store photos

The correct answer is: Both of these can be used.

A hyperlink is a field type that can store a URL, which is a web address. When you click on a hyperlink, it will open the web page that is associated with the URL.

OLE is a field type that can store an object, such as a picture, document, or spreadsheet. When you click on an OLE object, it will open the application that is associated with the object.

Both hyperlinks and OLE objects can be used to store photos in Access tables.


Hyperlink

A hyperlink is a field type that can store a URL, which is a web address. When you click on a hyperlink, it will open the web page that is associated with the URL.

To create a hyperlink field, follow these steps:

  1. In the Design view of the table, click in the field where you want to create the hyperlink.
  2. In the Field Properties window, click the Data Type arrow and select Hyperlink.
  3. In the Display As box, type the text that you want to appear in the table.
  4. In the Value box, type the URL of the web page that you want to link to.

OLE

OLE is a field type that can store an object, such as a picture, document, or spreadsheet. When you click on an OLE object, it will open the application that is associated with the object.

To create an OLE field, follow these steps:

  1. In the Design view of the table, click in the field where you want to create the OLE field.
  2. In the Field Properties window, click the Data Type arrow and select OLE Object.
  3. In the Display As box, type the text that you want to appear in the table.
  4. In the Value box, leave it blank.

Access tables can’t store photos

This option is incorrect because Access tables can store photos using either hyperlinks or OLE objects.

Exit mobile version