In this image you are shown every option available when setting up a Query (Saved Search). I have only bothered to explain the less obvious options.
Turning a BIG grid of info into a SMALL grid:
A way to think about the query is only showing some rows from a large table of Data so that the smaller set of info that remains can fit on a piece of paper. It is a smaller grid of info because you tell the Database to only look for certain info.
Open Access
Name Database - Click CREATE
Click External Data
Click Text File (a CSV is a text file where info is split with commas)
Find CSV file - Click OK
IMPORT 2 / 4 = NEXT-TICK-NEXT-TICK-NEXT-FINISH
Double Click the NEW TABLE (e.g. J8Prods)
Click HOME - Click VIEW - CLick Design View
Copy Data Types from Exam paper (e.g. Currency, Boolean = YES/NO)
PRINT SCREEN you Data Types for the examiner (Paste into WORD to Print)
