COSC1371		PROJECT-8(ACCESS-1)        	   Due: Wednesday, 6/29/2010   
	Objectives:
	1. Use of ACCESS2010 (Database Management).
	2. Create and save a new database file: LAMAR2011.MDB
	3. Create and save a table to be included to this Database file: named CLASSES
	4. Create and apply two filters to select/sort records of this table.
	5. Save the results of applying the two filters: named FILTER1 and FILTER2.
	Steps:
	1. Open ACCESS2010 after clicking PROGRAMS on START-Menu.
	2. The ACCESS D.B. will appear. Click "Blank Access DataBase" and click OK.
	3. The "FILE NEW DATABASE" D.B. will appear.
	   After choosing your USB Drive, enter "LAMAR2011" in the "File Name" text box
	   to become the name of your Database file, and hit the "Create" button.
	4. The Database Window will appear that shows some object tabs.
  	   The first object is Tables. 
	   Click the "Create Table in Design View" button to create a table.
	5. The Table Window will appear (in the Design View rather than in DataSheet View) 
	   for you to define field names and their data types.
		Sequence:   	A (AutoNumber) //Note only one such data type per a table
		Dept:       	T (Text: Default)
		Course_No: 	N (Number)
		Section_No:	N (Number)
		Instructor:	T
		Day:	   	T
		Time:		D (Date/time)   //Entering "17:00" turns to 5PM.
		Building:  	T
		Room:		N (Number)
	6. When done entering all field names and data types, save the table
	   by clicking Save Button and typing "CLASSES" as the table-name.
	7. Switch to the DataSheet View by clicking the View button (L-1).
	   In this view, enter all 28 class Records into this table.
	   When done, save again (CTRL-S will do).
	8. Define two filters and save both as FILTER1 and FILTER2 by clicking
	   the "Save As Query" Button  while the Filter D.B. is open, that's
	   BEFORE applying the FILTER being constructed.
	9. The Filter D.B. will appear when you click the "Advanced Filter/Sort..." option
	   that is included in the "Advance" drop-down menu in the Sort&Filter Group on the
	   Home Tab. 
	10.This D.B. has two sections: The Fields Section and the Filter Definition
	   Section. The latter section is where you define a filter using fields
	   that are selected from the first Section.
	11.FILTER1 is to select MW or MWF classes between 10AM and 4PM and
	   sort selected records by Time (Ascending)	(14 records)
	   When finished defining the filter, you must click "Save As Query"
	   button to save the filter application result BEFORE applying it.
	   When you click this button, "Save As Query" D.B. will appear.
	   Type the filter name "Filter1" and click the OK Button.
	   Note typing ">= 10:00 and <= 16:00" is to mean "between 10AM and 4PM"
	   Also, note that following three filter criterion settings are all the same:
	12.FILTER2 is to select TTH Classses and sort the selected records
	   by time first and then by Course-No., both ascending. (13 Records)
	13.Your USB must have: Database named "LAMAR2011.MDB" that contains
	   one table named CLASSES and two Queries named FILTER1 and FILTER2.

  	*** Some ACCESS useful key shortcuts***
	    F6:    	Move between window sections.	
	    CTRL;: 	Insert current date.
	    CTRL': 	Enter the same value from previous record.
	    CTRL=: 	Move to the first Blank record.