FORM AND REPORT

FORM:

Click Form --> create form by using wizard

and you will get a result like the image below ..
after that, select "Query: Booking Receipt" and transfer the information in the "Available Fields" in the "selected field"

choose "justified" and then click next.

 click next again.

and then click finish.

 and this result

 drag form footer down.

 on the right you can see the toolbox.

Click on the icon toolbox.
two objects that are orange

*selected object

 and * control wizard

click command button 

 drag command button down.

and the result will open the table "COMMAND BUTTON WIZARD"

choose categories : "record operation"

and choose "add new record", then click "next" and "finish"

 and this result.

 then choose  "record operation" again and choose "print record"

and click "next" and "finish"

 this result.

 "record operation" --> "save record"

click --> "next" and "finish"

 results below.

 and last--> click  "record operation " and choose "delete record"

click "next" and "finish"

 and this result.

 To create the "Next" and "Previous", you are required to choose "Record Navigation", which is in the "Categories". And then select "Next" and "Previous".

Results of the buttons that have been made: -

Next change the "Design view" to "Form View".

 results are shown below

 REPORT:

click report --> create report by using wizard

 choose title table: "booking"

and choose-->

*Booking No

*Book Date

*Price Perunit

*Quantity

*Grant Total

click next

 next

next

next

(You can change the design of a report prepared like the picture below.) 

and click finish.

finally you will be the result looks like this.

 and save it.

Cara membuat Queries

Before making the "Queries" you need to make some information in the database (Table). for example the picture below I have made ​​about "Booking", "Customer", "Delivery", "Product".

After that, the new is you begin to create "queries". Click on the "queries" and click on "create query by Using the wizard. "

when click on the "Create query by Using the wizard, "you will see a box that will appear on the display screen. After that, select  "Query: Booking Receipt" and enter the information in the box  "Available Fields" in the "Selected Fields".

Information-information such as: -
* Cust No
* Cust Name
* Cust Mobile
* Product ID
* Product Name
* Booking No
* Date Book
* Price Perunit
* Quantity
* Grant Total

next

next

and this result

then close the "Query: Booking Receipt" and click on "Create query in Design view. "

 

 

two tables will appear on your screen display. Next on the "Show Table" you need to select information about the "Booking", "Customer", and "Delivery". How to choose, you Crtrl button and click on the information. After that click on "Add" button.
   

and this result

After that save the state table in the name of "Payment Receipt". And click on the button "ok".

Next you need to fill in the blank boxes with the information in the "relationship"on it. you need to drag

* Cust No

*Cust Address

* Cust Mobile

* Cust Name

* Booking No

* Date Book

* Grant Tot

* Payment Date

* ID Delivery

* Delivery Date

* Type of Delivery

and enter the information into the boxes available

and save it.