Tuesday, September 18, 2007

How to create the Relationships

How to create the Relationships

To create the Relationships

Step 1

To create the Relationships, first, you have to select the field that you want to create.

Step 2

Then, you have to use the mouse to drag and draw the line to connect the table as shown by the picture below.

How to show the Relationships window

How to show the Relationships window

To show the Relationships window

Step 1

To show the relationship window, first, you have to go to the original window view.

Step 2

After that, just use the mouse to open the Tools menu and then click on the Relationships command.

Step 3

The image below will appear as soon as you have chosen the Relationships command.

How to create a Report

How to create a Report

To create a Report

Step 1

To create a Report, first, you have to click on the Create report by using wizard option.

Step 2

After that, select the table that you want and then add the field in the Selected Fields from the list box. Now, click on the Next button.

Step 3

Just follow the wizard, step by step to finish the setting.

How to show Report Object

How to show Report Object

To show Report Object

Step 1

To show the Report Object, first, you have to open the Form object window.

Step 2

After that, use the mouse to open the View menu and then click at the Database Object sub menu. Now, you have to click on the Reports command.

Step 3

Now you could see that the reports window has appeared.

How to create a Delete Record

How to create a Delete Record

To create a Delete Record

Step 1

To create a Delete Record Button, you have to click on the Command Button in the toolbox, first.

Step 2

After that, you have to place the command button in the forms. Later, select the Record Operations in the Categories and then choose the Delete Record option in the Action list. Finally, click on the Next button.

Step 3

Now you can see that the Delete Record button has been created.

How to create a Find Record button

How to create a Find Record button

To create a Find Record button

Step 1

If you wish to create a Find Record button, the first thing to do is to click the Command Button in the toolbox.

Step 2

After that, place the command button in the forms. Later, select the Record Navigation option in the Categories and then choose the Find Record in the Action list. Finally, click the Next button.

Step 3

Now you can see that the Find Record button has been created.

How to create a Save Record button

How to create a Save Record button

To create a Save Record button

Step 1

To create a Save Record button, first you have to click the Command Button in the toolbox.

Step 2

After that, you have to place the command button in the forms. Later, you have to choose the Record Operations option in the Categories and then select the Save Record in the Action list. Finally, click the Next button.

Step 3

Now you can see that the Save Record button has been created.


How to create the Add New Record button

How to create the Add New Record button

To create the Add New Record button

Step 1

To create the Add New Record button, first you have to click on the Command Button in the toolbox.

Step 2

After that, place the command button in the forms. Later, you have to choose the Record Operations in the Categories and then select the Add New Record in the Action list. Finally, just click the Next button.

Step 3

Now you can see that the Add New Record button has been created.

How to create a Go To Last Record button

How to create a Go To Last Record button

To create a Go To Last Record button

Step 1

To create a Go To Last Record button, first you have to click the Command Button in the toolbox.

Step 2

After that, you have to place the command button in the forms. Then, choose the Record Navigation in the Categories and later select the Go To Last Record in the Action list. Finally, click on the Next button.

Step 3

Now you can see that the Go To Last Record button has been created.

How to create a Go To Next Record button

How to create a Go To Next Record button

To create a Go To Next Record button

Step 1

To create a Go To Next Record button, first, you have to click the Command Button in the toolbox.

Step 2

After that, you have to place the command button in the forms. Then, select the Record Navigation in the Categories and later choose the Go To Next Record from the Action list. Finally, click on the Next button as shown by the picture below.

Step 3

Now you can see that the Go To Next Record button has been created.

How to create a Go To Next Record button

How to create a Go To Next Record button

To create a Go To Next Record button

Step 1

To create a Go To Next Record button, first, you have to click the Command Button in the toolbox.

Step 2

After that, you have to place the command button in the forms. Then, select the Record Navigation in the Categories and later choose the Go To Next Record from the Action list. Finally, click on the Next button as shown by the picture below.

Step 3

Now you can see that the Go To Next Record button has been created.

How to create a Go To Next Record button

How to create a Go To Next Record button

To create a Go To Next Record button

Step 1

To create a Go To Next Record button, first, you have to click the Command Button in the toolbox.

Step 2

After that, you have to place the command button in the forms. Then, select the Record Navigation in the Categories and later choose the Go To Next Record from the Action list. Finally, click on the Next button as shown by the picture below.

Step 3

Now you can see that the Go To Next Record button has been created.

How to create the Go To Previous button

How to create the Go To Previous button

To create the Go To Previous button

Step 1

To create the Go To Previous button, first you have to click on the Command Button in the toolbox.

Step 2

After that, just place the command button in the forms. Then, select the Record Navigation in the Categories and later, choose the Go To Previous Record in the Action list. Finally, just click on the Next button.

Step 3

Now you’re able to preview the button.

How to create go to First record command button

How to create go to First record command button

To create go to First record command button

Step 1

The first thing to do if you would like to go to First Record command button is to click the Command Button in the toolbox.

Step 2

After that, you have to place the command button in the forms. Then, choose the Record Navigation in the Categories and then select the Go To First Record in the Action list. Later, just click on the Next button.

Step 3

You can use the text or picture displayed on the button and then, just clicks the Next button.

Step 4

After that, enter the button name and then click the Finish button.

Step 5

This below picture will appear on your screen after you have clicked the Finish button.

How to show the design view of the forms

How to show the design view of the forms

To show the design view of the forms

Step 1

If you would like to show the design view of the forms, first, you have to use the mouse to select the Form that you want to design.

Step 2

After that, just click on the Design command from the menu bar.

Step 3

Now you could see that the design form appears as shown by the picture below.

How to create a Form

How to create a Form

To create a Form

Step 1

If you wish to create a form, first you have to click on the Create form by using wizard command in the Forms object window.

Step 2

After that, select the table and add the field in the Selected Fields list box as follows.

Step 3

Later, you have to select what layout that you want and then click on the Next button.

Step 4

Now you have to select the style that you like and then click on the Next button.

Step 5

Finally, just enter the name of the Form and then click the Finish button.