Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.
You can add functionality to a form using preprogrammed buttons. Double-click on the Customers Order Form to open it. We're going to put a button right here to allow us to print this order. Go up to the View menu, drop it down and choose Design View. In the Controls area, choose the fourth one for Button. Click on it, and you'll get a crosshair with a little square on it. Go ahead and click right around the five- inch mark, and a Command Button Wizard opens. There are all different kinds of commands that will automatically be programmed when you click your button.
We want Form Operations, and we want to Print a Current Form. Click Next. It gives you a choice of putting on a Picture, or you can Browse and put your own picture on the button, or you can use Text. We're going to have it say Print Current Form. Click Next. Give the button itself a name. We're going to use PrintForm using Camel Caps with no spaces, and click Finish. If I want to change the appearance of my button, come up to the Form Design tools and click on Format, and then on Quick Styles.
Let's choose this green 3D, so that it matches the rest of our forms. I can also change the Shape by using this button right here. I've got rectangles, circles. We're going to do a Rounded Rectangle. Click on it, and move it over, so it's aligned well on the form. Go up to the Design tab, and then over to Datasheet View, and there is our button. Hold our cursor over it and click, and it opens up a Printer box.
Click OK if you want to Print, or Cancel if you don't. Access's buttons add practical functionality to your forms.
Find answers to the most frequently asked questions about Access 2010 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
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.