Creating an Attachment Field

Databases can contain information about business transactions, but there’s a lot more to business than simple numerical and text values. If you work with paper invoices, purchase orders, or correspondence, you can scan those documents into electronic form and attach the documents to the record to which the documents are related. Alternatively, if you have another file (such as a Word document, product image, or Excel workbook) that’s related to the item described by the record, you can also attach those files to the record.

Create an Attachment Field

  1. Open a table in Design view.

  2. Click the field to define as an attachment ...

Get Microsoft® Office Access™ 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.