INTRODUCTION TO MS ACCESS                    
                             
              IN              
        Information About the Computer Lab     CLASS              
              NOTES              
                             
# TODAY'S CLASS: Wednesday, November 30                    
                             
    WARM-UP / QUESTIONS                    
                             
    Who has questions about the HW?                    
       - Did you collect some data about the topic you selected?                    
       - Can you turn your data into a table in your Access database?                    
                             
                             
  32.                          
    Tables: A breakthrough concept                    
     - Another method for making an Access table is to import it from tabular                  
    data stored in Excel                    
     - Here is an Excel file that contains several tables, each in its own worksheet                
        External tables to be imported (TABLES-TO-IMPORT.xls)   LINK              
         - Download this file to the Intro to Access folder                    
     - If necessary, download this database and make a working copy                    
        Second Database   LINK              
     - This technique requires practice because it has many steps                    
        Procedure to import a table from Excel   LINK              
                             
  33.                          
    Parking Lot: Add a field to a form or a report                    
     - Suppose you modify the layout of a form or report after running the                    
    wizard, and you want to add a field without starting from scratch?                    
     - There are two methods for doing this                    
      a. Go to Design View for the form or report, and use the "Add Existing Fields" tool                    
         - It is in the ribbon "REPORT DESIGN TOOLS: DESIGN"                    
         - Frankly, this is challenging because one must learn the graphical                    
        layout system of Design View                    
      b. Go to Layout View for the form or report and use the "Add Existing Fields" tool                    
         - There are a lot fewer steps here: double click on the field name                    
        in the field list, then use the 4-headed arrow to move that field                    
        and its data to the proper place on the form or report                    
                             
  34.                          
    IMPORTANT!! MAKE A BACKUP OF YOUR DATABASE!                    
     - First, study this:                    
        THE ART OF MAKING BACKUPS   LINK              
     - Download this database                    
        Third Database   LINK              
     - Finally, make a working copy (using copy & paste in Windows Explorer)                  
       - Third Database - Copy.mdb                    
          - This gives you a backup file and a temporary file that you can work on                
         - Open "Third Database - Copy", not "Third Database"                    
     - Later, you will close Access and rename the database file to a new version                
       - Rename "Third Database - Copy" to "Third Database 2"                    
     - Later still, you will create "Second Database 2 - Copy" using copy and paste              
         - Another working copy you use in order to preserve Third Database 2                
                             
  35.                          
    Queries, Part 1                    
     - Basic method: make a filter, then save it as a query                    
    1. Open Survey Table, go to Filter-by-Form, & construct this filter:                    
       - Records that are dramas AND where the maturity rating is not "R"                    
         - GENRE: "Drama"                    
         - MATURITY RATING: not R                    
    2. Test the filter (Toggle Filter)                    
    3. Go back to Filter-by-Form                    
    4. Click the Advanced icon (Advanced Filter Options)                    
    5. Click the Save As Query command                    
       - Give the query a name (such as "Drama Not R")                    
        NOTE: The Save As Query command can only be activated when you are in                    
        Filter-by-Form view.  (It is grayed out if you start from datasheet view.)                    
    6. Close Survey Table, and open your new query                    
       - Examine the query in design view                    
                             
                             
    HOME WORK                    
                             
    11. Use your data + make your database                    
     - Step 2 of the process was: On a small piece of paper, begin to record a                    
    small amount of this information      HOME              
      a. Using your log (from Step 2) and another piece of paper, start to design a table     WORK              
         - Identify names of fields and the data type for each field                    
      b. Keep it simple.  I repeat, keep it SIMPLE.                    
         - Use just a few fields                    
         - Record just a few records                    
      c. Create an Access database file                    
      d. Create your table                    
      e. Success!  You are an  Access database creator!                    
                             
                             
                             
    LOG YOUR COMPLETION OF EACH ASSIGNMENT                    
                             
    After the class:                    
       - Keep using Access!                    
         - Use it or lose it                    
         - The more you use it, the more you learn                    
       - Options for giving yourself excuses to use Access                    
         - Option 1: Keep using the database you made for this class                    
         - Option 2: Make up other simple projects using simple tables                    
         - Option 3: Ask people if they would like you to make them a                     
        simple database                    
       - Good luck!                    
                             
                             
                             
  PREVIOUS CLASSES                    
                             
        Wednesday, November 23, 2016                    
                             
  30.                          
    The report wizards                    
     - There are two basic wizards for making reports                    
       - A one-step "instant" wizard                    
       - A multi-step wizard that gives you options                    
     - We will practice both of them using Survey Table as the data source                    
        Second Database   LINK              
                             
  31.                          
    Make a backup of your database, Part 1                    
        Click here for the procedure   LINK              
                             
        Wednesday, November 16, 2016                    
                             
    WARM-UP / QUESTIONS                    
                             
    Who has questions about the HW?                    
       - Did you make notes about places you travel to?                    
         - It's OK if you didn't                    
       - Did you write down at least one "topic area" (a kind of information you find                    
      yourself following or recording)?                    
         - It's OK if you didn't                    
                             
                             
  27.                          
    Access databases contain objects                    
     - Database objects work together to produce results                    
        General flow of activities   LINK              
                             
  28a.                        
    Preparation for structuring your raw travel data                    
     - Please do this on a separate sheet of "scratch paper"                    
       - How many simple lists can you make from your data?                    
         - Do NOT make a table                    
         - Please just make simple list of each kind of data you find                    
         - And give each list a name                    
         - And write down the data type of each list                    
                             
       - If you don't have your own travel log data, please use this data:                    
        Thurs., 2/11                    
         - went to bank on bicycle, withdrew $40                    
         - left home, stopped for gas ($20)                    
         - left gas station, went to Cypress college                    
         - left Cypress College, went home                    
        Fri., 2/12                    
         - walked to Starbucks ($8), then walked home                    
         - drove to farmers market, then to Food-4-Less, then home                    
         - drove to David's, David & I drove to IHOP, I drove David home                    
         - I drove home                    
                             
  28b.                        
    Let's make an Access table from this blueprint                    
     - After you do the exercise above, start Access                    
     - Click on "Blank Database", but do not click the "Create" button                    
       - First name the database PERSONAL TRAVEL DBASE                    
       - Also, set its location as the "Intro to Access" folder                    
       - Now you may click the "Create" button                    
     - Work in the blank datasheet to design your table                    
       - Define data types and field names. (Use "Click to Add".)                    
     - Prepare to save your table                    
       - Click the black X on the right to close your datasheet                    
       - Answer "Yes" to save the datasheet as a table                    
       - Type this name for your table: TRAVEL NOTES TABLE                    
     - Finally, re-open the TRAVEL NOTES TABLE and enter data                    
       - Use your original travel log data                    
     - BONUS TASK                    
       - Make a form using the Form wizard (in the Create ribbon)                    
       - Then enter your data using this form                    
                             
  29.                          
    Basic database tools: Filtering                    
     - "Filter by Form"                    
       - We learned how to use the point-and-click method in filter by form                    
       - Another way to use filter by form is to write expressions                    
     - Expressions                    
       - An expression is a formula that calculates a result                    
         - In a filter, the expression calculates True or False                    
       - There are many kinds of expressions.  Let's consider a few simple ones.                    
        1. OR: select a record if a field's value is one of two possible values                    
        2. GREATER THAN:  is a numerical value or date greater than a                     
        critical value                    
        3. NOT: show records where the field's value is not this value                    
     - We will practice this using Survey Table in Second Database                    
        Second Database   LINK              
     - Filter by form examples                    
       - Go to filter by form for Survey Table                    
        1. In the space below GENRE type this expression, then Toggle                     
        the filter                    
        romance or drama                    
       - Go to filter by form for Survey Table, then use the "Clear Grid" command                    
        2. In the space below RATING, type this expression, then Toggle                     
        the filter                    
        >3                    
        (Note: the greater than symbol is Shift-Period on the keyboard)                    
       - Go to filter by form for Survey Table, then use the "Clear Grid" command                    
        2. In the space below MATURITY RATING, type this expression,                     
        then Toggle the filter                    
        not r                    
                             
    HOME WORK                    
                             
    10. Choose one of your information areas + record some data                    
     - NOTE: Keep it simple.  I repeat, keep it SIMPLE.                    
      a. Choose one of your information areas                    
      b. On a small piece of paper, begin to record a small amount of data related to this                    
      topic area                    
         - You may choose to write unstructured notes.  This will be a few                    
        instances of the kind of data that belong to this topic area                    
         - Then, you can use the structuring process to create fields                    
      c. Keep it simple.                    
         - Use just a few fields                    
         - In other words, ask yourself, "What are the primary/essential                     
        pieces of data I need to begin to describe this topic area?"                    
         - If you know a lot about this topic area, answering that question                     
        may be difficult for you                    
     - You do not need to make a table yet                    
       - This is step 2 of the process: generate a small amount of data                    
       - Next week you'll do step 3 (make an Access database and a table)                    
                             
                             
                             
    LOG YOUR COMPLETION OF EACH ASSIGNMENT                    
                             
                             
                             
        Wednesday, November 09, 2016                    
                             
    WARM-UP / QUESTIONS                    
                             
    A. Who has questions about the HW?                    
      7. Collect raw data (i.e., take notes) about places you go                    
      8. Use this unstructured data to "tease out" a table                    
        Go from "situations" to "tabular data"   LINK              
                             
                             
    B. Practice: Make these sample tables                    
     - Let's practice creating tables in datasheet view                    
       - Remember to make an Access database first                    
       - NOTES:                    
        a. Don't try to put all 3 tables into a single table object                    
         - Each of the tables shown will be a separate table object                    
        b. Ignore the warning that a field name is a reserved word                    
         - Just click "OK"                    
        Make these sample tables   LINK              
                             
                             
  25.                          
    Soon it will be time for you to develop your own Access project                    
     - Step 1: Think!                    
       - See the HW, below                    
     - You will write 3 topic ideas.  What is a "topic idea"?                    
       - A topic idea is a type of information that matters to you                    
       - In other words, a topic idea is the name of a kind of information that you willingly                   
      notice, gather or use                    
       - Why might a person willingly or enthusiastically engage with a type of                     
      information?  Here are three possible reasons.  To that person that information                  
      seems:                    
         - important, or                    
         - interesting, or                    
         - meaningful                    
                             
  26.                          
    From table to form - instant results                    
     - We will explore ways to quickly make forms                    
      1. Select a table                    
         - Click once on a table (in the Navigation Pane) to select it (make                    
        it look highlighted)                    
     - Ribbon path:                    
      2. "Create" ribbon > "Forms" section                    
      3. Click on the "Form" icon (or click on the "More Forms" icon)                    
     - Download this database to the Intro to Access folder (if it is not                     
    already there)                    
        Second Database   LINK              
         - In the Navigation Pane, click once on the Survey Table icon to                     
        select it                    
         - Then click on the "Form" icon in the Create ribbon                    
         - This is an "instant wizard" that doesn't give you any options                    
                             
    HOME WORK                    
                             
    7. Collect some raw data                    
     - Places to which I go (by car, foot, bus, bicycle…)                    
     - Keep a record for 4 to 7 days:                    
      - Just keep notes.  They can be unstructured.  It does not need to be a table.                    
         - We will make the table later                    
       - Due date: Wednesday, November 16                    
                             
                             
                             
    LOG YOUR COMPLETION OF EACH ASSIGNMENT                    
                             
                             
                             
    9. It's time for you to develop your own Access project.  Step 1: Think!                    
       - Write 3 topic ideas.  Each topic is a type of information that matters to you.                    
      Each topic should be "significant" because you consider it IMPORTANT, or                    
      INTERESTING, or MEANINGFUL.                    
         - This is a 5-minute exercise.  You do not need to make a table, yet.                    
                             
                             
                             
    LOG YOUR COMPLETION OF EACH ASSIGNMENT                    
                             
                             
        Wednesday, November 02, 2016                    
                             
    WARM-UP / QUESTIONS                    
                             
    Who has questions about the HW?                    
     - Practice "filter by selection" in Survey Table (in Second Database)                    
        Second Database   LINK              
       - Filter for "drama" (in Genre field)                    
       - Filter for "G" (in Maturity Rating field)                    
       - Add to filter 5 (in Rating field)                    
                             
                             
  23.                          
    Tables: A breakthrough concept                    
     - Sometimes your data isn't tabular                    
       - In fact, it may appear to be "unstructured"                    
       - You have to "massage it" to get a tabular representation                    
        Go from "situations" to "tabular data"   LINK              
     - Start with simple lists                    
     - Then, make your table on paper                    
       - Remember to identify data types as well as field names                    
                             
  24.                          
    Basic database tools: Filtering                    
     - "Filter by Form"                    
         - NOTE: The "form" in Filter by Form does not have anything to                    
        do with the forms we create as objects in the database                    
         - It is called that because they give you a type of "form" layout in                     
        which to create filters                    
     - We will open the Survey Table & explore "Filter by Form"                    
       - Command path:                    
        Home ribbon > Sort & Filter section > Advanced Filter Options                     
        menu > Filter by Form command                    
     - What can you do in "Filter by Form"?                    
        a. See the filter rule created by Filter by Selection                    
        b. Make a filter rule using a point-and-click method                    
        c. Other stuff that you'll learn later                    
        d. Make a query                    
     - How do you leave the "Filter by Form" mode                    
       - Click on the "Toggle Filter" icon                    
         - This goes back to the data (datasheet view) and turns on the                    
        filter                    
     - We can use Second Database to explore this                    
        Second Database   LINK              
     - Let's do these exercises                    
        Filter by Form exercises   LINK              
                             
    HOME WORK                    
                             
    7. Collect some raw data                    
     - Places to which I go (by car, foot, bus, bicycle…)                    
     - Keep a record for 4 to 7 days:                    
      - Just keep notes.  They can be unstructured.  It does not need to be a table.                    
         - We will make the table later                    
       - Due date: Wednesday, November 16                    
                             
                             
                             
    LOG YOUR COMPLETION OF EACH ASSIGNMENT                    
                             
                             
                             
    8. Go from "situations" to "tabular data"                    
        Go from "situations" to "tabular data"   LINK              
       - Turn these four descriptions of situations into structured/tabular data                    
       - Begin by making lists of data that fit patterns you notice in all of (or most of) the                    
      descriptions                    
       - Please feel free to work on paper as you make your lists and guess at the data                    
      types                    
       - After you design your table on paper, then start Access                    
         - Make a new database and name it ("Unstructured Data Exercise")                  
         - Start designing your table in datasheet view                    
                             
                             
                             
    LOG YOUR COMPLETION OF EACH ASSIGNMENT                    
                             
                             
        Wednesday, October 26, 2016                    
                             
    WARM-UP / QUESTIONS                    
    Add a table to the Geography database                    
     - Make (or use) the geography database (Geography.accdb) in the                     
    "Intro to Access" sub-folder                    
       - While you are designing the table, add these fields                    
         - All 3 fields are data type Text                    
         - Field names:                    
        City                    
        State                    
        Country                    
       - When you close and save the table give it this name:                    
        Cities I have visited                    
                             
                             
  19.                          
    Basic database tools (Access)    
 
             
     - SEARCH/FIND                    
     - There is a correct sequence of steps to using the search tool                    
      1. Click on a cell in the field you want to search in                    
      2. Click on the binocular tool (or do Ctrl-F)                    
      3. Type the text you're searching for in the "Find What:" field                    
      4. Change the "Match:" field to "Any Part of Field"                    
      5. Click the "Find Next" button until no more records are located                    
        "Microsoft Accessed finished searching the records.  The search                     
        item was not found."                    
     - Practice this on the Survey Table                    
       - Find movie titles that contain "music"                    
        First Database   LINK              
         - Note: You don't need to download this if you previously                     
        downloaded it                    
                             
  20.                          
    Preparation for filtering - learn the icons                    
     
 
                     
                             
                             
                             
                             
     - Selection:                     
       - Icon appearance: funnel + lightning bold                    
       - Also called "Filter By Selection" (Access 2003)                    
         - "Use a cell's value as the rule"                    
     - Advanced:                    
       - Icon appearance: funnel + a rectangle                    
       - This is a menu of commands                    
         - We'll talk about this later                    
     - Toggle Filter:                    
       - Icon appearance: funnel                    
         - It means, "Make the filter active or inactive"                    
         - It doesn't really remove the filter.  It just turns it off (or turns                     
        it on).                    
                             
  21.                          
    Basic database tools (Access)                    
     - FILTER                    
       - Basic filtering of a datasheet ("lightning bolt")                    
     - We will practice using table Survey Table                    
     - Download this database to the "Intro to Access" folder                    
        Second Database   LINK              
     - Filter by selection                    
      a. Click on a desired value in a field (column)                    
      b. Click on the "Filter by Selection" icon (funnel + lightning bolt)                    
      c. Click on the command "Equals xxxx"                    
         - Done!                    
      d. Remove (or apply) the filter using the "Toggle Filter" icon                    
      e. To save the filter, close the Survey Table window                    
         - Save the changes to the design of Survey Table                    
                             
  22.                          
    What is a form?  How can you use it?                    
     - We will practice these operations                    
       - View record information                    
       - Modify part of a record                    
       - Add a new record                    
       - Sort                    
       - Search                    
     - Download this database to the Intro to Access folder (if it is not                     
    already there)                    
        Second Database   LINK              
       - We will examine one of the Survey Table forms                    
                             
    HOME WORK                    
                             
    6. Practice "filter by selection" in Survey Table (in Second Database)                    
        Second Database   LINK              
      a. In Genre, filter for dramas (click on "drama", then lightning bolt icon)                    
         - How many are there?                    
      b. Turn the filter off (click Toggle Filter icon)                    
      c. In Maturity Rating, filter for G movies                    
         - How many are there?                    
      d. Leave the filter on.  Filter in the Rating field for movies rated 5.                    
         - Note: this is a compound rule (records where Maturity Rating =                     
        "G" AND where Rating = 5)                    
         - How many are there?                    
      e. Close Survey Table and save the changes                    
                             
                             
                             
    LOG YOUR COMPLETION OF EACH ASSIGNMENT                    
                             
                             
        Wednesday, October 19, 2016                    
                             
    WARM-UP / QUESTIONS                    
    How did your HW go?  Any questions?                    
      3. Make a "simple contact table" with just two fields                    
         - Do this table either in Excel or on paper                    
      4. Basic database tools - SORT                    
        First Database   LINK              
                             
                             
  16.                          
    Table basics: Datasheet view, Part 2                    
     - The mechanics of using a table (datasheet view)                    
       - Freeze and unfreeze columns                    
       - Move a column                    
     - We will practice on Survey Table in this database                    
        First Database   LINK              
      Note: to make this work, please resize the Survey Table window so it does not                    
      show all the fields.  Make the window quite narrow.                    
                             
  17.                          
    Table basics: Datasheet view, Part 3                    
     - The mechanics of using a table (datasheet view)                    
       - Change a field name                    
       - Add a field                    
       - Change a field's data type                    
     - We will practice on Survey Table in this database                    
        First Database   LINK              
                             
  18.                          
    Make an Access table (in a new database file)    
 
             
    1. We must create a blank database file                    
       - Name the file: "Geography"                    
       - Save it in My Documents                    
         - Different from Word/Excel/PowerPoint: you create the database                   
        file before you  begin to work                    
    2. Create a table's design in Datasheet View                    
       - Super easy with a newly created database file                    
         - A new database opens a blank datasheet so that you can begin to create a table                    
        immediately                    
    3. For each field: a. give a data type, b. type the field's name                    
       - First field data type = Text                    
         - First field name: "State"                    
       - Second field data type = Text                    
         - Second field name: "Capital"                    
    4.We enter some data (optional)                    
       - Why optional?  Because you can do Step 5 without entering data, and then                     
      come back to it later to enter some data.                    
    5. Close the table, save the table, name the table                    
       - Give it a name: "State Capitals"                    
    6. We re-open the table & enter data                    
                             
                             
                             
    7. Is anybody interested in making a second table called "Country                     
    Capitals"?                    
       - Command path:                    
        Create ribbon > Tables section > Table icon                    
         - This gives you a new, blank datasheet.  (See step 2.)                    
                             
    HOME WORK                    
                             
    5. Make an Access table (in a new database file)                    
       - Follow the instructions we did above to:                    
         - Make an Access database called "Geography"                    
         - Make a table of state capitals                    
         - Create the fields, then name the table "State Capitals"                    
         - Make a table of country capitals                    
         - Create the fields, then name the table "Country Capitals"                    
                             
                             
                             
    LOG YOUR COMPLETION OF EACH ASSIGNMENT                    
                             
                             
        Wednesday, October 05, 2016                    
                             
     
 
                     
                             
                             
                             
                             
                             
                             
                             
  12.                          
    Preparation for the homework                    
     - You can make a simple table on paper, or in Excel                    
      First field's name: Name of Person                    
      Second field's name: Type of Contact                    
         - For instance, Family, Work, School, etc.                    
                             
  13.                          
    Basic database tools (Access)                    
     - SORT                    
     - Download this database to the Intro to Access folder                    
        First Database   LINK              
       - We will open the Survey Table                    
       - Click a field, then click the A-Z tool (or the Z-A tool)                    
     - See the HW below for practice exercises                    
                             
  14.                          
    Table basics: Datasheet view, Part 1                    
     - The mechanics of using a table (datasheet view)                    
       - Using the record navigator icons                    
       - Adding and modifying records                    
     - We can use Survey Table in First Database to explore this                    
       - If necessary, download this file (to the Intro to Access folder)                    
        First Database   LINK              
                             
  15.                          
    Table basics: Datasheet view, Part 1 (cont'd)                    
     - The mechanics of using a table (datasheet view)                    
       - Column width                    
       - Row height                    
     - We can use Survey Table in First Database to explore this                    
                             
    HOME WORK                    
                             
    3. Make a "simple contact table" with just two fields                    
    a. General plan, then get to work                    
      First field's name: Name of Person                    
      Second field's name: Type of Contact                    
         - Do this table either in Excel or on paper, please (Bob has his                     
        reasons for this.)                    
         - Something to notice: you give a name to each field (at the top of                     
        each column)                    
    b. Save and name your table                    
       - If you did it on paper, you may put a title at the top of the sheet of paper                    
       - If you did it in Excel, you save the file and give it a name                    
         - Also, you can use the same table name for the sheet tab                    
                             
    c. Some things to think about:                    
       - The name of the table is separate from the field names                    
         - In other words, fields have names, and the table has a name                    
       - You may find yourself repeating values in some of the records                    
         - Repeating values are a sign that the field is categorizing data                    
                             
                             
                             
    LOG YOUR COMPLETION OF EACH ASSIGNMENT                    
                             
                             
    4. Basic database tools - SORT                    
     - Download this database to a known folder, such as My Documents                    
        First Database   LINK              
       - Open the Survey Table                    
       - Click a field, then click the A-Z tool (or the Z-A tool)                    
                             
                             
                             
    LOG YOUR COMPLETION OF EACH ASSIGNMENT                    
                             
                             
        Wednesday, September 21, 2016                    
                             
    WARM-UP / QUESTIONS                    
    A. How did your HW go?  Any questions?                    
                             
    B. More practice: make 2 lists on paper (or using Excel)                    
       - Please name each list so someone else knows what it is about                    
         - On paper, you can write the name above the list                    
         - If using Excel, name the sheet tab                    
                             
                             
  8.                          
    Check if the Intro to Access folder is empty                    
     - Start Windows Explorer & navigate as follows                    
      1. Desktop (leftmost arrow in the path)                    
      2. Profile folder (in the double-click area, man sticking his head in a folder)                    
      3. My Documents (the icon in the double-click area)                    
      4. Intro to Access (the icon in the double-click area)                    
     - Use Ctrl-A to "select all" & the <Delete> key to move the files                    
    to the Recycle Bin                    
     - Finally, minimize this window.  We will use it later.                    
                             
  9.                          
    Download this file to the Intro to Access folder                    
     - Please use Internet Explorer                    
     - Click this hyperlink and choose the Save As option                    
        Movie recommendation flat file (survey-table.xls)   LINK              
       - In the Save As window, you will see Windows Explorer embedded                    
         - Use the same 4 steps we used above to navigate to the Intro to                    
        Access folder, then click the Save button in the Save As window                    
                             
    WARM-UP / QUESTIONS                    
    C. Practice doing Excel sort, filter & find on a "flat file database"                    
     - Find this file in the Intro to Access folder, double-click, & enable                    
        Movie recommendation flat file (survey-table.xls)   LINK              
      1. Sort by Movie Title                    
      2. Sort by Genre                    
      3. Filter for Childrens movies (in Genre)                    
      4. Remove Genre filter                    
      5. Filter for G rated (in Maturity Rating)                    
      6. Remove Maturity Rating filter                    
      7. Find "music" in a cell's value                    
                             
                             
  10.                          
    From lists to tables                    
     - Single lists are unconstrained (not affected by other lists)                    
     - The "lists" (or fields) in a table are constrained                    
       - In other words, the data in a record is correlated                    
       - It is not free to vary                    
     - Let's illustrate this                    
        From a List to a Table   LINK              
                             
  11.                          
    How many different kinds of tables are there?                    
     - In other words, what can you do with tables?                    
       - Let's look at some ideas                    
        A List of Table Ideas   LINK              
         - Each one of these could be a database                    
                             
                             
    HOME WORK                    
                             
    2. Practice doing Excel sort, filter & find on a "flat file database"                    
     - If necessary, download this file (to My Documents, for instance)                    
        Movie recommendation flat file (survey-table.xls)   LINK              
      1. Sort by Movie Title                    
      2. Sort by Genre                    
      3. Filter for Childrens movies (in Genre)                    
      4. Remove Genre filter                    
      5. Filter for G rated (in Maturity Rating)                    
      6. Remove Maturity Rating filter                    
      7. Find "music" in a cell's value                    
                             
                             
                             
    LOG YOUR COMPLETION OF EACH ASSIGNMENT                    
                             
                             
        Wednesday, September 21, 2016                    
                             
  2.                          
    If you do not have Microsoft Access, use the Computer Lab                    
     - SCE runs a computer lab for students at the Anaheim campus                    
       - Here is the schedule                    
        Information About the Computer Lab   LINK              
                             
  3.                          
    Starting with something very simple                    
     - Before we get into tables, let's start with something simple and                     
    familiar:                    
       - The List                    
     - Let's make some quick lists                    
       - Then you can do this at home                    
         - See homework                    
         - Do it on paper, please                    
                             
  4.                          
    The Intro to Access Skills Inventory                    
       - Not a test, just a quick self-evaluation                    
       - Also, it's an overview of the class                    
        Access Skills Inventory (online version)   LINK              
                             
  5.                          
    What is a flat file database?                    
     - All your data is contained in a single table                    
       - This is a good place to start (before using "relational" databases)                    
     - A table is a structured method of storing data                    
       - Fields define the columns                    
        A field has a name and a data type (text, number, date/time, etc.)                    
       - A record is stored in a single row                    
        A record contains all the fields (even if they have no data)                    
                             
  6.                          
    Go to the "Intro to Access" folder using Windows Explorer                    
     - We will delete all the files from that folder                    
     - Use Windows Explorer to open the folder "Intro to Access" below the                    
    My Documents folder                    
       - Start Windows Explorer (click on the manilla folder icon in the Task Bar)                    
        a. Click on the leftmost arrow in the path                    
        b. Click on Desktop in the list                    
        c. Double-click on the profile folder icon (man sticking his head into                     
        a folder)                    
        d. Double-click on the My Documents folder icon                    
        e. Double-click on the "Intro to Access" folder                    
       - The path should end with "Intro to Access", meaning that is the folder whose                    
      contents are being displayed                    
                             
  7.                          
    How to download files from this web site                    
     - Goal: Use "Save As" to download a file to the My Documents folder                    
         - NOTE: Do the Save As for the file pointed to by the hyperlink,                     
        not Save As for the web page itself                    
     - Part A: use Internet Explorer to go to Save As                    
      1. Use Internet Explorer to view Bob's web page                    
      2. Click on the hyperlink to a class file                    
      3. Use "Save As" (not "Open" or "Save")                    
     - Part B: use Windows Explorer embedded within Save As to focus on                     
    the location "Intro to Access"                    
      4. Save it to the "My Documents" folder (not the "Documents" library)                    
        a. Click on the leftmost arrow in the path                    
        b. Click on Desktop in the list                    
        c. Double-click on the profile folder icon (man sticking his head into                     
        a folder)                    
        d. Double-click on the My Documents folder icon                    
        e. Double-click on the "Intro to Access" folder                    
     - Part C: use the pure Windows Explorer to find and open the file                    
      5. Use Windows Explorer to open the folder that contains the file                    
        a. Click on the leftmost arrow in the path                    
        b. Click on Desktop in the list                    
        c. Double-click on the profile folder icon (man sticking his head into                     
        a folder)                    
        d. Double-click on the My Documents folder icon                    
        e. Double-click on the "Intro to Access" folder                    
      6. Find the file, and double-click it to open it                    
      7. If you see a gold area at the top, click the "enable" button in that area                    
         - This will unlock the file since you have declared it safe                    
     - Example                    
        Movie recommendation flat file (survey-table.xls)   LINK              
                             
    HOME WORK                    
                             
    1. Make three lists on paper                    
       - Please name each list so someone else knows what it is about                    
                             
                             
                             
    LOG YOUR COMPLETION OF EACH ASSIGNMENT                    
                             
                             
        Wednesday, September 14, 2016                    
                             
  1.                          
    Getting started                    
     - Course outline & grading procedure                    
        Course Outline   LINK              
       - Eighty percent attendance + complete 50% of homework = you pass!                    
     - Tour of this web site                    
       - Open all day and night for you to explore                    
        Easy web address: nahlej.net