Print

Syllabus

Database II
IS202

YEAR:

2023-2024

CREDIT HOURS:

1.00

PREREQUISITES:

IS201 Database I with a grade of C or better.

COREQUISITES:

None

COURSE NOTES:

Repeatable once for graduation credit if using a different software package.

CATALOG COURSE DESCRIPTION:

Advanced database skills including importing and exporting; creating advanced queries, forms, reports, data access pages and macros; managing the database.

HutchCC INSTITUTION-WIDE OUTCOMES:

  1. Demonstrate the ability to think critically and make reasonable judgments by acquiring, analyzing, combining, and evaluating information.
  2. Demonstrate the skills necessary to access and manipulate information through various technological and traditional methods.
  3. Demonstrate effective communication through reading, writing, listening, and speaking.
  4. Demonstrate effective interpersonal and collaborative skills.
  5. Demonstrate effective quantitative-reasoning and computational skills.

AREA OR PROGRAM OUTCOMES

  1. Demonstrate professional attitude and work ethic including collaboration and communication skills.
  2. Evaluate current operating systems, application programs, hardware, networking, security and troubleshooting techniques.
  3. Develop and apply specialized computer technology skills, in a hands-on industry setting.
  4. Distinguish and appropriately apply industry terminology and standards in computer technology.
  5. Research and obtain appropriate information, evaluate alternative solutions and make decisions as applied to computer technology.

COURSE OUTCOMES AND COMPETENCIES:

  1. Share Access information with other Office programs.
    1. Create a database using the database wizard and the general templates(H)
    2. Import objects from a database into a separate database (H)
    3. Import a Microsoft Excel file into a database (H)
    4. Export data from a database into an Excel workbook (H)
    5. Export data from a database into an HTML file (H)
    6. Link a database table with an Microsoft Excel file (I)
    7. Publish data from the database to a Microsoft Word file (I)
    8. Merge data from a database into a Microsoft Word file in a form letter (I)
    9. Merge data from a database into a Microsoft Word file for mailing labels (I)
  2. Create data Access pages with hyperlinks, for interactive reporting, for data entry, for data analysis, and for publishing to Web servers.
    1. Create a data access page by using the wizard (H)
    2. Open a data access page in an Internet browser (H)
    3. While viewing data access page in Internet browser, use the navigation bar to move from record to record (H)
    4. While viewing data access page in Internet browser, edit the data (H)
    5. While viewing data access page in Internet browser, sort the data (H)
    6. While viewing data access page in Internet browser, filter the data (H)
    7. While viewing data access page in Internet browser, enter new records (J)
    8. Create hyperlinked fields in a table(J)
    9. Create a data access page using the PivotTable List control
    10. Modify the pivot Web page in Page Design View
    11. Create hyperlinks on data access pages
    12. Identify the steps necessary to publish Web pages
  3. Create advanced queries including Advanced Parameter query, Update query, Make-Table query, Append query, and Delete query.
    1. Create a summary Select query
    2. Create a Select query and use the Top Values feature
    3. Create a Parameter query
    4. Modify the properties of a query by using the Recordset Type property
    5. Create an Update query
    6. Create a Make-Table query
    7. Create an Append query
    8. Create a Delete query
    9. Run an action query
    10. Delete an action query
    11. Modify join properties to find unmatched records
  4. Create advanced forms and reports.
    1. Group controls on a report (H)
    2. Apply the Hide Duplicates property (H)
    3. Apply Conditional Formatting to selected controls on a report (H)
    4. Sort records by selected fields on a report (H)
    5. Apply Summary Options to various sections of a report (H)
    6. Use the Line button on the Toolbox to add various line controls to a report (H)
    7. Use the Rectangle button on the Toolbox to add various rectangle controls to a report (H)
    8. Change the format of a report by using the font/fore color button (H)
    9. Change the format of a report by using the fill/back color button (H)
    10. Change the format of a report by modifying the font characteristics (H)
    11. Create a new AutoFormat for a report (H)
    12. Apply a new AutoFormat style to a report section (H)
    13. Delete an AutoFormat style (H)
    14. Add Check Box controls to a form
    15. Add Toggle Button controls to a form
    16. Modify a form by changing the type of control used
    17. Apply Conditional Formatting to selected controls on a form
    18. Create custom Help by using the ControlTip Text property
    19. Create custom Help by using the Status Bar Text property
    20. Add a Tab control to a form
    21. Use the Chart Wizard to create a chart
    22. Add a chart as a subreport to a main report
    23. Modify a chart in Report Design View
    24. Create a Dialog Box form
    25. Create a Popup form
    26. Create a Switchboard form
    27. Modify a Switchboard form
  5. Manage the database (use Access documentation, object grouping, switchboard features, set passwords, change startup options, encrypt and decrypt a database, analyze performance, and split a database).
    1. Compact and Repair a database (H)
    2. Set the database options to Compact on Close(H)
    3. Use the View buttons to arrange objects in 4 different ways
    4. Right-click an object within Access to open it
    5. Right-click an object within Access to copy it
    6. Right-click an object within Access to delete it
    7. Right-click an object within Access to rename it
    8. Use the Documenter feature to create paper documentation about the database
    9. Create a new Group on the Groups bar
    10. Add objects to a new Group on the Groups bar
    11. Rename a Group on the Groups bar
    12. Convert a database to a different version of Access
    13. Set a password to add security
    14. Nodify Startup Options
    15. Encrypt a database to add security
    16. Decrypt a database
    17. Run the Performance Analyzer to get suggestions on improving the structure of a database
    18. Split a database using the Database Splitter tool
  6. Create macros.
    1. Create a macro in Macro Design View
    2. Save a macro
    3. Run a macro
    4. Modify actions in a macro
    5. Modify arguments in a macro
    6. Create a macro group
    7. Save a macro group
    8. Run a macro in a macro group
    9. Create a Conditional Expression in the Condition column of macro in Macro Design View
    10. Attach a macro to an Event on a form
    11. Create a new toolbar to display available macros

COURSE ASSESSMENT AND EVALUATION:

1. Study guides 2. Exercises 3. Problems 4. Quizzes 5. Examinations 6. Individual/group projects 7. Homework 8. Assignments

ACCOMMODATIONS STATEMENT:

Any student who has a documented disability and wishes to access academic accommodations (per the 1973 Rehabilitation Act and Americans with Disability Act) must contact the HCC Coordinator of Disability Services, at 620-665-3554, or the Student Success Center, Parker Student Union. The student must have appropriate documentation on file before accommodations can be provided.

ACADEMIC HONESTY:

Education requires integrity and respect for HutchCC's institutional values. HutchCC students are required to maintain honesty through a "responsible acquisition, discovery, and application of knowledge" in all academic pursuits. Preserving and upholding academic honesty is the responsibility of Hut chCC students, faculty, administrators and staff.

I. Student Responsibilities

All HutchCC students are required to:

  • Submit all work in all courses without cheating, fabrication, plagiarism, dissimulation, forgery, sabotage, or academic dishonesty as defined below.
  • Provide all academic records such as transcripts and test scores that are free of forgery.
  • Refrain from participating in the academic dishonesty of any person.
  • Use only authorized notes and student aids.
  • Use technology appropriately, including refraining from submitting AI (Artificial Intelligence)-generated work without express written consent from your instructor.
  • Protect the security of passwords/login/privacy/electronic files, and maintain sole individual access for any online course information.

II. Definition of Academic Dishonesty

  • Academic dishonesty is any intentional act, or attempted act, of cheating, fabrication, plagiarism, dissimulation, forgery, or sabotage in academic work.
  • Cheating includes using unauthorized materials of any kind, whether hard copies, online, or electronic, such as unapproved study aids in any academic work, copying another student's work, using an unauthorized "cheat sheet" or device, or purchasing or acquiring an essay online or from another student.
  • Fabrica tion is the invention or falsification of any information or citation in any academic work, such as making up a source, providing an incorrect citation, or misquoting a source.
  • Plagiarism is the representation of words, ideas and other works that are not the student's own as being original to the student. A no n-inclusive list of examples includes work completed by someone else, work generated by an external entity (such as AI), omitting a citation for work used from another source, or borrowing the sequence of ideas, arrangement of material, and/or pattern of thought of work not produced by the student, even though it may be expressed in the student's own words.
  • Dissimulation is the obscuring of a student's own actions with the intention of deceiving others in any academic work, such as fabricating excuses for absences or missed assignments, or feigning attendance.
  • Forgery of academic documents is the unauthorized altering, falsification, misrepresentation, or construction of any academic document, such as changing transcripts, changing grades on papers or on exams which have been returned, forging signatures, manipulating a digital file of academic work, or plagiarizing a translation.
  • Sabotage is any obstruction or attempted obstruction of the academic work of another student, such as impersonating another student, stealing or ruining another student's academic work.
  • Aiding and abetting academic dishonesty is considered as knowingly facilitating any act defined above.
  • Academic honesty violations can also include the omission or falsification of any information on an application for any HutchCC academic program.

III. Sanctions for Academic Dishonesty

Students who violate the Academic Honesty Policy may be subject to academic or administrative consequences.

Instructor Sanctions for Violation:

Students suspected of violating the Academic Honesty Policy may be charged in writing by their instructor and any of the following may apply:

  • Assign Avoiding Plagiarism Bridge Module
  • Receiving written warning that could lead to more severe sanction if a second offense occurs
  • Revising the assignment/work in question for partial credit
  • Voiding work in question without opportunity for make-up
  • Reducing the grade for work in question
  • Lowering the final course grade
  • Failing the work in question

Institutional Sanctions for Violation:

Students charged with academic dishonesty, particularly in instances of repeated violations, may further be subjected to an investigation and any of the following may apply:

  • Instructor recommendation to the Vice President of Academic Affairs (VPAA) to dismiss the student from the course in which the dishonesty occurs
  • Instructor recommendation to the VPAA to dismiss student from the course in which the dishonesty occurs with a grade of 'F." Student will not be allowed to take a 'W' for the course
  • Instructor recommendation to the VPAA that the student be suspended and/or dismissed from the program
  • Student barred from course/program for a set period of time or permanently
  • May be recommended by the instructor (after documented repeated offenses) to the VP AA that the student be placed on probation, suspended and/or dismissed from the institution.

IV. Procedure

  • Instructor will communicate in writing via the student's HutchCC email account and/or LearningZone email account to the student suspected of violating the Academic Honesty Policy.  That communication may include sanction(s). Department Chair will notify the student's academic advisor upon receipt of the Academic Honesty Violation Form.
  • For each violation, the instructor will submit a completed Academic Honesty Violation Form to the Department Chair. Department Chair will notify the student's academic advisor upon receipt of the Academic Honesty Violation form.
  • Should the instructor choose to pursue institutional sanctions, the instruct or shall notify the student in writing via the student's HutchCC email account.  Instructor shall also submit a completed Academic Honesty Violation Form and all prior completed forms regarding said student to the Department Chair and the office of the VPAA with recommendation to proceed with specific Institutional Sanctions. Department Chair will notify the student's academic advisor upon receipt of the Academic Honesty Violation Form.
  • The decision of the VPAA on Institutional Sanction is final. The VPAA will notify the student's academic advisor of any institutional sanctions.

V. Due Process Rights

Students charged with violations of academic honesty have the right of appeal and are assured of due process through the Academic Honesty Appeal process.

Academic Honesty Appeal Process

I. Due Process Rights: Students charged with violations of academic honesty have the right of appeal and are assured of due process through the Academic Honesty Appeal process.

  • If an instructor has recommended course or program dismissal, the student may continue in coursework (provi ding there are no threatening or security behavioral issues) until appeal processes are concluded. However, if an issue has been documented at a partnership location (e.g., clinical sites, secondary institutions, correctional or military facilities), then the student is no longer eligible to continue participation in internships, apprenticeships, and/or clinical-based practice. For clinical sites, this sanction is immediate.

II. Process

If the student disagrees with the charge of a violation of academic honesty, the student has the right to due process as described in the Academic Honesty Appeal process below:

  • If the matter is not resolved upon communicating with the instructor about the violation, the student shall, within five business days of the issuance of the written notice of violation, submit a completed Academic Honesty Appeal Form and supporting documentation to the appropriate department chairperson to initiate an Academic Honesty Appeal.
  • Within two business days of receiving the student's completed Academic Honesty Appeal Form, the Department Chair and VPAA will review and the VPAA will render a decision.
  • Within two business days, a response will be sent to the student's HutchCC email address. The VPAA's decision is final.

INCOMPLETE GRADE:

Instructors may give a student a grade of Incomplete (I) under the following conditions:

  1. The student must initiate the request prior to the time final course grades are submitted to Records.
  2. The request must be made because of an emergency, illness or otherwise unavoidable life-event.
  3. The instructor must agree to the request before a grade of Incomplete can be submitted.
  4. A written contract between the instructor and student, signed by both, will document the work required and date needed to complete course work.
  5. If a student does not complete the course requirements within the time frame established by the instructor, a grade of "F" will be recorded on the student's transcript at the end of the next semester.

HLC ACCREDITATION:

Hutchinson Community College is accredited by the Higher Learning Commission (HLC). The Higher Learning Commission is one of six regional institutional accreditors recognized by the US Department of Education and the Council on Higher Education Accreditation (CHEA).