6.40 Tech Tool: Database Software Software Videos: Advanced Database Forms and Queries Your assignment is to build a database form to enter sales orders into an integrated enterprise system.

1. Download the data file for this exercise.

2. Use Microsoft Access database software and the following sample to build a Sales Order form for entering sales orders.

Sales Order Customer No C40000 Order Number 22 Company Name Alpha Corporation Status Open Contact Person Daniel Brown Posting Date 7/20/2012 Customer Reference No Delivery Dote 8/1/2012 Currency USD Document Date 7/20/2012 Item No Item Description Quantity Price After Discount- Tax Rate Total 201 IBM Inforprint 1312 3 A00006 HP 600 Series Printer 2 A00007 HP 10 Premium Toner 8 $400.00 9.00% $1,200.00 $500.00 9.00% $1,000.00 $600.00 9.00% $4,800.00 Soles Employee Record 4 1 of 1 ' Note Search Total Before Discount $7,000.00 Discount Freight Tax $630,00 Total $7,630.00