146JLN05 - 1,235 132 Jones HPLJ4M 2 3,952 190 Jones HPLJ4M...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Point Computer Store Computer Sales Database C Cust. No Salesperson Product Qty. Amt.Billed Cust. No 115 Worrell 425SX 5 9,025 196 Worrell 425SX 3 6,015 152 Worrell 425SX 2 4,800 144 Worrell HPLJ4M 1 4,625 144 Worrell 433DX 1 1,235 155 Worrell BJ200 1 5,005 190 Worrell 466DX2 1 2,200 196 Worrell 433Q 1 2,005 Worrell Total 15 34,910 120 Simon 433DX 4 8,600 135 Simon T-1200 4 9,025 120 Simon 425SX 3 8,600 135 Simon 433DX 3 4,625 160 Simon T-1200 3 6,512 185 Simon BJ200 3 1,235 120 Simon T-1200 2 4,458 135 Simon HPLJ4M 1 2,856 160 Simon HPLJ4M 1 1,966 Simon Total 24 47,877 118 Monson 433DX 4 8,854 162 Monson 433DX 4 8,854 198 Monson 425SX 3 8,600 118 Monson HPLJ4M 1 2,005 162 Monson 433DX 1 2,450 162 Monson 425SX 1 2,005 Monson Total 14 32,768 166 Jones 433Q 4 8,000 190 Jones 433DX 4
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1,235 132 Jones HPLJ4M 2 3,952 190 Jones HPLJ4M 2 4,000 132 Jones BJ200 1 2,500 132 Jones 466DX2 1 2,200 Jones Total 14 21,887 112 Collins 466DX2 9 2,200 130 Collins BJ200 2 5,000 150 Collins HPLJ4M 2 3,952 112 Collins 425SX 1 5,005 130 Collins 466DX2 1 2,200 Collins Total 15 18357 Grand Total 82 155799 Database Functions Salesperson Jones Count of sales Err:504 Average Billed Err:504 Sum of Sales Err:504 Product BJ200 Count of Products Err:504 Average Billed Err:504 Sum of Sales Err:504 Criteria Area Computer Sales Database SalespersoProduct Qty. Amt.Billed...
View Full Document

This note was uploaded on 06/05/2010 for the course CIS 105 taught by Professor Dunn during the Spring '10 term at Skagit Valley College.

Page1 / 6

146JLN05 - 1,235 132 Jones HPLJ4M 2 3,952 190 Jones HPLJ4M...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online