INSTRUCTOR – MICHAEL DAVIS

Prerequisites – CISA 320 - Acceptable for Credit: CSU

Units – 1

Schedule – Online Course
Section 22968/22970 August 22nd to October 16th, 2009
Section 22972/22974 October 16th, 2009 to December 11th, 2009

Note:  It is the students responsibility to drop from this course.  Failure to process a drop with the Admissions office can result in a grade of F for the course.  Incompletes cannot be given for online courses.

Text – New Perspectives on Microsoft Office Access 2007 Comprehensive
Adamski and Finnegan, (ISBN 978-1-4239-0589-9), Course Technology

Materials – Microsoft Access 2007 (previous versions of the program will not work for this class)
                    This program is available in the school's computer lab
                    Any storage device capable of storing 256 MB or more of data files

Catalog Description – This course will extend the capabilities of students who have completed a first course in database management. Students design and implement practical database applications, including relational database design to develop programming applications.

Course Objectives – At the end of this course, students will be able to:

• Analyze database tables to choose relationships between multiple tables.

• Design switchboard forms and tables for ease of use by nontechnical users.

• Convert data from various applications into a database structure through export and import features.

• Design and implement multiple table data management systems involving custom data entry screens, reports, and labels.

• Formulate complex queries, and develop forms/subforms and reports based on those queries.

• Use Visual Basic for Applications (VBA) to construct macros and modules for database automation.

Course Structure – this course is a self paced course requiring reading assignments and completion of hands on exercises to be completed utilizing a personal computer.  This course also includes a final exam (content to be determined).  It is the responsibility of the student to be aware of any written or oral instructions that will cause the class to deviate from the content or objectives defined in the class syllabus.

Homework Assignments - This course will cover chapters 5 through 7 and chapter 9 in the textbook.  The homework assignments for this class are the Case Problems that are found at the end of each chapter of the book (they start right after the Review section at the end of each chapter).  There are 4 problems for each chapter.  Follow the link below for a detailed assignment list.

CISA 321 Assignment List

Homework Preparation - There may / will be several printed pages for each homework assignment.  When you turn in each assignment:

• each page must be clearly marked with your name, the chapter number and the step number of the exercise

• pages must be organized and submitted in the order (step order) in which they are completed.

• I do not require that you print in color.

 Failure to follow this format will result in the assignment being returned without a grade

Homework Submission - These assignments can be mailed to me at the school address. They can also be dropped off in the homework bin at the entrance to the library.  You can paste you answers to a Word or Excel document and email them to me.  You can convert them to a pdf file and email them to me.  I will not however, accept the database file, either on a disk or by email.  You must provide me with the prints that are requested  in the assignment.

Grading Composition and Scale

Points                      Grade

234 – 260                    A

208 – 233                    B

182 – 207                    C

156 – 181                    D

155 or less                  F

Student Data files - The data files that are needed for this course can be obtained a number of ways.  Log onto a computer in the lab.  Open Windows Explorer and go to the T drive and find the folder named Davis.  There is a folder under Davis called CISA 320 that will contain the data files.  I will also make these files available as a downloadable zip file.  Finally, there is a CD that normally comes with this book.  I will try to make that available to you as soon as I get it.

Print Screen - At several points, you will asked to take a screen print.  Once you have the screen positioned the way you want it, click on the Print Screen button on your keyboard (usually on the right end of the function key row).  This will save a copy of the screen to the Windows clipboard.  Open a program that will accept images (such as MS Word or MS Excel).  From the program menu select Edit - Paste or CTRL-V from the keyboard to paste the image in.  Print this out and turn it in as directed.

Blackboard - Blackboard will not be used for this course

Instructor Schedule - There will be someone available to assist you in the lab at all times.
                                    Click here to see my schedule.

Return to Main