|
|
||||||||
|
ACCESS |
||||||||
|
Class Hours: 3.0 |
|
Credit Hours: 3.0 |
|
|||||
|
Laboratory Hours: 0.0 |
|
Revised: Spring 07 |
|
|||||
|
NOTE: This course is not designed for transfer credit. |
|
|||||||
|
Catalog Course Description: |
|
|
||||||
|
|
A study of database applications and maintenance including customizing forms and reports querying and integrating with other software programs using Microsoft Access. |
|||||||
|
Entry Level Standards: |
|
|
||||||
|
|
Keyboarding speed of 28 wam recommended. |
|||||||
|
Prerequisites: |
|
|
||||||
|
|
OST 1005 or 1211 or equivalent |
|||||||
|
Textbook(s) and Other Course Materials: |
|
|||||||
|
|
1.Adamski, Joseph J.,
Finnegan, Kathleen T., Hommel, Charles, Microsoft
Access 2002, New Perspectives Series Comprehensive, Course Technology, Inc.,
2002. (ISBN 0-619-02089-X) |
|||||||
|
I. Week/Unit/Topic Basis: |
|
|
||||||
|
|
Week |
Topic |
||||||
|
|
1 |
Introduction to Course; Syllabus; Introduction to Databases and Access 2002 |
||||||
|
|
2 |
Creating a Database, Supplemental Exercise 1 |
||||||
|
|
3 |
Querying a Database |
||||||
|
|
4 |
Querying Continued |
||||||
|
|
5 |
Creating Forms and Reports |
||||||
|
|
6 |
SAM Test 1, Supplemental Exercise 2 |
||||||
|
|
7 |
Midterm Exam |
||||||
|
|
8 |
Enhancing a Table’s Design and Creating Advanced Queries, Supplemental Exercise 3 |
||||||
|
|
9 |
Customizing Forms |
||||||
|
|
10 |
Customizing Reports, Supplemental Exercise 4 |
||||||
|
|
11 |
Integrating Access with the Web |
||||||
|
|
12 |
Integrating Access with the Other Programs, Supplemental Exercise 5 |
||||||
|
|
13 |
Using Query Wizards, Creating Action Queries |
||||||
|
|
14 |
Defining Table Relations and Using Indexes; SAM Test 2, Supplemental Exercise 6 |
||||||
|
|
15 |
Final Exam |
||||||
|
II. Course Objectives*: |
|
|
||||||
|
|
A. |
Uses basic terminology and concepts of database management. III, IV, XII |
||||||
|
|
B. |
Demonstrate basic features of the Windows and Access 2002 database software. I, III, XI |
||||||
|
|
C. |
Demonstrate proficiency when using Access 2002 advanced database features. I, III, XI |
||||||
|
|
D. |
Demonstrate proficiency when using Windows utilities. III, XI |
||||||
|
|
E. |
Provide the student with hands-on experience using realistic database applications and strengthen the student's ability to proofread, explore associated database concepts, and use decision-making skills. I, IV, VI, VIII, IX, X XI |
||||||
|
*Roman numerals after course objectives reference goals of the OST program. |
||||||||
|
III. Instructional Processes*: |
|
|
||||||
|
Students will: |
|
|
|
|||||
|
|
1. |
Complete a semester long
case study that will place the student in a position in which the student
will be responsible for creating and maintaining a database for a business as
described in the case study. (Active Learning Strategies) |
||||||
|
|
2. |
Solve database problems
based on real office situations. (Transitional Strategies) |
||||||
|
|
3. |
Query data from a database
and generate reports to help make business decisions. (Technological
Literacy Outcome) |
||||||
|
|
4. |
Export a database to other
software packages, import an HTML file as an Access table, and create
hyperlinks to documents and the World Wide Web to understand the integration
of software packages. (Technological
Literacy Outcome) |
||||||
|
|
5. |
Use e-mail to communicate
with the instructor on class activities and assignments. (Technological
Literacy Outcome) |
||||||
|
|
6. |
Internalize the work ethic
by regularly attending class (or attending Web class through logins), being
punctual, submitting work by following deadlines, and acting in a
professional manner. (Transitional
Strategies, Active Learning Strategies) |
||||||
|
IV. Expectations for Student Performance*: |
|
|
||||||
|
Upon successful completion of this course, the student should be able to: |
||||||||
|
|
1. |
Recognize the power of a database. A |
||||||
|
|
2. |
Distinguish between data and information. A |
||||||
|
|
3. |
Consider what is needed to set up a database. A |
||||||
|
|
4. |
Identify the components of a database. A |
||||||
|
|
5. |
Distinguish between a flat file and relational database. A |
||||||
|
|
6. |
Create and modify a database structure and table and input fields. B, E |
||||||
|
|
7. |
Save a database, edit a database, and retrieve selected data from a database. B, E |
||||||
|
|
8. |
Sort a database. B |
||||||
|
|
9. |
Print a database. B |
||||||
|
|
10. |
Use the Access Help system. B |
||||||
|
|
11. |
Import and replace data into a table. B |
||||||
|
|
12. |
Back up a database. B |
||||||
|
|
13. |
Define record selection and multiple selection criteria. C, E |
||||||
|
|
14. |
Save and open a query. C, E |
||||||
|
|
15. |
Perform query calculations. C, E |
||||||
|
|
16. |
Add relationships between tables. C |
||||||
|
|
17. |
Design and create a custom form. C, E |
||||||
|
|
18. |
Save and open a form. C |
||||||
|
|
19. |
Design and create a custom report. C, E |
||||||
|
|
20. |
Modify report controls and properties. C, E |
||||||
|
|
21. |
Create advanced queries. C, E |
||||||
|
|
22. |
Add OLE objects, such as charts and graphics images, to forms and reports. C, E |
||||||
|
|
23. |
Integrate Access with other software programs. C, E |
||||||
|
|
24. |
Create and use Data Access Pages to save Access objects in HTML format. C, E |
||||||
|
|
25. |
Import HTML files as an Access table. C, E |
||||||
|
|
26. |
Add hyperlink fields to an Access table, and enter hyperlinks to documents and Data Access Pages. C, E |
||||||
|
|
27. |
Create and use Crosstab and Find Unmatched Queries. C, E |
||||||
|
|
28. |
Create and use Action Queries. C, E |
||||||
|
|
29. |
Define table relationships. C, E |
||||||
|
|
30. |
Use indexes for table fields. C, E |
||||||
|
|
31. |
Copy, rename, and delete files through Windows. D |
||||||
|
|
32. |
Back-up files through MyComputer or Windows Explorer. D |
||||||
|
|
33. |
Change default drive at MyComputer or Windows Explorer. D |
||||||
|
|
34. |
Change directories at MyComputer or Windows Explorer. D |
||||||
|
*Letters after performance expectations reference the course objectives listed above. |
||||||||
|
V. Evaluation: |
|
|
||||||
|
|
A. Testing Procedures: 60 percent of grade |
|||||||
|
|
Evaluations will consist of SAM application/theory tests and a timed case-based midterm and final application exam. All tests and exams will consist of exercises to complete on the PC. NO MAKEUP TESTS OR EXAMS WILL BE GIVEN. If a student does not take one of the SAM tests, the student will take a comprehensive SAM test at the end of the semester to replace the SAM test missed. The comprehensive SAM test can replace ONE missed SAM test only. If a student does not take the final exam in the course, the student will receive an "F" for the course. Value of final grade: 60 percent. SAM Application Tests = 20 percent |
|||||||
|
|
B. Laboratory Expectations: 40 percent of grade |
|||||||
|
|
DAILY PROCEDURES:
|
|||||||
|
|
C. Field Work: |
|||||||
|
|
N/A |
|||||||
|
|
D. Other Evaluation Methods: |
|||||||
|
|
If applicable, will be provided by instructor via syllabus supplement. |
|||||||
|
|
E. Grading Scale: |
|||||||
|
|
A
93-100 C+
80-84 F < 69 |
|||||||
|
V. Policies: |
|
|
||||||
|
|
A. Attendance Policy: |
|||||||
|
|
|
|||||||
|
|
B. Academic Dishonesty: |
|||||||
|
|
Plagiarism, cheating,
and other forms of academic dishonesty are prohibited. Students guilty of
academic misconduct, either directly or indirectly through participation or
assistance, are immediately responsible to the instructor of the class. In
addition to other possible disciplinary sanctions which may be imposed
through the regular |
|||||||
|
|
C. Accommodations for disabilities: |
|||||||
|
|
If you need accommodations because of a disability, if you have emergency medical information to share, or if you need special arrangements in case the building must be evacuated, please inform the instructor immediately. Please see the instructor privately after class or in his/her office. Students must present a current accommodation plan from a staff member in Services for Students with Disabilities (SSWD) in order to receive accommodations in this course. Services for Students with Disabilities may be contacted by going to Goins 127 or 131 or by phone: 694-6751(Voice/TTY) or 539-7153. |
|||||||
|
|
D. Other Policies: |
|||||||
|
|
OST majors are required to
complete a professional portfolio in which they will collect examples of
documents that they complete in OST 2006 (Advanced Word), OST 2621 (Excel),
OST 2600 (Access), OST 1006 (PowerPoint), OST 2120 (Keyboarding III), OST
2801/02/03 (Creating Web Pages), OST 2015 (Microsoft Office Integration), and
OST 2300/2301 (Practicum). This portfolio will be submitted during the last
semester at In order for grades to be calculated, all assigned work must be submitted in a timely fashion. Assigned work must be turned in by date designated. Late work will be charged with a late penalty. Late work will NOT be accepted after ONE week beyond the designated due date. The MS Access software is available for use in the open computer labs on any campus. Students must have a valid PSTCC ID and/or a Driver's License to be presented on demand to gain access to PSTCC facilities. COMPUTER USAGE GUIDELINES: |
|||||||