How to Use the Wizard to Add Command Buttons to a Microsoft Access Form or Report

Video Transcript

"Hi, my name is Dave Andrews. Today, I'm going to show you how to use the wizard to add command buttons to a Microsoft Access form or report. Let's open up Microsoft Access by clicking on the start button at the bottom. Go into all programs, select Microsoft Office, and just select Access. Let's open up a database by going to the Office button and saying open. I'm going to select Database 1 and say open. As you can see, my database has one table in it, and if I double click on that table it has three records in it. What we're going to do is create a new report or form for this data, and we're going to put a command button on it. So click on Create, and we're going to choose Form Design. This has created a new blank form. Select up here this button that says Add Existing Fields, under the Design tab; Add Existing Fields, and that shows the fields in table 1. Let's drag those onto our form, and that adds those fields onto our form. Now we're going to create our command button using the wizard. Make sure that on the design field in the controls area this little button here that has the wand with the three little circles coming out of it, that that is highlighted by clicking on it. Now, select your command button icon under the controls field, and let’s just draw a command button onto our form. This pulls up the command button wizard. For categories, leave it at record navigation, and we're just going to select Go To Next Record and say Next, then Finish. There's our command button that we've just created with the wizard. To test this, click on the View view up here at the top, then select form view. This is showing the data from our table, and as we click our button it's taking us to the next record. My name is Dave Andrews, and I've just showed you how to add a command button to a Microsoft Access form or report using the wizard."