BOS 182 Database Software Applications
Course Overview - Fall, 2013

Instructor: Kathie Gourlay
Telephone: 313-268-6537
Message E-mail gourlay@wccnet.edu
Mailbox: BE 200 (734-677-5431)
Home Page: http://courses.wccnet.edu/~gourlay
Office hours:By appointment.

Course Description

• creating databases,
• creating and customizing tables
• creating, formatting and enhancing forms,
• creating, formatting and enhancing reports,
• querying and maintaining databases, and
• filtering data.

Prerequisites

Students should be familiar with Windows and have a keyboarding speed of at least 25 wpm

Course Objectives

• Enter and edit tables, queries, and forms,
• Design table relationships using accepted design principles,
• Create select, summary, crosstab, and action queries,
• Create expressions for summarizing data within queries, forms, and reports,
• Create and modify data entry forms which include combo boxes, subforms, command buttons, and other controls,
• Create and modify professional-looking reports, including grouping and mailing labels,
• Create and modify a basic switchboard to navigate a database using simple macros,
• Design and develop an original database application for personal or business use, and
• Demonstrate knowledge of database management concepts and terminology.

Required texts and supplies

1. Text: Microsoft Access 2013: In Practice - Complete by Annette Easton and Randy Nordell, ISBN 978-0078119367, includes Access textbook with SIMNET Code.
   This book may be obtained from: Barnes and Noble, Student Center Bldg., Washtenaw Community College, 973-3594

2. Optional: You will have files that you want to keep for the length of the semester. You may want to purchase a small flash drive for this purpose.

Grading Policy

Assignment Due Dates and Late Exercises

Late Tests - If you are absent the day of a test, you must make arrangements with the instructor to take it before the next class. This is because the tests will be handed back and gone over during the next class period. The four test days are shown on the syllabus.

Late exercises - Exercises that are turned in more than one week after they are due may be marked down 50%. If you are absent, please contact another student or look on Blackboard to see what in-class exercises or homework assignments you missed. There may be some in-class group assignments which cannot be made up.

Your final letter grade will be determined as follows. While class is in progress, you can see your "percent grade in-progress" in Blackboard.

Academic Dishonesty

Although you are encouraged to help each other, the work you hand in must be your own. If you are caught cheating or are guilty of plagiarism, you may be sanctioned as described according to the Board of Trustees Policy 4095 regarding academic dishonesty, which is included on the W.C.C. website.

Miscellaneous:

• You may use the computers in the Computer Commons (734-973-3420) on the 2^nd floor of the library in the GM building to do your computer assignments. There are tutors there to help you. See their schedule at www4.wccnet.edu/resources/computerresources/computerlabs/commons/
• Learning Support Services in LA 104 (734-973-3342) has tutors who can give you non-computer study help.
• You may also make an appointment to meet with me outside of class for extra help.

No eating or drinking near any computer. The instructor will show you where you may store your food and drink.

Attendance is important as many of the classes build on work from the previous class and some group assignments cannot be done late.

Two hours spent on homework for each hour of a college class is not unusual.

In compliance with the Americans with Disabilities Act all qualified students are entitled to reasonable accommodations. Please notify the instructor if any accommodations are needed or go to LA 104 for support.