OIT-187-Milliken-Fall2008

OIT 187 - Beginning Access 2007

Fall 2008

Instructor:	Carol Milliken
Phone:	Office Phone: 269-965-3931, Ext. 2519
Office Hours: Online:	By appointment email: millikenc@kellogg.edu It is best to contact me via the course discussion board or email. I will respond to email within two working days. If you use Access HELP in your subject line, I will give your email top priority.
Course Prerequisites:	Before enrolling in this course, the student should be familiar with basic touch typing fundamentals and have some experience working in a windows environment with a mouse. You will need access to a computer with Access 2007 and an Internet Browser.
Textbook	Required: Shelly Cashman Microsoft Access 2007 Comprehensive ISBN: 1428367144 You will also need one high-density, 3 1/2 inch formatted disk or a USB flash drive is preferred. The book may be ordered on line at http://www.coursedirect.com or through the Kellogg Community College bookstore at http://www.kellogg.edu
Online Course Features and Requirements	Number of tests: 2 of which 1 must be proctored. Required on campus sessions: 0 Special labs or practicum: 0 Number of assignments: Ten assignments which consist of 3-4 problems Estimated time per week: 2-3 hours Group interaction required: None Scheduled activities or self paced: Self paced Requirements: Students must have access to the following: Equipment: You will need a computer that is able to access and interact with the Web. For best results, a Pentium or PowerMac with a 56 Kbps or faster modem and 256 MB or more of RAM should be considered the minimal system. Software: You will need one of the following Internet browsers: Microsoft Internet Explorer 6 or higher; Firefox; Mac users may use Safari or Firefox. Internet connection: Home users need Internet access through an Internet Service Provider (ISP) that offers a reliable connection to the Internet. Other requirements: Access 2007
Course Site:	http://bb.kellogg.edu
Course Description	This course introduces students to the basic features of Access and presents introductory information about the Microsoft Office Specialist certification exam program. Major topics will include: creating a database using design and datasheet views; querying a database using the select query window; maintaining a database using the design and update features of Access; and publishing to the Internet using data access pages.
Course Goal	Upon completion of this course the successful student will have (1) gained the skills necessary to start preparing for the Microsoft Office Specialist Core Access 2007 Examination and (2) learned how the Access 2007 skills acquired can be used in the business world.
Objectives	Describe databases and database management systems Describe the speech recognition capabilities of Access Start Access Describe the features of the Access desktop Create a database Create a table and define the fields in a table Open a table Add records to a table Close a table Close a database and quit Access Open a database Print the contents of a table Use a form to view data Create a custom report Use the Access Help system to answer your questions Design a database to eliminate redundancy Create a new query Use a query to display all records and all fields Run a query Print the answer to a query Close and clear a query Use a query to display selected fields Use text data and wildcards in criteria in a query Use numeric data and comparison operators in criteria Use compound criteria Sort the answer to a query Join tables in a query and restrict the records in a join Use calculated fields in a query Calculate statistics in a query Save a query and use a saved query Add records to a table Locate records Filter records Change the contents of records in a table Delete records from a table Restructure a table Change field characteristics Add a field Save the changes to the structure Update the contents of a single field Make changes to groups of records Delete groups of records Create validation rules Update a table with validation rules Specify referential integrity Use subdatasheets Order records Create single-field and multiple-field indexes Create a data access page
Grading	Total Points Available=860 Assignment 1=20 Points Assignment 2=30 Points Assignment 3=95 Points Assignment 4=30 Points Assignment 5=35 Points Assignment 6=165 Points Assignment 7=10 Points Assignment 8=30 Points Assignment 9=125 Points Assignment 10=30 Points Theory Exam=100 Points Application Exam=200 Points Your Final Application Exam must be taken at a proctored location agreed upon with your instructor. Details about the location and date of this exam will be determined by the instructor and student. Grading Scale for Total Points Earned: 870-818=A 817-783=A- 782-748=B+ 747-730=B 729-696=B- 695-670=C+ 669-644=C 643-609=C- 608-583=D+ 582-557=D 556-515=D- 514 and Below=F

Computer Access at KCC It is assumed that students enrolled in this course have at their disposal appropriate equipment and software to complete the course work and communicate with other students. If there are problems with your equipment and/or software, it is possible to come the KCC's Campus and use the open computer lab in the Learning Resource Center. See KCC's web site for campus maps and lab times.

Online Submitting Materials Students will be expected to use e-mail attachments and the blackboard site for this class to submit materials.

ADA Statement Kellogg Community College does not discriminate in the admission or treatment of students on the basis of disability. KCC is committed to compliance with the American Disabilities Act and Section 504 of the Rehabilitation Act.

Computer Access at KCC	It is assumed that students enrolled in this course have at their disposal appropriate equipment and software to complete the course work and communicate with other students. If there are problems with your equipment and/or software, it is possible to come the KCC's Campus and use the open computer lab in the Learning Resource Center. See KCC's web site for campus maps and lab times.
Online Submitting Materials	Students will be expected to use e-mail attachments and the blackboard site for this class to submit materials.
ADA Statement	Kellogg Community College does not discriminate in the admission or treatment of students on the basis of disability. KCC is committed to compliance with the American Disabilities Act and Section 504 of the Rehabilitation Act.