Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Access 2010 Power Shortcuts, Access expert Alicia Katz Pollock shares hundreds of tips and shortcuts to vastly increase efficiency and get the full power out of Access 2010. The course includes tips for working with the Ribbon and Quick Access toolbar, managing files, customizing and automating Access, rapid data entry and editing, working with tables, queries, forms, and reports, managing your database, and much more. Exercise files accompany the course.
When you place images in Lay fields, you have a choice for how they appear. You can clip them if they're too large, stretch them to fill the size of the field or zoom them to best fit. Scroll down in your Navigation pane and choose the Sales Reps and Customers Form. On the right, you can see a field containing pictures of our SalesReps. Our picture looks great. But how did I do that? This technique works in either Design View or Layout View. I'm going to switch to Layout View so I can see my changes in action. I'm going to use this little Layout View toggle button on the bottom right-hand corner.
Open up your Property Sheet, click on your photo, and then make sure you're on the Format tab. Find Picture Size mode. Right now, it says Zoom, which resizes your original pictures so it best fits the size of your field. Let's try the other options. Click on the dropdown, and change it to Clip. The original picture dimensions are maintained, but the picture gets cut off for the field ends. If you change it to a Stretch, the data will fill up the entire field box, even if the image gets distorted. Depending on your circumstances, one of the three of these will be the best option for your image.
In our case, Zoom was indeed the optimal Picture Size option. So I'll put it back. When you're inserting images into your database, finding a balance between your field dimensions and your choice of picture size will make your pictures look great.
There are currently no FAQs about Access 2010 Power Shortcuts.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
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.