MASTER SYLLABUS

2020-2021

A.	Academic Division: Business, Industry, and Technology

B.	Discipline: Computer Information Systems

C.	Course Number and Title: CISS 1230 Microsoft Access

D.	Course Coordinator: Carmen Morrison

Assistant Dean: Toni Johnson, PhD

Instructor Information:

Name:	Click here to enter text.

Office Location:	Click here to enter text.

Office Hours:	Click here to enter text.

Phone Number:	Click here to enter text.

E-Mail Address	Click here to enter text.

E.	Credit Hours: 2

Lecture: 1 hour

Laboratory: 2 hours

F.	Prerequisites: Pass Computer Literacy Assessment and Keyboarding Assessment

G.	Syllabus Effective Date: Fall 2020

H.	Textbook(s) Title:

GO! With Microsoft Access 2016 Comprehensive, Packaged with MyITLab & eText

Author	Gaskin, Graviett

Year	2016

Edition:	1st

ISBN: 9780134572079

Workbook(s) and/or Lab Manual: None

J.	Course Description: 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.

K.	College-Wide Learning 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

L.	Course Outcomes and Assessment Methods:

Upon successful completion of this course, the student shall:

Outcomes	Assessments – How it is met & When it is met
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
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
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
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
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
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

M.	Topical Timeline (Subject to Change):

Create a Table and Define Fields	Weeks 1-4

Add and Change the Structure of Tables	Weeks 1-4

Create and Use Queries, Forms, and Reports	Weeks 1-4

Save, Close, and Change the Properties of a Database	Weeks 1-4

Create a Database Using a Template	Weeks 1-4

Organize Database Objects in the Navigation Pane	Weeks 1-4

Print a Report and Table	Weeks 1-4

Create Table Relationships	Weeks 5-7

Sort Records in a Table	Weeks 5-7

Create a Query in Design View and from an Existing Query	Weeks 5-7

Sort Query Results	Weeks 5-7

Specify Criteria in a Query	Weeks 5-7

Create a Query Based on More Than One Table	Weeks 5-7

Use Wildcards and Calculated Fields in a Query	Weeks 5-7

Calculate Statistics and Group Data in a Query	Weeks 5-7

Create Crosstab and Parameter Queries	Weeks 5-7

Create and Use a Form to Add and Delete Records	Weeks 7-9

Create a Form by Using the Form Wizard	Weeks 7-9

Modify a Form in Design View and in Layout View	Weeks 7-9

Filter Records	Weeks 7-9

Create Reports by Using the Report Tool and Report Wizard	Weeks 7-9

Modify the Design of a Report	Weeks 7-9

Keep Grouped Data Together in a Printed Report	Weeks 7-9

Manage and Modify Existing Tables	Weeks 9-11

Change Data types	Weeks 9-11

Attach Files to Records	Weeks 9-11

Create a Lookup Field	Weeks 9-11

Set Field Properties	Weeks 9-11

Create Data Validation Rules and Validation Text	Weeks 9-11

Create Calculated Fields in a Query	Weeks 12-13

Use Aggregate Functions in a Query	Weeks 12-13

Create a Crosstab Query	Weeks 12-13

Find Duplicate and Unmatched Records	Weeks 12-13

Create a Parameter Query	Weeks 12-13

Create a Make Table Query	Weeks 12-13

Create an Append Query	Weeks 12-13

Create a Delete Query	Weeks 12-13

Create an Update Query	Weeks 12-13

Modify the Join Type	Weeks 12-13

Create a Form in Design View	Weeks 14-15

Change and Add Controls	Weeks 14-15

Format a Form	Weeks 14-15

Make a Form User Friendly	Weeks 14-15

Create a Report Based on a Query Using a Wizard	Weeks 14-15

Create a Report in Design View	Weeks 14-15

Add Controls to a Report	Weeks 14-15

Group, Sort, and Total Records in Design View	Weeks 14-15

N.	Course Assignments:

Practice labs to develop mastery of skills

Problem-based Projects to apply skills to solve problems

O.	Recommended Grading Scale:

NUMERIC	GRADE	POINTS	DEFINITION
93–100	A	4.00	Superior
90–92	A-	3.67	Superior
87–89	B+	3.33	Above Average
83–86	B	3.00	Above Average
80–82	B-	2.67	Above Average
77–79	C+	2.33	Average
73–76	C	2.00	Average
70-72	C-	1.67	Below Average
67–69	D+	1.33	Below Average
63-66	D	1.00	Below Average
60-62	D-	0.67	Poor
00-59	F	0.00	Failure

P.	Grading and Testing Guidelines:

Click here to enter text.

Q.	Examination Policy:

Click here to enter text.

R.	Class Attendance and Homework Make-Up Policy:

Click here to enter text.

S.	Classroom Expectations:

Click here to enter text.

T.	College Procedures/Policies:

Important information regarding College Procedures and Policies can be found on the syllabus supplement located at

http://catalog.ncstatecollege.edu/mime/download.pdf?catoid=5&ftype=2&foid=3