How to create a form in microsoft access 2000

If users need to access data that is not on their forms, you could add a subform; or, you can add a command button that, when clicked, will pop open the form that contains the necessary data. Find out how to create a pop-up form in this Access tip.

The Microsoft Access Order Entry form you created contains all the information that your customer reps need to take a phone order. But every now and then the customer rep needs to access another form that has information that isn't on the order form. Instead of adding a subform to the order form, you can add a command button that let's your rep pop open the desired form when needed.

For example, a customer may need to change their e-mail address, which may be kept on the Customer E-mail Address form. To create a command button that, when clicked, will pop open the necessary form, follow these steps:.

Now when your reps' customers need to update their e-mail addresses, the rep can click the command button to access the correct form and make the necessary changes. Note: In Access , when you click and drag to create the command button, a wizard pops up; you should cancel out of that and proceed to the next step, right-click the button, and select Properties.

Luckily, you have several Microsoft Access alternatives to choose from. These programs let you create and manage your databases in many ways. Free database software isn't all bad. This article covers five of the best free and easy to use alternatives to Microsoft Access.

Mahesh is a tech writer at MakeUseOf. He's been writing tech how-to guides for about 8 years now and has covered many topics. He loves to teach people how they can get the most out of their devices. There are also chances of accidentally modifying your existing data with the table method.

How to Create a Form in Microsoft Access Before you can create a form in Microsoft Access, you should have created at least one table in your database.

Click the Create tab at the top, find the Forms section, and select Form. Share Share Tweet Email. If you click on that button then, it will move to the next record. If you want to jump to the very last record in that form or that table, you can use the button right beside that right arrow, the arrow with a line after it, that's the last record button. If you want to add new employee information, go to the end of this records and then after 9 records you will see a blank form where you can begin entering out the new employee's information.

This is one example of how you can create a form using the Form Wizard. Let us now close this form and go to the Create tab. Now we will create a slightly more complicated form using Wizard. Click the Form Wizard and this time, we will choose fields from a couple of different tables. These fields will now move to Selected Fields. Click Next. Here, we want to retrieve data from a couple of different objects.

We can also choose from options on how we want to arrange our form. If we want to create a flat form, we can choose to arrange by tblTasks , which will create that single form, with all the fields laid out in flat view as shown above. However, if we want to create a hierarchical form based on that one-to-many relationship, we can choose to arrange our data by tblProjects. In the above window, we have the option to include a subform for tblTasks , or we can make that a linked form.

This linked form is where tblProjects will have a button that will launch that second form filtered to the project that we have selected in that underlying projects form. Let us now select the Form with subform s , and then click Next. In the following screen, you can choose a layout for your subform. The Datasheet View gets selected by default. The Datasheet View is similar to Table View. Now, click Next. In the following screen, you need to provide a name for your forms.

Enter the name you want and click Finish. Access will give you a preview of what your form looks like.