Practice 8

1
Practice 8

• Lesson 9

2
Form wizard

• Use the form wizard to make a form
• Lets make a form that displays all orders of a
  customer
• The form has the information
• CustomerID Customers table
• Last Name Customers table
• First name Customers table
• CustomerID, OrderID, OrderDate Orders form
• Choose ???? ???? ? ? ???
• Choose ???Customers and
• Choose CustomerID, LastName, FirstName
• Choose ??Orders Form
• Choose CustomerID, OrderID, OrderDate
• And choose the default values in the lest of the
  steps in the form wizard

3
exercise

• Make a form that displays the bonbon names of a
  basket
• The form has the information
• BasketID Baskets table
• BasketName Baskets table
• BasketID, BonbonName make a query using tables
  Basket Details and Bonbons

4
Computing Controls (p.208)

• We can have some computing expressions in the
  form
• Lets add an item, total quantity sold, in Box
  Sales Subform
• Currently, the Box Sales Subform displays the
  list of
• Order date, Qty, Box price, Ext(ended) price
• ? for this part query Box Sales Subform is used
• Sales total
• Sales average in the bottom of the form
• Open the form and see the list
• Open the query Box Sales Subform and compare

5
Computing controls (cont.)

1. Choose Box Sales Subform in the form window
2. Open the form in design mode
3. Add a new item in the subform by using the ???
   button in the toolbox (p.208, bottom picture)
4. Click in the new input box
5. Click ?? button
6. Click ??? button to enter an expression (p.209,
   middle picture)

6
Computing controls(cont.)

• In the ??? ??? window
• Click
• Choose ?- ???? ?- Box Sales Subform in the
  left of the window
• Choose lt?? ??gt in the middle of the window
• Choose SumOfQuantity in the right of the window
• The status of Upto this point is the picture in
  p.212
• Change of equation in the box of top like this
  Sum( SumOfQunatity )

7
Computing controls(cont.)

• In the Box Sales Subform
• Choose the label part of the new item
• Click ?? button
• Click ?? tab
• Change the caption to Total Quantity Sold
• Adjust the size of the label part

8
exercise

• Make a form like this
• Hint
• Use the query
• Boxes Sold