CISS 1230 - Microsoft Access

Academic Division: Business, Industry and Technology
Academic Discipline: Computer Information Systems

Assistant Dean: Dr. Vincent Palombo

2 Credit(s)
This course is an introductory course in databases using Microsoft Access for Windows. Through a series of hands-on exercises, the student will create and manage databases. Topics include: creating, saving, formatting, and editing tables; designing reports; creating formulas; working with records; creating forms; writing queries; and establishing table relations. UG

2 Lab Hour(s)

1 Lecture Hour(s);

College Wide Outcomes

College-Wide Learning Outcomes	Assessments - - How it is met & When it is met
Communication – Written
Communication – Speech
Intercultural Knowledge and Competence
Critical Thinking
Information Literacy
Quantitative Literacy

Student Learning Outcomes for Course

Outcomes	Assessments – How it is met & When it is met
1. Create and edit a database, query, form and report.	Skill exam – hands-on practice to master skills. Problem-based project – appropriate application of skills to solve a problem. Weeks 1-4
2. Sort and query databases.	Skill exam – hands-on practice to master skills. Problem-based project – appropriate application of skills to solve a problem. Weeks 5-7
3. Create forms, filters, and reports.	Skill exam – hands-on practice to master skills. Problem-based project – appropriate application of skills to solve a problem. Weeks 7-9
4. Manage tables and validate data.	Skill exam – hands-on practice to master skills. Problem-based project – appropriate application of skills to solve a problem. Weeks 9-11
5. Apply aggregate functions, calculated fields, and parameters to queries.	Skill exam – hands-on practice to master skills. Problem-based project – appropriate application of skills to solve a problem. Weeks 12-13
6. Customize forms and reports.	Skill exam – hands-on practice to master skills. Problem-based project – appropriate application of skills to solve a problem. Weeks 14-15

Standard Grading Scale
93-100 A

90 - 92 A-

87- 89 B+

83 - 86 B

80 -82 B-

77- 79 C+

73 - 76 C

70 -72 C-

67- 69 D+

63 - 66 D

60 -62 D-

00- 59 F

Statement on Diversity
North Central State College believes that every student is a valued and equal member of the community.* Every student brings different experiences to the College, and all are important in enriching academic life and developing greater understanding and appreciation of one another. Therefore, NC State College creates an inclusive culture in which students feel comfortable sharing their experiences. Discrimination and prejudice have no place on the campus, and the College takes any complaint in this regard seriously. Students encountering aspects of the instruction that result in barriers to their sense of being included and respected should contact the instructor, assistant dean, or dean without fear of reprisal.

*Inclusive of race, color, religion, gender, gender identity or expression, national origin (ancestry), military status (past, present or future), disability, age (40 years or older), status as a parent during pregnancy and immediately after the birth of a child, status as a parent of a young child, status as a foster parent, genetic information, or sexual orientation,

Standard NCSC Course Policies
Important information regarding College Procedures and Policies can be found on the syllabus supplement located at this link