Book cover image for Microsoft Office Access 2007: Comprehensive Concepts and Techniques

CMPT 110

10/07/13

Home
CMPT 125
CMPT 110
CMPT 210
CMPT 260
Information
Photo Gallery

 

Welcome to Introduction to Databases!

bulletSyllabus      
bulletLab Sheet
bulletDesign Document Example
bulletCSV File

horizontal rule

Reading Assignments

bullet

Lesson 1 - Read Chapter 1 pages 2-63 in the text Access 2007Comprehensive Concepts and Techniques.

bullet

Lesson 2 - Read Chapter 2 in the text Access 2007 Comprehensive Concepts and Techniques.

bullet

Lesson 3 - Read Chapter 3 in the text Access 2007 Comprehensive Concepts and Techniques.

bullet

Lesson 4 - Group Activity - One-to-Many Relationships - Not in the book

bullet

Lesson 5-  Read Chapter 4 - Reports  and Forms

bullet

Lesson 6- Chapter 5 - Project 5 Enhancing Forms with OLE Fields, Hyperlinks and Subforms

bullet

Lesson 7 - Group Activity - Many-to-Many Relationship - Not in the book

bullet

Lesson 8- Read pages 205 - 230  Sharing Data among Applications - My lecture is outside the book - Import of a CSV file - Lab8

bullet

Lesson 9- Chapter 6 - Project 6 Switchboards

bullet

Lesson 10 - On-to-One Relationships - Group Activity - Not in the book

bullet

Lesson 11 - SQL - Read http://www.w3schools.com/sql/sql_intro.asp

bullet

http://fisher.osu.edu/~muhanna_1/837/MSAccess/tutorials/sql_intr.pdf

bullet

http://www.cwnresearch.com/resources/databases/access/tutorials/access2000/SQLQueries/SQLQueries.html

bullet

Lesson 12 - Chapter 7 - Advanced Report and Form Techniques

bullet

Lesson 13 - Chapter 8 - Advanced Form Techniques

bullet

Lesson 14 - Web Features

 

horizontal rule

Lab Assignments

Labs are to be done in class on Mondays.  You must have me sign your Lab sheet.  Print off a copy of the lab sheet above.  Please keep your lab sheet up to date.  The lab sheet will be collected and graded in the last few weeks of the semester.  You are responsible for your lab sheet!  I do NOT have a copy of your lab sheet or record them as individual grades in the MySMCC system. For a lost or misplaced lab sheet I may not resign off on your work.  

bullet

Lab 1 - scsite.com/ac2007/learn - Chapter 1 Practice test.  Copy results to a Word or NotePad and save your file as PracticeTest and then Zip the file into a folder with your name. Example: PracticeTestWplourde.zip. If you need help here is a link to some How-To Videos. In the Lab 1 - Creating the JMS TechWizards Database Page 67

bullet

Lab 2 - In the Lab - 1 Querying the JMS TechWizards Database - Page AC 131

bullet

Lab 3 - In the Lab - 1 Maintaining the JMS TechWizards Database - Page AC 199

bullet

Lab 4 Sheet - Create the database for a One-to-Many Relationship

bullet

Lab 5 - In the Lab - 1 Chapter 4 - Reports  and Forms

bullet

Lab 6 - In the Lab - 1 Enhancing the JMS TechWizards Database , Add an OLE Object and Hyperlink - Page 352 - 353

bullet

Lab 7 - Many-to-Many Relationships - Enhancements to Study for Task 2

bullet

Lab 8 - Import the CSV file and create a report and group them by Major.

bullet

Lab 9 - In the Lab - 1 Creating Macros and Switchboards - Page 418, Questions 1-3

bullet

Lab 10 - One-to-One Relationships

bullet

Lab 11 - In the Lab - 1 SQL - All questions - Page 455.

bullet

Lab 12 - In the Lab - 1 Applying advanced Report and Form Techniques. Page 517. 

horizontal rule

Where to Get Access 2007


  The Computer Technology Dept. at Southern Maine Community College is a subscriber to the Microsoft Developer's Network Academic Alliance (MSDNAA). This will allow you to download the software for free and install the software on you home computer or laptop.

Follow the link below and read the instructions on how to log on to the MSDNAA web site.  Students who are not in the Computer Technology program may have to wait a few day to be set up.

bulletHoward's Link To MSDNAA

Important dates:

 Academic Calendar

 Task 1  - 10/02/2013
    What you should know:
           a. Creating a database
           b. Creating tables and fields with data types
           c.  Queries:  wild cards, calculated fields
           d. One-To-Many Relationship

 Normalization Research paper due - 10/16/2013

Research Normalization.  Write a minimum of two pages on what Normalization is and how it is used. Please use standard MLA format and include a cover page and bibliography.  You may use graphs or images but please site your resource.  

 No Class Monday  - 10/14/2014

 Design Document Draft  - TBA

 Task 2 - TBA
      What you should know:
           a. Creating tables with a One to Many Relationships
           b. The use of  OLE objects and Yes/No fields in tables and forms
           c.  The use of Hyperlinks and Attachments in tables and forms
           d. Reports - Groups and Totals

Study for Task 3 - Students.csv

Task 3 - TBA
      What you should know:

           a.  Importing data from a file.
           b. Creating a Database with a One to Many Relationship
           c.  Creating a Database with a Many to Many Relationship
           d.   Creating a Database with a One to One Relationships
          
    

 Work on Presentations week in class  - TBA

   Presentations. -  TBA

 Last Class - December 11th

Assignments

bulletNormalization - 10/16/2013

Research Normalization.  Write a minimum of two pages on what Normalization is and how it is used. Please use standard MLA format and include a cover page and bibliography.  You may use graphs or images but please site your resource.  

bulletDesign Documents - Due TBA

How-To Videos

Zipping files Recorded for on-line Students but concepts are the same.

 

 

  

horizontal rule

Final Project Requirements

 
bullet

 1 Design Document per Group

bullet

1 Access Database

bullet

2 or more tables

bullet

Runs from a switchboard

bullet

Has the following menu options

  1.           Reports    ---------------To Reports Sub Menu and returns back to the main menu

  2.           Data Entry --------------To Forms Sub Menu and returns back to the main menu

  3.           Exit --------------------------Will exit Access

Your database must be two or more table that join together, a RELATIONAL database.  Be creative use colors and graphics.  You can use an existing database such as Access that needs to be redesigned.  You may work in groups.  No more than 2 in a group.  This project is to be presented in the last two weeks of class.  Be prepared to explain  your database. Practice connectivity and make sure every thing works before presenting your project. 

 

 

 

CRITERIA

Levels of Performance - Rubric

Novice - D

Apprentice - C

Practitioner - B

Expert - A

Design Document

The document does not adequately explain the project.  Grammar and spelling errors throughout document.

Has some grammar and spelling errors.  Has a cover page and may not have a layout of tables.

Student has all of the elements of the design document.  Has a cover page. Good explanation of the purpose of project and layout of tables.

Student has all of the elements of the design document.  Work is neat, clear and understandable.

Understanding

A relational database

Made an attempt to create a relational database.   Has relationships that donít make sense.

Has relationships between tables but may not be correct.

Student has a broad understanding of relationships and key fields defined. 

Student understands how relational database works and can explain the relationship of their tables.

Table Design

Project does not have at least two tables.  Redundant information in tables.

Project had two or more tables.  May have redundant information or tables not correctly labeled.

Tables are clearly labeled and show a broad understanding of proper table design.

Student understands table design and can explain the flow of tables.

Menu Options

There is no graphics or title on the menu page.  All links do not work.

There may be graphics and title on the main menu.  Some links may not work.

Graphics and title neatly displayed on the main menu.  All links work.

Student may have used nonstandard menu options.  Nice clear layout and all links work.

Presentation

Student does not explain project in detail.  Canít find some of the basic options of the program.

Student can explain most of the major parts of the project.  May have some difficulty navigating the program.

Student explains project clearly.  Student can navigate the program without difficulty.

Student explains project clearly.  Student has implemented special features into the project.

Customer.csv

Products.csv

Make Up Task File

 

 

 

Home | CMPT 125 | CMPT 110 | CMPT 210 | CMPT 260 | Information | Photo Gallery

This site was last updated 10/07/13