Practice 7

1
Practice 7

• 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 that lists Bonbons by Basket
• Use Basket Details, and Bonbons table
• Select BasketID and BonbonName

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.)

• Choose Box Sales Subform in the form window
• Open the form in design mode
• Add a new item in the subform by using the ???
  button in the toolbox (p.208, bottom picture)
• Click in the new input box
• Click ?? button
• 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