Course Descriptions & Syllabi

Course Descriptions & Syllabi

Search Course IDs and descriptions for:

Find complete words only

Note: some or all of the courses in the subjects marked as "Transfer" can be used towards a transfer degree: Associate of Science and Arts or Associate of Engineering Science at DACC. Transferability for specific institutions and majors varies. Consult a counselor for this information.

Areas of Study | | BOFF226 syllabus




COURSE NUMBER: BOFF226
COURSE TITLE:Database Applications
DIVISION:Business
IAI CODE(S):
SEMESTER CREDIT HOURS:2
CONTACT HOURS:45
STUDENT ENGAGEMENT HOURS:90
DELIVERY MODE:Hybrid, Online

COURSE DESCRIPTION:
An introductory course in database concepts including the skills to create tables; add, edit, and delete records. The creation of forms, queries, and reports will be introduced.

PREREQUISITES:
BOFF130

NOTES:

STUDENT LEARNING OUTCOMES:
Upon completion of this course, students will be able to:
  • Identify the various elements of a database and database applications.
  • Create professional databases to record and share data.
  • Compile databases with appropriate tables, queries and relationships.
  • Develop appropriate reports and forms within the database.
  • Develop a professional database for a mock company.

TOPICAL OUTLINE:
  1. Create and maintain tables: Enter data, edit records, and delete records
  2. Create relationships between tables: Print relationships and display sub data sheets
  3. Create queries: Use wildcards in a query, create queries from multiple tables, add calculated fields to a query, create crosstab queries, create find duplicate queries, and create unmatched queries.
  4. Create and use forms: create auto forms, enter and edit data using a form, create and customize a form, add fields to a form, add a form header and label, create a split form
  5. Create and print records: Create and customize a report, modify control objects, group and sort records, create and print mailing labels
  6. Exporting data: To Excel, to Word, Merging data with a Word document, to a PDF and XPS file
  7. Filter data
  8. Protect and repair databases

TEXTBOOK / SPECIAL MATERIALS:
See bookstore website for current book(s) at https://www.dacc.edu/bookstore

EVALUATION:
A point system will be used to determine student grades. Point values will be assigned to all homework, tests, projects, and exams. The following percentages will be used in determining grades:

100-90% = A

  89-80% = B

  79-70% = C

  69-60% = D

  59-00% = F


BIBLIOGRAPHY:

STUDENT CONDUCT CODE:
Membership in the DACC community brings both rights and responsibility. As a student at DACC, you are expected to exhibit conduct compatible with the educational mission of the College. Academic dishonesty, including but not limited to, cheating and plagiarism, is not tolerated. A DACC student is also required to abide by the acceptable use policies of copyright and peer-to-peer file sharing. It is the student’s responsibility to become familiar with and adhere to the Student Code of Conduct as contained in the DACC Student Handbook. The Student Handbook is available in the Information Office in Vermilion Hall and online at: https://www.dacc.edu/student-handbook

DISABILITY SERVICES:
Any student who feels s/he may need an accommodation based on the impact of a disability should contact the Testing & Academic Services Center at 217-443-8708 (TTY 217-443-8701) or stop by Cannon Hall Room 103. Please speak with your instructor privately to discuss your specific accommodation needs in this course.

REVISION:
Spring 2019

Upcoming Events