Thursday, March 24, 2011

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.

No comments:

Post a Comment