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.