Week 1: June 24-28




Introduction to MIC120 class, Excel Review, Intro to Database concepts

Book: Chapter(s) 1, Pages 3-17. Hybrid Tasks: Review Access Intro.


FIRST - no worries. If you are not yet signed up for this class, and/or are awaiting financial aid, you can sign into the computers as a guest: just hit enter at the open login, then enter again. This should work for the first 2 weeks.


NOTE: It turns out that students can only get into the Studio|Bast CANVAS tool once they are actually registered for a class and payment (whatever arrangement) HAS been received and the IT dept notified to "activate" the student's current logins and passwords.





  • Class Information
  • Context of this class
  • Get logged in to SCCC computer
  • Web Browser Email Basics






Class Requirements

  • Class Book: Microsoft Access 2010 Step by Step, Lambert/Cox, Microsoft Press, ISBN: 13: 978-0735626928. Used, digital, library okay.
  • 24/7 internet access, even dial-up or cell phone texting.
  • Access to the program MS Access 2007/2010 (school, home, library, community center, etc.).
  • Email account.
  • 1gig USB Flash drive,
  • Class web site (you are here now!)
  • Studio|Bast CANVAS tool
  • SCCC programs access - class, computer lab, library.
  • Attendance and performance
  • Hybrid Elements: Weekly hybrid tasks
  • Time management - 3:1


Class website

  • Navigation
  • Book
  • Hybrid tasks
  • Help


Attendance and performance


What this class does

  • Understand database concepts.
  • Recognize commonly used database terms and abbreviations.
  • Access and edit the main components of a MS Access database: tables, relationships, forms, and reports.
  • Create basic relationships and queries.
  • Build a simple MS Access database that works.
  • Understand and discuss issues and trends related to database use.
  • Communicate effectively orally and in writing.
  • Recognize and appreciate the diversity both in the classroom and the IT field and community.
  • Practice efficient communications and interactions with each other and supervision (instructor).


Class Preparation

  • Logging into the SCCC EdNet
  • Looking at SCCC computer Start section


Class Preparation



Get into our Studio|Bast CANVAS tool

  • Log On: Your login is your full Student ID number, and your password is the first 6 letters of your last name.
  • Forum
  • Quizzes
  • Grades



  • Find everyone's student login
  • Log into system as guest
  • Log into system with student info
  • Internet Explorer: toolbar, url, tabs, options
  • Contacting LJ - add ljbtrainings@studiobast.com to your email contact list



  • SUPER HOT: Get your book ASAP!
  • HOT: Get a 2 gigabyte USB Flash drive before Tuesday
  • Check out your Learning Style to see what class info/method you might need to boost.













Information/data collection

  • Purposes
  • Methods
  • Storage
  • Uses


Excel as a common tabular collection method

  • Easy-to-create tabular data design.
  • Easy to format to look nice.
  • Allows thousands of rows and dozens of columns.
  • Enables simple charts and graphs.
  • You can sort and filter data.
  • You can save specific filtered and sorted views.


Excel/spreadsheet limitations

  • Sorts and filtering only go down a couple of levels.
  • You can't really query a spreadsheet for a clean, simplified copy of a subset of information.
  • You can easily have unnecessary duplication of information.
  • You can hide and filter columns for viewing, but the data is still there.
  • Large spreadsheets get unwieldy for quick filters on the fly.
  • Spreadsheet information not really scalable for months to years of capture and use.
  • Spreadsheets commonly used for calculations as well as data layout, and calculations can be easily corrupted.


Specific Spreadsheet Issues that Databases resolve
One customer, different names, emails, addresses - HOW to keep that information consistent? Spellings, abbreviations, punctuation, etc.? How to find the same customer? HOW to keep the checks and balanaces lean and not corrupt a spreadsheet/workbook? How to make scalable?

  • Dropdown lists (states).
  • Criteria (no punctuation)
  • Specific formats (directionals changed to abbreviations, dates/times, phone numbers turned to dashes, credit card numbers)
  • Variants: look for and pull error for spellings, out-of-order info.
  • Unique ID - one per customer, product, vendor, etc. Catch redundancies.


Database concepts*

  • A database is an organized collection of data. 
  • Databases are created to operate large quantities of information by inputting, storing, retrieving, and managing that information.
  • Databases use a table format, that is made up of rows and columns.
  • Each piece of information is entered into a row, which then creates a record.
  • Once the records are created in the database, they can be organized and operated in a variety of ways that are limited mainly by the software being used.
  • Databases are somewhat similar to spreadsheets, but databases are more demanding than spreadsheets because of their ability to manipulate the data that is stored. 

*Per Wikipedia.


Database Examples

  • Google: Must recognize several ways a word or name can be input. Different ways it can be on the web already. what is most likely list of responses to list first of thousands?
  • Expedia: Must recognize customer, login, banking info, travel preferences, purchased trips itinierary, changes in airline status, insurance, recommend things to do, make special offers, upsell, sort by price/location, offer maps. Must have secure transactions, contact hotels, confirm reservations.
  • Amazon: must recognize customer, login, purchaing info. Must secure it. Must suggest alternatives/faves. Must report status, out-of-stock, colors, quantities. Must report info to vendors, shippers, suppliers. Must offer comments. Must have secure transactions.
  • Everquest II: Must tie several characters to account. Must link EULA issues. Must store character information - race, skills, status, weapons. Must tell if gold or free membership and amenities. Must place character locations. Must direct fighting actions and spawning of NPCs. Must update game, verify passwords.


Access Databases

Microsoft Access is a relational database management system program. It supports*:

  • Data definition: defining new data structures for a database, removing data structures from the database, modifying the structure of existing data.
  • Updating: Inserting, modifying, and deleting data.
  • Retrieval: obtaining information either for end-user queries and reports or for processing by applications.
  • Administration: registering and monitoring users, enforcing data security, monitoring performance, maintaining data integrity, dealing with concurrency control, and recovering information if the system fails.

*Per Wikipedia.


Class Database

We will use the Gardening Database in the Step-By-Step Access 2010 book. This will allow us to have consistent examples, follow steps, see what works and what doesn't, and help each other out.



Let's look at a "flat" Excel table spreadsheet.

  • Download Gardening.xlsx and SAVE to your pen drive.
  • Open in MS Excel 2010
  • Focus on the first tab.
  • We'll look at the sorts and filtering we can do.









  • Get your book ASAP.
  • Review class website, especially the Navigation and FAQs.
  • Get familiar with the Studio|Bast CANVAS tool (grades, assignments, quizzes)
  • Forum Assignment: Sign on to the Studio|Bast CANVAS tool and Answer the Forum's WEEK 1 Question for 10 points.



  • Book: Chapter(s) 1, Pages 3-17
  • Hybrid Tasks: Review Access Intro.