OAT 251 Access

This course covers the fundamental concepts of word processing skills necessary to be successful with an organization. Students build technical knowledge and reinforce problem-solving abilities through project-based learning.

Credits

3

Prerequisite

Prerequisite: OAT 152 or OAT 157 or DAT 101

See Course Syllabus

Course Number and Title:

OAT 251 Access

Campus Location

  • Dover
  • Georgetown
  • Stanton
  • Wilmington

Effective Date

2022-51

Prerequisites

Prerequisite: OAT 152 or OAT 157 or DAT 101

Course Credits and Hours

3 credit(s)

2 lecture hours/week

2 lab hours/week

Course Description

This course covers the fundamental concepts of word processing skills necessary to be successful with an organization. Students build technical knowledge and reinforce problem-solving abilities through project-based learning.

Additional Materials

None

Required Text(s)

Obtain current textbook information by viewing the campus bookstore - https://www.dtcc.edu/bookstores online or visit a campus bookstore. Check your course schedule for the course number and section.

Disclaimer

None

Core Course Performance Objectives (CCPOs)

  1. Plan, design, and prepare documents.  (CCC 1, 2; PGC OAT 1, 2, 3; GBT 1, 2, 4, 5, 6)
  2. Use appropriate software for completion of projects. (CCC 2, 4; PGC OAT 1, GBT 1, 2, 4, 5, 6)
  3. Develop critical thinking and problem solving skills. (CCC 1, 2; PGC OAT 3; GBT 1, 2, 3, 4, 5, 6) 
  4. Identify content and organization of application software. (CCC 1, 2; PGC OAT PGC 1, 3; GBT PGC 1) 
  5. Display file management skills.  (CCC 1, 2, 4; PGC OAT 3; GBT 1)

See Core Curriculum Competencies and Program Graduate Competencies at the end of the syllabus. CCPOs are linked to every competency they develop.

Measurable Performance Objectives (MPOs)

Upon completion of this course, the student will:

  1. Plan, design, and prepare documents.
    1. Create and save databases.
    2. Navigate databases.
    3. Select and edit text.
    4. Create fields, records, tables, and queries.
    5. Move and copy text, field, and records.
    6. Design, modify, and print forms and reports.
    7.  Apply page numbering
    8. Create labels.
    9. Create text boxes.
    10. Designate data types.
    11.  Move and resize fields.
    12. Create lookup columns.
    13. Use input masks.
    14. Create conditional formats.
    15.  Prevent duplicate entries.
    16. Create default values.
    17. Define relationships.
  2. Use appropriate software for completion of projects.
    1. Integrate database with alternative data sources.
    2. Create queries.
    3. Create mailing labels.
    4. Create subsets of data which meet specific criteria.
    5. Sort data.
  3. Develop critical thinking and problem solving skills.
    1. Relate and devise solutions to real-world business situations.
    2. Use case-study scenarios to develop business databases.
    3. Create and modify mailing labels.
    4. Develop forms.
    5. Create and format reports.
  4. Identify content and organization of application software.
    1. Manipulate multiple applications simultaneously.
    2. Import and export files.
    3. Link multiple databases.
    4. Convert a database from a previous version of Access.
    5. Use a browser to interact with the database.
  5. Display file management skills.
    1.  Create files and folders.
    2. Manipulate files, folders, and paths.

Evaluation Criteria/Policies

The grade will be determined using the Delaware Tech grading system:

90-100 = A
80-89 = B
70-79 = C
0-69 = F
Students should refer to the Catalog/Student Handbook for information on the Academic Standing Policy, the Academic Integrity Policy, Student Rights and Responsibilities, and other policies relevant to their academic progress.

Final Course Grade

Calculated using the following weighted average

Evaluation Measure

Percentage of final grade

Summative: Concept Exams (equally weighted)

15%

Summative: Industry Recognized Certification Exam

10%

Formative: Pre-Check & Tutorials

10%

Formative: Assignment Chapter Projects and Skill Checks

35%

Summative: Unit Project Evaluations

30%

TOTAL

100%

Program Graduate Competencies (PGCs are the competencies every graduate will develop specific to his or her major)

OATAASOAT

  1. Produce the documents necessary for a functioning business office.
  2. Demonstrate accurate and efficient keyboarding skills.
  3. Integrate office-related skills to function in a professional manner within the workplace.
  4. Use diverse research methods and information sources to complete a variety of business documents.

 

BSSAASGBT

  1. Integrate professional, ethical, and legal standards into business practice.
  2. Employ the various theories of management and marketing in a business.
  3. Apply the principles of human resource management to organizations.
  4. Evaluate the actions taken to acquire and retain customers.
  5. Measure and track financial performance of an organization.
  6. Analyze and apply the strategic management process to organizations.

Core Curriculum Competencies (CCCs are the competencies every graduate will develop)

  1. Apply clear and effective communication skills.
  2. Use critical thinking to solve problems.
  3. Collaborate to achieve a common goal.
  4. Demonstrate professional and ethical conduct.
  5. Use information literacy for effective vocational and/or academic research.
  6. Apply quantitative reasoning and/or scientific inquiry to solve practical problems.

Students in Need of Accommodations Due to a Disability

We value all individuals and provide an inclusive environment that fosters equity and student success. The College is committed to providing reasonable accommodations for students with disabilities. Students are encouraged to schedule an appointment with the campus Disabilities Support Counselor to request an accommodation needed due to a disability. The College's policy on accommodations for persons with disabilities can be found in the College's Guide to Requesting Academic Accommodations and/or Auxiliary Aids Students may also access the Guide and contact information for Disabilities Support Counselors through the Student Resources web page under Disabilities Support Services, or visit the campus Advising Center.

Minimum Technology Requirements

Minimum technology requirements for online, hybrid, video conferencing and web conferencing courses.