IFSM 201

kana Access

*Import the kanaNEW.txt text file into Access.
Give meaningful names to the Fields.  correct types.
e.g.  product  dept  units  price  letter  code
"Let Access add a primary key."  Will be AutoNumber type named ID.

Center the letter field.
'units': Field Properties | Format | Standard
    and                   Decimal Places to zero

Calculated field 'sales': product of 'units' and 'price'.

Example filtering and sorting:
 dept >= 90
 price >= .90
 letter is abcdef
 sorted primarily by letter, secondarily by product
Make a query of it.

Queries  using Totals:
 Sum, Avg, StDev, Min, Max  of  'units'
 Sum, Avg, StDev, Min, Max  of  'units'  GroupBy 'letter'
 Count number of each 'letter': GroupBy 'letter' and Count any other field (the primary key is best).
 Count number of each 'code'.    Sort by Count.  Then Criteria >6
 Any duplicate 'product'?  GroupBy product -->yes  Then a Count ...