Access_B

STEP 2-3 --- rptCustomerPurchases_aStudent 

STEP 4-7 --- frmCustomerInput_aStudent 

STEP 8 --- qryMultiplePurchases_aStudent 

STEP 9 --- qryCustomerWithoutPurchase_aStudent 

STEP 10 --- qryNonGuestPurchases_aStudent 

STEP 11 --- qrySpaIndigoJanuary_aStudent 

STEP 12 --- qryExtendedAmount_aStudent 

STEP 13-16 --- rptPurchases_aStudent 

Instruction for Step 15 is posted here because Step 15 is not fully covered in MINF 2650.

Step 15 (after you complete Step 14):

- Open the 'Purchase Report' in the 'Layout View'

- Select a value under ExtendedAmount column (e.g., $24.99), then the values are highlighted.

- Go and select 'Report Layout Tools' > 'Design' > 'Totals' > 'Sum', then the sum subtotals are added.

- Select a value in a Sum Subtotal (e.g., 74.9697 or 31.98), then the values are highlighted.

- Go and select 'Report Layout Tools' > 'Design' > 'Property Sheet', then the Property Sheet is displayed on the right.

- In the Property Sheet, find and set 'Format' to 'Currency', then the values are changed to the currency format. (e.g., 74.9697 --> $74.97) 

- Right click on a value in the sum subtotals (e.g., $74.97 or $12.00), and Select 'Set Caption' on the right-click-menu.

- Type 'Total Purchase' in the caption.

- Right click on the value in the total sum on the bottom of the report (e.g., $609.21), and Select 'Set Caption' on the right-click-menu.

- Type 'Grant Total Purchases' in the caption.