How to Scan Documents in Access

By Thomas Buchanan

Plug the scanner into your computer, and Microsoft Access is ready to scan your documents.
i USB image by Angelika Bentin from Fotolia.com

As anyone who has spent any time working in an office can tell you, Microsoft Access is a powerful piece of software. With its ability to create comprehensively detailed databases, forms, and assorted reports while simultaneously automating some of the more complicated data management tasks. Access is an impressive tool indeed. Fortunately, Access also makes it incredibly simple to pull in and sort data from your various hard copy documents as well with just a few easy steps.

Plug the scanner into your computer, typically by a USB drive as is the case for most modern scanners. Place the document facedown onto the bed of your scanner, being sure that none of its corners go outside of the scanning range for a page of its size. Gently close your scanner lid, and, if your scanner requires it, power it on.

Click "Start", then "Program Files" or "All Programs" depending on your version of Windows, and open the folder titled "Microsoft Office." Under "Microsoft Office xxxx Tools", where "xxxx" is the version number of your Office installation, open the program "Microsoft Clip Organizer."

Select "File" in the top left corner and then "Add clips to Organizer" followed by "From Scanner or Camera." Under "Device," select your scanner and then press "Insert". A scanned image of your document will appear in your "My Collections" folder.

Double-click on the form or report for Access that you wish to include this scan within. Once it has loaded, open the document in Design view according to the tabs at the top of the program. Open the "Design" tab, and then load "Controls" and click "Image." Click on the form or report where you want the scan to appear. Then, in the "Insert Picture" box, locate and click on the scan from earlier and select "OK."

×