Office of Continuing Education & Workforce Development Phone : (808) 455-0477, Fax : (808) 453-6730

Business Computer

Microsoft Office Access 2007 - BT2150

Completion of this course allows students to move from easy step-by-step learning to validating skills through case-based projects. It facilitates self-paced accelerated and traditional learning.  Throughout the course, students will build solid foundations using Microsoft Access 2007.  Students will learn to create tables and relationships to maintain data in access tables.  During the course, the students will also learn to create queries, forms and reports as well as to summarize data and calculate in forms and reports.  Recommended Prerequisite: Windows XP Professional (BT2110) or prior experience. Tuition: $155

Course Duration:
18 Hours 1.20 Semester Hours

Course # Date Day Time Location Instructor
BT2150
TBA
TU/WE/TH 6:00PM-9:00PM LCC BE226 Staff
Course Type:
Personal/Community Development

Standard Occupational Code (SOC):
Not Applicable
Upon successful completion of this course, students will be able to:
  1. Operate essential elements of Microsoft Office Access 2007: Create, Save, and Close a Database; Add, Delete, Find, Sort, and Filter Records in multiple views; Help.
  2. Creating Tables and Relationships: Use Design View; Format Fields.
  3. Develop Queries, Forms, and Reports: Query Wizard; Design View; Perform Calculations; and, Create, Customize, and Manage Reports.
  4. Compile Data in Table and/or Reports for Export into Microsoft Word or Excel.
  5. As Database Manager, assess expectations of audience and apply appropriate formatting; and, decide on suitable file type to save.
  6. Demonstrate effective file management skills: Save, Rename, Delete, and Move Access Database While Maintaining Relationships.
Learning Outcomes Assessments Used:

Participant Evaluations (Indirect Method)
Instructor Evaluation(s) (Indirect Method)

Completion:
Yes: 100% No: 0%

Reason for Non-Completion:
N/A
Student Reported Learning Objective Met:

Not
Applicable

0%

Strongly
Disagree

0%


Disagree

0%


Indifferent

0%


Agree

0%

Strongly
Agree

0%

Attendance Policy

Participants are expected to attend all class sessions. Sign-in sheets are completed at every class session. Participants must attend all classes in order to satisfactorily complete the course. For every fifteen (15) hours of instruction, one hour of instruction can be missed. Arriving more than 15 minutes late at the start of a class will be documented as a tardy or leaving more than 15 minutes early at the end of a class will be documented as an early departure.

Standards of Progress
Attendance, completion of assignments, quiz/exam scores, and satisfactory performance of all skills/tasks contribute to the overall grade. Possible grades include:

(CR) is used to indicate passing with a “C” or higher for non-credit courses. All assignments completed with a score of 70% or higher, a score of 70% or higher on each quiz/exam, and all skills performed satisfactorily.

(NC) is used to indicate not passing with a “C” or higher for non-credit courses. Participants earning a grade of “NC” may repeat a course once. Additional repeats may be allowed after discussion with a Program Coordinator, and participants may be required to repeat the entire course at an additional expense. Participants may not progress to the next higher level course until a “CR” grade is earned.

(I) is used to indicate that the participant has yet to complete one or more requirements by the scheduled end date of a course. Participants will be given an additional opportunity to successfully complete the requirements after instructors provide counseling/remediation. An additional fee may be required for remedial instruction beyond two (2) attempts. Participants that are unsuccessful after four (4) attempts shall be assigned a grade of “NC”. Completion of course requirements must be accomplished during the next offering of the program/course or the grade will be converted as “NC”.

Student Reported Satisfaction with Course
Yes: 100%
No: 0%
No Response: N/A
Developing

8.27.2010

The University of Hawaii is an equal opportunity/affirmative action institution.
© 2003 - 2010 Leeward Community College. All Rights Reserved.
Meebo Chat Link