IFSM 300

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.

Look at Design View to see if anything "unusual".
??? field types changed???
"Microsoft has made changes to the Import Text Wizard that have made it 
significantly more aggressive and buggy when it comes to data type detection 
and honoring user choices."


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

Calculated field 'sales': product of 'units' and 'price'.
Move it to after price.

Example filtering and sorting:
 dept >= 90
 price >= .90
 letter is abcdef
 sorted primarily by letter, secondarily by product
Make a Query of it.      Leftmost slot is primary sort field.
Look at the SQL View. SQL is the database language that all databases use.
 Your Queries are converted to SQL and it's the SQL that runs.


Queries  using Totals:
 Sum, Avg, StDev, Min, Max  of  'sales'
 Sum, Avg, StDev, Min, Max  of  'sales'  GroupBy 'letter'
 Count number of each 'letter': GroupBy 'letter' and Count any other field 
   (the primary key field is best because it can not be blank/missing).
 Count number of each 'code'.    Sort by Count.  Then Criteria >6
    Then sort primarily by Count, secondarily by 'code'.
 Any duplicate 'product'?  GroupBy product -->yes  Then a Count Descending, then >1