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 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
- 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
- Hybrid tasks
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).
- Logging into the SCCC EdNet
- Looking at SCCC computer Start section
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.
- Find everyone's student
- Log into system as guest
- Log into system with student info
- Internet Explorer: toolbar, url, tabs, options
- Contacting LJ - add email@example.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.
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.
- Sorts and filtering only go down a couple of levels.
- You can't really query a spreadsheet for a clean, simplified copy of a
- 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
- 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.
- A database is an organized collection
- 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.
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
- Databases are somewhat similar to spreadsheets, but databases are more
demanding than spreadsheets because of their ability to manipulate the data
that is stored.
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.
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
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.
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.