INTRODUCTION TO MS ACCESS
Anaheim Computer Lab Hours					THE			Guides to the
(click here)					CHEAT			2007 Office
					SHEET			system user
								interface
	TODAY'S CLASS
		Download the practice database
			First Database
			- We will open the Survey Table
		Basic database tools (Access)
		- Filter by Selection
			- Use the Survey Table in First Database
			- Identify the icons Filter by Selection and Apply/Remove Filter
			- How to create a filter using Filter by Selection
			- How to tell when the filter is on ( = the filter is applied)
		- Two ways to do Filter by Selection
			- Case 1. Do FbS when the Filter is off ( = filter is removed or nonexistent)
			- Case 2. Do FbS when the Filter is on (= filter is applied)
		Basic database tools (Access)
		- Filter by Form						Filter
			- Click on Filter by Form to "go backstage" to the filter rule					by
			- Compose a rule by following these steps					Form
			1. Go to Filter by Form ("backstage")
			2. Click in the text box under the Genre heading
			3. Click on the downward pointing arrow head to see a list of values
			4. Click on "Drama"
			5. Click on the Apply Filter (funnel icon) to leave Filter by Form
		AutoReport & AutoForm - the fastest Access wizards
		- In the Reports section of the database
			- Click on the "New" tool
			- Experiment with the different reports
		- In the Forms section of the database
			- Click on the "New" tool
			- Experiment with the different forms
	PREVIOUS CLASSES
			10/6/09
		Get an idea of the capabilities of Access
		- "Playing in the Park"
			- We will open find and copy the Northwind database
			- This is a sample database that is installed with Access
			Search for this file: Northwind.mdb
		Basic database tools (Access)
		- Sort
			First Database
			- We will open the Survey Table
		Using a datasheet in Access
		- Change field names
		- Change the layout
			9/29/09
		Did you do the "Family Tree" table in Access?
		- No?  Would you like to do it now?
			(Scroll down.  Or click here.)
		SCE'S "YOU COUNT" CAMPAIGN
		- The schoold needs accurate information to identify each student
			You Count poster
			Log into My Gateway
		Three Important Database Functions
		- Sort
		- Filter
		- Search
		To begin with, we will use Excel to understand these functions
			Movie recommendation flat file (survey-table.xls)
		How to Tables, Queries, Forms & Reports work together?
		- Here is a simple diagram
			General flow of activities
			9/22/09
		Getting clean data
		- Imagine a movie database
			Imagine a survey to collect data for this database
			The movie recommendation survey
		- Imagine having to code (enter) this data into the database
			Survey recording spreadsheet
		The Breakthrough Exercise: Make a Table
		1. Start MS Access
		2. Make a new file
		- Specify that you want a new database file
		3. Save the file as "Practice 1" in the My Documents folder
		4. Use the tool labeled "Create a Table by Entering Data"
		5. When done, close the table window
		- Do you want to save the changes?  YES!
		- Give the table a name
		Let's make this table together:
		- Name it "Student Cities"
		Now it's time to practice this.
		- Do the entire procedure over (starting with Step 1)
		- Save the database file as "Practice 2" in My Documents
			(Step 3)
		- Name the table "Family Tree"
			(Step 5)
			9/15/09
		Getting started
		- Overview: course outline
		- Overview: Access skills inventory
		The simplest database
		- What is a flat-file database?
		- What is a table?