MIC120: MS Access 2013      nonessential: image of LJ's Twitter Icon

SUMMER QUARTER 2014

8/22/14

Summer Quarter is OVER!!!

I am on break from August 21 afternoon until September 22. I will be checking my teaching email account rarely and am not available to visit campus.

I have graded all finals, and submitted the quarter's grades to the Seattle Central system. You can get your grade there on August 28, 2013, or look for your grades and my comments in the grading section of CANVAS tool. I will not handle queries until after Fall Quarter starts, and I will not renegotiate grades or be able to change anyone to a non-credit or incomplete. Please see the Class FAQs page if you have grading and late-work policy, and/or general questions.

In the next week or so, I will post the links to our class site under "Past Classes". I will archive our assignments and grades on CANVAS, and I will archive our emails.

If you have an urgent need, outside of this class, please contact our division office at 206-587-3830 or the Information Technologies office at 206-516-3150.

Have a most excellent break!

8/15/14

COVERED THIS WEEK

  • Database from Scratch
  • More Tables
  • Relationships
  • Importing
  • Exporting
  • Analyze Performance
  • Locking
  • Object Dependencies
  • Splitting
  • Database Security
  • Database Utilities
  • Building databases from scratch

TO DO

  • MIC FINAL: Full Database, due BEFORE 12:30pm Thursday, August 21. 120 Points. I will not accept late uploads or assignments for any reason. NO!

REVIEW RESOURCES


8/7/14

COVERED THIS WEEK

  • Reports
  • Report Wizards
  • Report Layout
  • Report Print Preview
  • Reports Design
  • Report Properties
  • Controls
  • Subreports
  • Final Project Discussion
  • Getting Started on Final Project
  • Building databases from scratch
  • Planning Methods

TO DO

  • MIC ASSIGN 6: Reports, due before 11:59pm, Sunday, August 10.
    • Complete ALL of Lesson 5, use GardenShop5.accdb. Also images ClayPots and Garden Gate. You don't need to upload the extra database you use to import from.
    • Save YOUR version of the database file as assign6firstinitiallastname.accdb so I know whose file it is I am grading.

REVIEW RESOURCES


7/31/14

COVERED THIS WEEK

  • Forms
  • Form Wizards
  • Form Layout
  • Form Tools
  • Forms Design
  • Controls
  • Subforms

TO DO

REVIEW RESOURCES


7/25/14

COVERED THIS WEEK

  • Queries
  • Query Wizards
  • Query Creation
  • One-table queries
  • 2-table queries
  • Queries, complex
  • Find Duplicates
  • Calculate
  • Append
  • Delete

TO DO

REVIEW RESOURCES


7/18/14

COVERED THIS WEEK

  • Create new tables
  • Keys
  • Import data into new table
  • Import from elsewhere to create a new table
  • Normalizing
  • GMETRIX: Brief overview and resource links
  • Tables: Design
  • Relationships
  • Referential Integrity

TO DO

REVIEW RESOURCES

7/10/14

NOTE: I will check emails on Friday and Sunday, but likely take Saturday away from my computer.

COVERED THIS WEEK

  • Quick Review
  • Access 2013 overview and interface
  • Setting preferences
  • Databases: existing, saving, closing
  • Database objects: Navigation bar, naming conventions
  • Reminder: On-Your-Own Tasks and Resources
  • Databases: existing tables
  • Tables: Datasheet
  • Tables: Design view
  • Redundancy/Repetition
  • Sorting
  • Filtering

TO DO

  • MIC AGREE: Due Sunday, July 13, before 11:59pm, on CANVAS tool.
  • MIC ASSIGN 1: Table - Edits/Sorts, due Sunday, July 13, before 11:59pm. Lesson 2, approximate pages 78-89
    • (Learn the Skill Modules: Updating and Deleting Records, AND Manipulating a Datasheet).
    • USE GardenShop2.accdb, and save YOUR version of the file as assign#firstinitiallastname.accdb so I know whose file it is I am grading.
    • You do NOT need to try to upload the linked Excel table - I just want your database .accdb file.
    • IF you need a picture-free PDF of the instructions because you don't have the book, click HERE.

REVIEW RESOURCES

7/3/14

COVERED THIS WEEK

  • Context of this class
  • Get logged in to Seattle Central computer
  • CANVAS
  • Computer Resources
  • Web Browser Email Basics
  • USB/Flash drive set-up
  • Excel Basics
  • Excel table queries
  • Database concepts

TO DO

REVIEW RESOURCES

  • Book: About This Courseware
  • On-Your-Own Tasks: Access Intro.

6/22/14

MIC120 MS Access 2013, #1964, Section 1, T&Th 1:00-2:50pm, Room BE3174.

If you are HERE, you are in the right place! This is the Home Page of L.J. Bothell's MIC120 class website.

NOTE: It turns out that students can only get into the 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.

What's next?

  • READ over this page for general MIC120 information.
  • READ/ACT ON the ARE YOU READY page for general MIC120 information.
  • CLICK the various links on the left-hand side of this page to find your way around this website.
  • GO TO the notes for Week 1.

The REQUIRED book is: Microsoft Access 2013 Certification Guide, Lambert/Cox, Microsoft Press, ISBN: 13: 978-1-55332-399-0, and the SCCC bookstore will be stocking it for us.

@@@@@@@@@@@@@@@@@@@@@@@@

LJ's Class Rules

Class Layout

  • Primairly face-to-face class with hybrid information elements to make up additional credit hours.
  • Tuesdays and Thursdays, 1:00-2:50pm, Room BE3174.

Here are our objectives:

  • Identify the major hardware components of a computer.
  • Recognize terms and abbreviations commonly used in the IT field.
  • Identify categories of software applications and their typical use in the business and IT field.
  • Use printed and electronic resources and the internet to research topics relevant to the IT field.
  • List the basic functions of an operating system.
  • Understand and discuss issues and trends in the IT field.
  • 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).

At this point, we'll be primarily a quiz and short assignment/task-based class, although good attendance/participation is critical.

In most cases I'll chat and demo stuff at the beginning of class, set up assignment goals, and see if we can tuck in at least a few minutes per class for working/questions. I'll also aim for one or two short breaks so our minds don't implode.

I'll make sure we all have the basics and are on the same page as we go. I will also will spend a little time in setting up each assignment, with

  • The objectives,
  • Tips and tricks
  • How the assignment fits in the real world, and
  • How to approach assignments and projects, and
  • Extolling the virtues of my favorite beverage - mochas!
BACK TO TOP