| 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 : |
<?
// /JimMartinson/CST1600/Syllabus.php
$TRACK = "<b>".basename(__FILE__).'</b> <span class="pv_fl">('.__FILE__.")</span>\n<ol>\n";
ini_set('include_path',ini_get('include_path').PATH_SEPARATOR.$_SERVER['DOCUMENT_ROOT']."/"); // Add the DOCUMENT_ROOT to the include_path.
$thisFile=__FILE__; $thisLine=__LINE__; include('application.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('Course/courseInfo.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('classInfo.phpinc');
$title = "Syllabus";
$headTitle = '_CST_ - '.$courseNumber.' '.$courseTitle.' - '.$title;
$pageTitle = $courseNumber.' '.$courseTitle.'<br>'.$title;
$pageMenu = 'Course/courseMenu.phpinc';
$thisFile = __FILE__; $thisLine=__LINE__; include('common/pageHeader.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('Login/authenticate.phpinc');
$sectionTitle = $courseNumber.' '.$courseTitle.' - '.$title;
$thisFile = __FILE__; $thisLine=__LINE__; include('common/sectionHeader.phpinc');
?>
<p>
<fieldset><legend>Description</legend><span class="normal">
This course is designed to give students the basic skills they need to work with Access databases.
Students are given the skills they need to design, create, modify, and use Access databases.
Course content addresses topics such as the use of tables, queries, forms, reports, and advanced topics.
This is done through the use of textbook study and hands-on structured labs assigned by the instructor.
<!-- The course is presented in a personalized manner with the permission and guidance of the Instructor. -->
The course can optionally be presented in a personalized manner with the permission and guidance of the Instructor.
<br />
(Prerequisites: None) (3 Credits) (2 Lecture, 1 Lab, 0 On the Job Training.)
</span></fieldset>
<fieldset><legend>Objectives</legend><span class="normal">
<ol class="obj">
<!-- Profiles -->
<li>Describe yourself, your experience with computer systems, and your future goals.</li>
<li>Describe why you took this class and your expected class outcomes.</li>
<br />
<!-- Chapter 1-1 3 -->
<li>Open and close objects in a database.</li>
<li>Design a table.</li>
<li>Determine fields and assign data types in a table.</li>
<li>Enter data in a table.</li>
<li>Open, save, print, and close a table.</li>
<li>Add and delete records in a table.</li>
<br />
<!-- Chapter 1-2 9 -->
<li>Create a database table with a primary key and a foreign key.</li>
<li>Create a one-to-many relationship between tables.</li>
<br />
<!-- Chapter 1-3 11 -->
<li>Modify a table by adding, deleting, or moving fields.</li>
<li>Assign a default value and validate a field entry.</li>
<li>Insert a Total row.</li>
<li>Use the Input Mask Wizard and the Lookup Wizard.</li>
<li>Complete a spelling check on data in a table.</li>
<li>Find specific records in a table.</li>
<li>Find specific data in a table and replace with other data.</li>
<li>Backup a database.</li>
<li>Compact and repair a database.</li>
<li>Use the Help feature.</li>
<br />
<!-- Chapter 1-4 21 -->
<li>Design a query to extract specific data from a table.</li>
<li>Use the Simple Query Wizard to extract specific data from a table.</li>
<li>Modify a query.</li>
<li>Design queries with Or and And criteria.</li>
<li>Create a calculated field.</li>
<li>Use aggregate functions in queries.</li>
<li>Create crosstab, duplicate, and unmatched queries.</li>
<br />
<!-- Chapter 1-5 28 -->
<li>Create a form using the Form button.</li>
<li>Change views in a form.</li>
<li>Print and navigate a form.</li>
<li>Add records to and delete records from a form.</li>
<li>Customize a form with options at the Form Layout Tools Format tab.</li>
<li>Create a form using the Simple Form button.</li>
<li>Create a form using the Multiple Items button.</li>
<li>Create a form using the Form Wizard.</li>
<br />
<!-- Chapter 1-6 36 -->
<li>Create a report using the Report button.</li>
<li>display a report in Print Preview.</li>
<li>Create a report with a query.</li>
<li>Format and customize a report.</li>
<li>Group and sort records in a report.</li>
<li>Create a report using the Report Wizard.</li>
<li>Create mailing labels using the Label Wizard.</li>
<br />
<!-- Chapter 1-7 43 -->
<li>Filter data by selection and by form.</li>
<li>Remove a filter.</li>
<li>Summarize and analyze data in PivotTable view.</li>
<li>Summarize and analyze data in a PivotTable form.</li>
<li>Summarize and analyze data in PivotChart view.</li>
<li>View and customize document properties.</li>
<li>View object dependencies.</li>
<br />
<!-- Chapter 1-8 50 -->
<li>Export Access data to Excel.</li>
<li>Export Access data to Word.</li>
<li>Merge Access data with a Word document.</li>
<li>Import data to a new table.</li>
<li>Link data to a new table.</li>
<li>Use the Office Clipboard.</li>
<li>Save a database in an earlier version of Access.</li>
<br />
<!-- Chapter 2-1 57 -->
<li>Design the structure of tables to optimize efficiency and accuracy of data.</li>
<li>Select the appropriate field data type based on analysis of source data.</li>
<li>Add captions to fields for descriptive purposes.</li>
<li>Disallow blank field values.</li>
<li>Allow or disallow zero-length strings in a field.</li>
<li>Create a custom format for text, number, and date fields.</li>
<li>Create a custom input mask.</li>
<li>Define rich text formatting for a memo field.</li>
<li>Store history of changes to a memo field.</li>
<li>Define and use an attachment field with multiple attachments.</li>
<br />
<!-- Chapter 2-2 67 -->
<li>Design relationships between tables including one-to-many, one-to-one, and many-to-many relationships.</li>
<li>Edit relationship options, including specifying the join type.</li>
<li>Define a table with multiple-field primary key.</li>
<li>Create a lookup field to populate records with data from another table.</li>
<li>Modify a lookup field's properties.</li>
<li>Create a field that allows multiple values.</li>
<li>Create single-field and multiple-field indexes.</li>
<li>Define what is meant by normalization.</li>
<li>Determine if a table is in first, second, and third normal form.</li>
<br />
<!-- Chapter 2-3 76 -->
<li>Save a filter as a query.</li>
<li>Create and run a parameter query to prompt for criteria.</li>
<li>Add and remove tables to and from a query.</li>
<li>Create an inner join, left join, and right join to modify query results.</li>
<li>Create a self-join to match two fields in the same table.</li>
<li>Create a query that includes a subquery.</li>
<li>Assign an alias to a table and a field name.</li>
<li>Select records using a multivalued field in a query.</li>
<li>Create a new table using a make-table query.</li>
<li>remove records from a table using a delete query.</li>
<li>Add records to the end of an existing table using an append query.</li>
<li>modify record using an update query.</li>
<br />
<!-- Chapter 2-4 88 -->
<li>Create a custom form in Design view using all three form sections.</li>
<li>Add fields individually and as a group.</li>
<li>Move, size, and format control objects.</li>
<li>Change the tab order of fields.</li>
<li>Add and format a calculation to a custom form.</li>
<li>Group and ungroup multiple controls.</li>
<li>Adjust the alignment and spacing of controls.</li>
<li>Add graphics to a form.</li>
<li>Anchor a control to a position in the form.</li>
<li>Create a datasheet form.</li>
<li>Modify form properties to restrict actions allowed in records.</li>
<li>Sort records in a form and locate a record using a wildcard character.</li>
<br />
<!-- Chapter 2-5 100 -->
<li>Create a custom report in Design view using all five report sections.</li>
<li>Add bound and unbound control object to a report.</li>
<li>Move, size, format, and align control objects.</li>
<li>Apply an AutoFormat to a report.</li>
<li>Insert a subreport into a report.</li>
<li>Add page numbering, date and time controls.</li>
<li>Add graphics to a report.</li>
<li>Group records and add aggregate functions and grand totals to a group.</li>
<li>Modify section or group properties to control print options.</li>
<li>Create and modify charts in a report.</li>
<br />
<!-- Chapter 2-6 110 -->
<li>Create a new database using a template.</li>
<li>Create a new table using a table template.</li>
<li>Create a table by copying the structure of another table.</li>
<li>Evaluate a table using the Table Analyzer Wizard.</li>
<li>Evaluate a database using the Performance Analyzer.</li>
<li>Split a database.</li>
<li>Print documentation about a database using the Database Documenter.</li>
<li>Rename and delete objects.</li>
<br />
<!-- Chapter 2-7 118 -->
<li>Create, edit, and run a macro .</li>
<li>Assign a macro to a command button on a form.</li>
<li>Create and edit a switchboard form.</li>
<li>Configure the database to display a form at startup and show an application title.</li>
<li>Show and hide the navigation pane.</li>
<li>Customize the navigation pane by hiding objects.</li>
<li>Define error checking options.</li>
<li>Encrypt a database by assigning a password.</li>
<li>Create and .accde database file.</li>
<li>View trust center settings.</li>
<br />
<!-- Chapter 2-8 128 -->
<li>Import data from another Access database.</li>
<li>Link to a table in another Access database.</li>
<li>Determine when to import versus link from external sources.</li>
<li>Reset or refresh links using the Linked Table Manager.</li>
<li>Import data from a text file.</li>
<li>Save import specifications.</li>
<li>Export data in an Access table or query as a text file.</li>
<li>Save and run export specifications.</li>
<li>Save an object as an XPS file.</li>
</ol>
</span></fieldset>
<?
$thisFile=__FILE__; $thisLine=__LINE__; include('Course/ExampleFlles.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('ReferencesResources.phpinc');
?>
<fieldset><legend>Requirements</legend><span class="normal">
An average student will spend <?=$class['totalHours']?> hours performing course tasks:
<? if ($class['lectureHours'] != 0) { ?><?=$class['lectureHours']?> hours of lecture<?=$lectureHoursPunctuation?><? } ?>
<? if ($class['labHours'] != 0) { ?><?=$class['labHours']?> hours working on assigned tasks in the lab<?=$labHoursPunctuation?><? } ?>
<? if ($class['lectureHours'] == 0 && $class['labHours'] == 0) { ?>No class hours, <? } ?>
<? if ($class['outsideHours'] != 0) { ?><?=$class['outsideHours']?> 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.
<? if ($class['lectureHours'] != 0 || $class['labHours'] != 0) { ?> Attendance is critical for completion of the lab credits.<? } ?>
</span></fieldset>
<fieldset><legend>Grading</legend><span class="normal">
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%.
</span></fieldset>
</p>
<?
$thisFile=__FILE__; $thisLine=__LINE__; include('Course/DisabilityNotice.phpinc');
$thisFile = __FILE__; $thisLine=__LINE__; include('common/sectionFooter.phpinc');
$thisFile = __FILE__; $thisLine=__LINE__; include('common/pageFooter.phpinc');
?>