Microsoft Access User Documentation Sample

Sample data for CUSTOMERS Customer ID 1 2 3 4 5 6 7 8 Company Name Sirrah Technology PL Kay-Mart Aust Harvey Ross PL Matthew Wright WSI TAFE Port Hacking Shire Council Federal Computer PL SA Academy of Sport Street No 100 1 Unit 6/89 212 117 20 11/256 100 Street Harris St Gold Rd Norman Drive First Ave Henry Street Eton St Resolution Drive Tapping Drive Suburb Ultimo Silverwater Carlingford Jannali Penrith Sutherland Spence West Haven State NSW NSW NSW NSW NSW NSW ACT SA Post Code 2007 2450 2345 2227 2747 2227 2165 5018 Contact Jenny Sirrah Kim Wong Ross Aboud Matthew Wright Amanda White Mary Flinder Alex Morrow Mel Magee Phone 217 11001 555 4321 544 9979 710 0000 472 4828 7101100 062 2150009 022 987123 Customer Category SR LR LR I G G SR G

Sample data for STOCK Stock Number 1123451 1123452 1123454 1123455 1123456 1123457 1123458 1123459 11234510 11234511 11234512 11234513 Item Description Avtek Modem Avtek Modem Netcomm Modem Netcomm Modem Netcomm Modem Avtek Modem Netcomm Electronic Secretary Internet On Ramp S/W Internet Professional S/W Creative Hypertext S/W HTML Lite S/W HTML Made Easy S/W Model No. CD720 FM CD960 FM EZF FM E11F FM SMT M7F CD990 FMV Fast V32/42 IOR95 IP95 Lite CBT Grade Standard Deluxe Auto Auto Super Super Deluxe Standard Deluxe Wholesale Price $190.00 $260.00 $265.00 $340.00 $290.00 $295.00 $460.00 $320.00 $450.00 $150.00 $180.00 $50.00 Retail Price $266.00 $328.00 $318.00 $422.00 $411.00 $396.00 $550.00 $499.00 $579.00 $250.00 $250.00 $99.00 Quantity 50 34 23 34 34 45 45 44 32 30 3 6

Sample data for ORDERS Date 2/5/02 2/5/02 5/5/02 5/5/02 5/5/02 6/5/02 6/5/02 6/5/02 6/5/02 Order Number 0010 0011 0012 0012 0012 0013 0014 0015 0016 Customer ID 1 4 5 5 5 8 2 3 1 Stock Number 1123452 1123455 1123457 1123458 1123457 1123456 1123451 1123454 1123455 Quantity 6 1 2 2 3 1 2 4 1 Details

20% discount 20% discount 20% discount

Replacement for damaged goods

Sample Form for CUSTOMERS

Customer ID: Customer Name: Street No: Suburb: Post Code:...