Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Attaching images

From: Access 2010: Forms and Reports in Depth

Video: Attaching images

The selective use of images throughout your database can accomplish several tasks. They can help your documents conform to company branding standards or reinforce organizational pride. They can also make your database more attractive and give it a bit of personality, may be even make a fun or inspirational for your end-users. Now there are four different ways that we can add unbound images to your forms and reports. And when I say unbound, I mean not connected to a data source like our employees photos were in the last movie. I am going to go ahead and go to this Controls Form, and I will right-click on it to open it in Design View. On the Controls part of the ribbon, we will scroll down and we can find the Image control here.

Attaching images

The selective use of images throughout your database can accomplish several tasks. They can help your documents conform to company branding standards or reinforce organizational pride. They can also make your database more attractive and give it a bit of personality, may be even make a fun or inspirational for your end-users. Now there are four different ways that we can add unbound images to your forms and reports. And when I say unbound, I mean not connected to a data source like our employees photos were in the last movie. I am going to go ahead and go to this Controls Form, and I will right-click on it to open it in Design View. On the Controls part of the ribbon, we will scroll down and we can find the Image control here.

It's one of the mountain and the sun icon. We can also insert images using this button here on the right. When we use this button, Access creates a little gallery of images that we have used previously. So we would save the file here, so I could easily get to it again. Another way we can add an image is using the Logo button which is this button right here. When you use the Logo button, Access automatically formats it and sits it in the header as a logo, and makes a small little icon and it puts it in the header of your form or report. The fourth way we can add an image, is if you go to the Format tab, we have this Background Image here. When you use the Background Image button, Access places an image into the background of the form.

Let's go ahead and go back to the Design tab and we will add an image using the Image control here. I will click on it once, and I get my icon here that changes to a little cursor with the image icon, and I will drag out a box where I want my image. I can always change to the box later. Let's go ahead and go to our Desktop in our Exercise Files, Chapter 3 and we will choose this OlivesOnBranch. Go ahead and say OK. Access places the image inside of the bounding box that I selected. Let me go to the Format tab of the Property Sheet. And if your Property Sheet is not opened, you can press F4, Alt+Enter double-click on the Image control or press the button on the Property Sheet.

Go to the Format tab for the Image. Now there are a couple of properties that I want to take a look at here. The first one is this Size Mode one and it's set to Zoom. With the Size Mode set to Zoom, Access makes the pictures as big as it can, without distorting it inside of the bounding box. For instance, if I change the bounding box to make it narrow, Access fits the image inside of that new bounding box. I will go ahead and make it bigger again. If I change the Size Mode here from Zoom to one of the other options, for instance, Clip, Access puts the image in at full size or a 100% resolution and uses the bounding box as sort of a clipping border.

I can change the alignment, right now we are looking at the center of the image here, Picture Alignment Center. I can change where this image starts in my bounding box, for instance, I can say Top Left, and we will the top left of the image, or Bottom Right and we will see the bottom right image. So I can move the image inside of the bounding box with the Clip Mode. I will go ahead and set this back to Center. Here the Size Mode I want to look at here is Stretch. The Stretch Size Mode distorts the image inside of the bounding box. For instance, if I make it really narrow, you can see that it's squashes the image down. If I make it tall and skinny, it squishes at the other way. I will make it back out here I will change it back to Zoom.

In the Property Sheet we can also see that this image is Embedded right now. We can see Picture Type, Embedded. That means that when we added this image, Access actually put a copy of it inside of our database. We can add links to images instead of embedding everything. And we can do that by going to the Image Control here, clicking on it, drawing a box that we wanted, when the Insert Picture dialog box opens, go ahead and just say Cancel. Access leaves the Image control on the form, but it's not attached anything here, if I look in the Property Sheet. I can change the Picture Type now to Linked, and the Picture Property here where it says none, I will click the Build button here to add the picture.

The Insert Picture dialog box opens again, and I will choose the same one, OlivesOnBranch and say OK. Now I have got a second instance of this image. You can see that the picture source is linked to my hard drive. Now the problem with this is if I move my database or move the image, then you can break the link to this image and it would disappear from my database. The embedded image here would follow the database around but it adds file size to the database. So as a decision, you have to make on how best to proceed when you are using images in your database, whether you want to attach them to the file or link to them on your computer. Let me go ahead and get rid of both of these and we will take a look at another image.

I will click on the first one and press delete and I will click on the second one and press delete. Let's add one more image here; I am going to scroll down. I'll click on Image Control and I will just click once to add an image. This time I am going to choose this tile one, I will press OK, and it adds that into my form. Now I can turn on Picture Tiling right here in the Property Sheet, currently it's to no and I can change that to Yes. I will also change to this Size Mode here from Zoom to Clip. Now when I resize the bounding box, Access tiles multiple copies of the image across to fill up the space. I can go ahead and position this image here, for instance, in the top corner here and stretch it across my form, to add kind of an interesting border affect to the top.

Let's take a look at it in the Form View. I will click on Form View and I will see my border here. Now let me show you how we compare the image control with the attachment feature, so we can stretch this dynamically dependent on the size of the computer that the end user is using. If I go back to the View menu and switch in to Design View, with my image selected, I will go to the Arrange tab, and the Anchoring here, I will say Stretch Across Top. This will dynamically stretch it to whatever size monitor my end-users are using. Okay we will go back to the Home tab, switch to Form View and now it fills up the entire space all the way across. So these are just a few ways that you can use graphics inside of your forms and report designs, adding graphics when done tastefully and especially when it aids legibility, it can take a drab and grey collection of buttons and tables and turn it into an engaging tool for your end-users.

Show transcript

This video is part of

Image for Access 2010: Forms and Reports in Depth
Access 2010: Forms and Reports in Depth

38 video lessons · 14967 viewers

Adam Wilbert
Author

 
Expand all | Collapse all
  1. 1m 27s
    1. Welcome
      1m 2s
    2. Using the exercise files
      25s
  2. 15m 53s
    1. Introducing forms
      2m 41s
    2. Designing for the end user
      45s
    3. Exploring the database
      1m 49s
    4. Creating a form with the Form Wizard
      6m 43s
    5. Refining the form in Layout view
      3m 55s
  3. 24m 33s
    1. Organizing the form elements
      7m 14s
    2. Formatting
      4m 48s
    3. Modifying the form through its properties
      6m 56s
    4. Adding a header and some polish
      5m 35s
  4. 1h 2m
    1. Introducing form controls
      3m 48s
    2. Using lines and rectangles
      2m 48s
    3. Organizing screen space with tabs
      4m 47s
    4. Adding buttons
      5m 3s
    5. Linking to external content
      4m 15s
    6. Entering and selecting data
      5m 8s
    7. Controlling input with option groups
      6m 0s
    8. Attaching documents
      6m 49s
    9. Attaching images
      5m 8s
    10. Understanding the subform control
      4m 13s
    11. Adding charts
      7m 9s
    12. Linking controls
      7m 41s
  5. 21m 42s
    1. Creating the main menu
      8m 49s
    2. Adding a splash screen with startup options
      5m 35s
    3. Creating a customer form
      7m 18s
  6. 45m 20s
    1. Grouping and sorting data
      4m 36s
    2. Understanding report structure
      6m 12s
    3. Building reports from wizards
      5m 0s
    4. Building reports from queries
      6m 34s
    5. Formatting conditionally
      6m 59s
    6. Calculating fields
      4m 35s
    7. Adding the finishing touches
      4m 49s
    8. Populating pre-printed documents
      6m 35s
  7. 15m 8s
    1. Printing reports
      3m 6s
    2. Tweaking the design
      7m 10s
    3. Automating the workflow with macros
      4m 52s
  8. 58s
    1. Next steps
      58s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now Already a member? Log in

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.


Mark all as unwatched Cancel

Congratulations

You have completed Access 2010: Forms and Reports in Depth.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferences from the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.