Join Adam Wilbert for an in-depth discussion in this video Attaching documents, part of Access 2010: Forms and Reports.
There is plenty of debate on whether you should actually attach files such as…images or Word documents to records within your database.…Some people claim that it leads to database bloat and slowdowns.…The Hyperlink option is definitely a good way to include links to additional…resources without actually embedding everything within the Access Database file itself.…But when you do have tables such as our Employees table here if I right click…on that and go into Design View that have the Attachment and OLE objects field,…let's scroll down here, I have got fields here, one of Attachment and one of the OLE Object.…
If you do use these two data types you will need to know how to actually make…use of them in your forms.…Now in this table we are using Attachment data type to store photos of our…employees and I've also got this other field here called OLE that's using the…OLE object attachment.…Now the OLE object is kind of an older and somewhat more obsolete data type and…it's basically just kept around for backwards compatibility.…
- Designing for the end user
- Organizing form elements
- Formatting a form
- Adding headers
- Linking to external content
- Entering and selecting data
- Adding charts
- Creating a main menu
- Creating a customer form
- Understanding report structure
- Building reports from wizards and queries
- Printing reports
Skill Level Intermediate
Setting Up a Database in Excel 2010with Dennis Taylor43m 23s Appropriate for all
Managing and Analyzing Data in Excel 2010with Dennis Taylor1h 32m Appropriate for all
1. Introduction to Forms
2. Form-Design Basics: Creating a Directory
3. Form and Report Controls
4. Getting around the Database
5. Report Layout
6. Printing, Tweaking, and Automating
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.