INTRODUCTION TO MS ACCESS
			Computer lab hours		THE			Guides to the
					CHEAT			2007 Office
					SHEET			system user
								interface
			8/10/09
		- Download this to My Documents, then make a working copy
			Third Database
		Pattern matching: the use of wildcard characters
		- This skill can be used in filters, queries and the search function
			Pattern matching using wildcards
		- In Access patterns are preceded by the key word Like
		- and they are enclosed in quotation marks
			Try this: movies with the word "the" in the title (Pattern: *the*)
			- In Filter-by-Form you type *the*.  Access will convert this to
			Like "*the".
			Try using wildcards in the Find command
			- Click in the Title field.  Start Find.  Type *music*.
		The "poor man's" query: Save a filter as a query
		- Make a filter using Filter-by-Form (in the Survey Table)
			GENRE = Drama
			TITLE = not *of*
		- Test the filter
		- Go back to Filter-by-Form, and use the Save As Query tool
			NAME OF QUERY: Dramas without "of" in the title
		Design view for queries
		- View the last query in design view
		- Make the last query from scratch in query design view
		Make a combo box from a typed-in list
		- This is a variation on using the Lookup Wizard
			a. Open the Movies table.  Go to design view
			b. Click on the Rating field.  Start the Lookup Wizard (Data Type).
			c. In the first step, click the option "I want to type in a list".
			d. Type the numbers 1, 2, 3, 4 and 5 on separate lines.
			e. Finish the wizard.
			8/3/09
		- Download this to My Documents, then make a working copy
			Third Database
		The "Find" command (a.k.a. "search")
		- Important: click on the field to search FIRST
		Preparing to make drop-down menus (combo boxes)
			Introduction to relational databases
		Make combo boxes (drop-down lists) in a table
		1. Go to design view of the table where the combo box should be
		2. Select the field that for which you want the combo box
		3. Click in the Data Type box for that line (field)
		4. Follow the drop-down list to the bottom (Lookup Wizard)
		5. Run through the Lookup Wizard
		6. After you click the Finish button in the wizard, you will see
			"The table must be saved before relationships can be created.  Save now?"
			I ADVISE YOU TO CLICK "NO" IN RESPONSE TO THIS QUESTION!
		7. Click the icon to return to datasheet view.  You will see
			"You must first save the table.  Do you want to save the table now?"
			CLICK "YES" IN RESPONSE TO THIS QUESTION!
		Let's begin the exercises
		- Use the Movies table in design view
		- From the Data Type list, start the Lookup Wizard
			a. FIELD TO USE IN MOVIES TABLE: First Genre
			TABLE TO TELL THE LOOKUP WIZARD: the GENRE table
			Step 7. Click the icon to return to datasheet view (test the combo box)
			b. FIELD TO USE IN MOVIES TABLE: Second Genre
			TABLE TO TELL THE LOOKUP WIZARD: the GENRE table
			Step 7. Click the icon to return to datasheet view (test the combo box)
			c. FIELD TO USE IN MOVIES TABLE: Maturity Rating
			TABLE TO TELL THE LOOKUP WIZARD: the MATURITY RATING table
			Step 7. Click the icon to return to datasheet view (test the combo box)
		Pattern matching: the use of wildcard characters
		- This skill can be used in filters, queries and the search function
			Pattern matching using wildcards
		- In Access patterns are preceded by the key word Like
		- and they are enclosed in quotation marks
			Try this: movies with the word "the" in the title (Pattern: *the*)
			7/29/09
		IMPORTANT!! MAKE A BACKUP OF YOUR DATABASE!
		- Download this to My Documents
			Second Database
		- Next, make a "working copy"
			- Trick: use CTRL+click-and-drag
		Let's test our understanding of Filter by Form
		- Here is a set of exercises
			Filter by Form exercises
			- SUGGESTION: work in pairs of computers
			- One computer shows the exercise, the other shows the database
		Filter by Form - type expressions (instead of point-and-click)
			- use table "Survey Table"
		- Examples of expressions you can type in the Rating field:
			>3
			not 1
			4 or 5
		How to import a table from a file into an Access table
		- Download this file:
			External tables to be imported (TABLES-TO-IMPORT.xls)
		- How to get started:
			- File > Get external data > Import
		- NOTE: Step 2 is important: check the box that says this:
			"First row contains column headings"
			7/27/09
		IMPORTANT!! MAKE A BACKUP OF YOUR DATABASE!
		- Download this to My Documents
			Second Database
		- Next, make a "working copy".  This gives you a backup and
		temporary file that you can work on.  Please look at this:
			THE ART OF MAKING BACKUPS
		Design view for forms and reports
		- Design view for forms & reports: an object-oriented drawing
		environment
		- Let's look at a form in design view
			- Look at a columnar form made from table Survey Table
			- Then look at a redesigned form made from this basic one
			7/22/09
		Whoever has not made a table, look at this document
			A List of Table Ideas
			- Homework: sketch out a table & show at least 2 records
		Each type of Access object has its own design view layout
		- Table Design View
		- To begin, let's look at a table in design view
			Second Database
			- Use the Survey Table in Second Database
		- Next, let's make a table in design view
			Make one of these sample tables
		Design view for forms and reports
		- Design view for forms & reports: an object-oriented drawing
		environment
		- Let's look at a form in design view
			- Look at a columnar form made from table Survey Table
			- Then look at a redesigned form made from this basic one
			7/20/09
		The Report Wizard and the Form Wizard
		- Use the tool "Create report (or form) using a wizard"
			First Database
			- Source of data: Table: Survey Table
		- A 3-stage strategy for learning how to use a wizard
			1. First time: no decisions
			2. Next few times: make 1 decision only
			3.Finally, feel free to experiment
		What is "Design View"?
		- It's a more sophisticated way to make or modify objects
			Look at this simple picture:
			Levels of design
		- The icon to go into Design View: pencil-ruler-triangle
		- Icons to go back to "normal view"
			- go back to table datasheet view or query datasheet view
			- go back to form view
			- go back to report view (print preview)
			7/15/09
		The Break-through Exercise for this class
		- Make a table on paper from situational data
			Go from "situations" to "tabular data"
		Basic database tools: Filtering
			- Use the Survey Table in First Database
			First Database
		- 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
		The Report Wizard and the Form Wizard
		- Use the tool "Create report (or form) using a wizard"
			- Use the Survey Table in First Database
		- A 3-stage strategy for learning how to use a wizard
			1. First time: no decisions
			Only do this:
			o  Use Survey Table as the data source
			o  Click on the double arrow (>>) to move all field to the right list
			2. The next few times using the wizard: make 1 decision only
			3. After that, feel free to experiment
			7/13/09
		The Break-through Exercise for this class
		- Make a table by adding data
			Make one of these sample tables
			- Start Access, then create a new database file
		AutoReport & AutoForm - the fastest Access wizards
			First Database
			- use Survey Table as the source of data
		- 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
		Basic database tools: Filtering
			- Use the Survey Table in First Database
		- Filter by Selection
			- Case 1. Do FbS when the Filter is off
			- Case 2. Do FbS when the Filter is on
			7/8/09
		The Break-through Exercise for this class
		- "Make thyself a table"
		How to make a table in Access
		- Make a table by adding data
			Make one of these sample tables
			- Start Access, then create a new database file
		The four Access Objects
		- The flow of activities in an Access database
			General flow of activities
		Using a table in Access
		- Change field names
		- Change the layout
			First Database
			- We will open the Survey Table
			7/6/09
		The Break-through Exercise for this class
		- "Make thyself a table"
			Assignment: make your own table
		Did you practice making a table?
		- Did these categories help you?  Or did you choose
		something else?
			Date/Time            News
			Easily Forgotten     People
			Facts                Personal Development
			Family               Reminders
			Fun/Entertainment    Statistics/Calculation
			Government           To Do
			Money                OTHER (Please specify)
		Basic database tools (Access)
		- Sort
			First Database
			- We will open the Survey Table
		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
			7/1/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
		Three basic database tools (Excel)
		- Sort
		- Filter
		- Search
			Movie recommendation flat file (survey-table.xls)
		Let's practice making a simple table
		- Here are some categories.  Let's choose one:
			Date/Time            News
			Easily Forgotten     People
			Facts                Personal Development
			Family               Reminders
			Fun/Entertainment    Statistics/Calculation
			Government           To Do
			Money                OTHER (Please specify)
			6/29/09
		Getting started
		- Overview: course outline
		- Overview: Access skills inventory
		The simplest database
		- What is a flat-file database?
		- What is a table?