Difficulty: Moderately Easy
Things You’ll Need:
- Microsoft Access 2003
- Computer
Step1
Create an OLE field within a database. Open the table you will be using in "Design View."
Step2
In the first blank row of the design tool, enter the appropriate type of field under "Field Name."
Step3
Click on the next field in the "Data Type" column. Select "OLE Object" from the dropdown menu.
Step4
Save the table and close it. Reopen the table in "Datasheet" view.
Step5
Right-click in the data field that contains your OLE object. Select "Insert Object" from the menu. You will be given a choice of objects and applications. You can create a new picture, document or chart, or open existing ones.
Step6
Once selected, the appropriate application will start. You will can open, create and save the type of object you wish to insert. You may choose "Display as Icon" if you wish to see an icon representing your object.
Step7
Saving your project or database implements your changes.