Learn to create forms using the Form Wizard. Author Jen McBee demonstrates how to use the Form Wizard and how to create quick forms from tables and queries, skills that you will likely encounter on the Access 2010 MOS exam.
- [Narrator] Now that we've created tables to store our information. We need to learn how to create forms that we can use to view information, edit and add data to our tables. On the Access 2010 MOS Exam, you may be asked to create a basic form. So, in this video, I'll show you how to use the form wizard to create a form. How to create a quick form from a table, and also how to create a quick form from a query. I have the 04_01 exercise file open, so let's create some forms.
I see we have one form, it's our customer's form. Let's go ahead and open it up so we can have a look. We see one record at a time. The first one is for CaylasFitnessBeats.com, and we can use our navigation at the bottom of the screen to go ahead and scroll through each of our records. This is pretty cool, so when I said earlier that this is a way to view your information, this is what I meant. We can just scroll through and find the record that we're looking for.
Now we can also update information. Any changes that I make in this screen, will automatically update the table where the record is stored. So, for instance, if I determine that Carlson's last name is not Dana, it's actually Daniels, I can come in and I can change that here. And at the same time it's updating my customer table. Let's go ahead and close this form, we'll look up the End Zone Equipment company, and you can see how it updated the record.
We'll go ahead and right-click on the tab, close it, go into the Customers table, let's sort these alphabetically so that we can find the End Zone, right here. And look, there's the change that I made in the form. So it is a great way to, not just view the information, but change the information. So you're probably wondering how you can create a form. Well, we can do it from a table. I'm going to click on the Employees table, go to the Create tab, and here's our Forms group.
Now, the first one is to create a quick form, and what that means is, all of the fields in the Employees table will be included in the form. So let's go ahead and click that. There you go. See how quick that was? It laid it out really nicely. Again, I can use my navigation, to just scroll right through all the records in the Employee table. Let's go back and I still have the Employees table highlighted, I'll go to Create, and let's use the Form Wizard this time.
In the wizard, you can pick and choose which table or query you want to use to create your form. We'll stay with the Employees table. And then we pick and choose which fields we want included. Let's do EmployeeID, FirstName, LastName, and I'm just using the arrows in the middle once I have the field selected, to move it over to the selected fields. If I click the double arrow, that includes all of the fields. Let's see, EmployeeID, FirstName, LastName, and Title. That's a good form.
We'll click Next. You can choose the layout, Columnar, Tabular, a Datasheet view, or Justified. I usually just stick with Columnar. And we'll click Next. What do we want to title our form? This is going to be something that only shows the employee name and the title, so we're going to be really descriptive so we'll know what it is that this form is going to display for us. Then we have the choice to open the form to view or enter information.
Or we can go into design view, and change any aspect. We'll just leave that first radio button selected, and click Finish. See, here are the four fields that we wanted to include. And we can view the information, edit the information, you can delete information, so you want to be careful when you're working in here. But forms are a great tool for you to work with. It's really rare that we would open a table to view the information, usually you're going to use a form to do that. Now, I also mentioned I would show you how to create a form from a query.
So, here's a query that we ran, and it's just showing the OrderID, EmployeeID, ProductID, UnitPrice, and Quantity. Let me go ahead and close that query. I can go to Create. If I want to do a quick form, I just make sure the query is selected and click Form. It's going to include all those fields for me, and now I have a form based on a query. Pretty cool. There's a good chance that you'll need to create a form as part of the Access 2010 MOS Exam, so practice this, so you'll be able to quickly complete that task without wasting any time.
- Creating a new Access database
- Applying application parts
- Backing up a database
- Creating new tables and fields
- Sorting and filtering records
- Setting primary keys
- Importing data
- Creating basic forms
- Creating Access queries, including crosstab and multitable queries
- Creating Access reports