OST 1008--Access II CBT

1 credit
0 hour lecture, 3 lab
Syllabus updated: January 2003

Questions concerning course? Phone/Email lead instructor: Janice Rowland, 865-694-6487, jrowland@pstcc.edu

Catalog Course Description:

Advanced database features and applications used to search through databases, create reports, queries, macros, and Internet features will be presented. The course is created specifically to meet the Microsoft Office User Specialist Program guidelines. It is delivered through Computer Based Training (SmartForce) materials; some basic computer-use knowledge is required.

Entry-level Standards:

Basic knowledge of a personal computer and its operation

Prerequisite:

OST 1007--Access I CBT or equivalent

Textbooks and Other Supplies

• License for SAM XP testing software. You will purchase the SAM XP testing license ONCE and will use it for Word CBT, Excel CBT, PowerPoint CBT, and Access CBT. These are the MOUS courses that require SAM XP application tests. The license is good as long as you are a student at PSTCC and take courses that require this testing.
  The ISBN Number for the license is 0-6191-1991-8.
  IMPORTANT NOTE: You will get a SAM ID when you purchase the software in the bookstore. It has your registration number on it. KEEP THIS ID IN A SAFE PLACE--YOU WILL NEED IT FOR LOGGING IN WHEN YOU TAKE YOUR FIRST SAM TEST. If you lose the number, you will have to purchase another license.
• Microsoft Access 2002 Comprehensive Concepts and Techniques, by Shelly, Cashman, Pratt, published by Course Technology, 2002, ISBN 0-7895-6282-0. This is the same text that is used in OST 1007--Access I CBT.

I.    Unit/Topic/Basis (Tentative Schedule)

(See Where Do I Begin? section at end of this syllabus for detailed instructions on accessing tutorials, textbook assignments, and testing structure.)

• Week 1 Advance Database Design in Access 2002--SmartForce Tutorials
  Download the SmartForce player to your home computer if you have not yet done so. Begin the SmartForce tutorials on Advanced Database Design taking online tests with tutorials. Download and install files necessary to complete textbook projects.
• Week 2 Advance Database Design--SmartForce Tutorials and Project 5 (in textbook)
  Continue Advance Database Design SmartForce tutorials, taking online tests with tutorials. Enhancing forms with OLE fields, hyperlinks, and subforms; adding date, memo, OLE, and hyperlink fields; updating the new fields; advanced form techniques including modifying forms and subforms, moving and resizing fields and labels; changing special effects and colors; using date and memo fields in a query; closing and compacting a database.
• Week 3 Advance Database Design--SmartForce Tutorials and Project 6 (in textbook)
  Continue Advance Database Design SmartForce tutorials, taking online tests with tutorials. Creating an application system using macros, wizards, and the switchboard manager; using lookup and input mask wizards; modifying a report and a form; creating, using, and modifying macros; creating and using a switchboard.
• Week 4 Advance Database Design--SmartForce Tutorials, Integration Feature (in textbook) and Testing
  Converting Excel worksheet data to an Access database; exporting data to an Excel worksheet; linking versus importing, using drag-and-drop to export data to Word; using the export command to create a snapshot.
  Complete online SmartForce theory tests over Advance Database Design. Take SAM application test in the Testing Center over Projects 5, 6, and Integration.
• Week 5 Advance Database Features in Access 2002--SmartForce Tutorials (optional), and Project 7 (in textbook)
  Creating reports using design view; creating new tables and importing the data; creating join and parameter queries; creating mailing labels.
• Week 6 Advance Database Features in Access 2002--SmartForce Tutorials (optional), and Project 8 (in textbook)
  Enhancing forms; adding command buttons to a form; creating and using combo boxes; creating a form using design view; creating and modifying a subform.
• Week 7 Advance Database Features in Access 2002--SmartForce Tutorials (optional), and Project 9 (in textbook)
  Administering a database system; using Microsoft Access tools; using the Analyze tool; integrity features; using replication; PivotTables and PivotCharts.
• Week 8 Integration Feature (in textbook) and Testing
  Grouped data access pages; creating and using PivotTables and PivotCharts on a data access page.
  Take SAM application test in Testing Center over Projects 7, 8, 9 and Integration Feature.

II.    Course Objectives. (Program Goal reference in Roman numerals)

1. Demonstrate advanced features of Microsoft Access. (I, III, VI, XI)
2. Understand advanced terminology and concepts of database management. (III, IV, XI)
3. Use advanced Access features such as macros, wizards, and switchboard manager. (I, III, V, IX)
4. Use advanced Access features to create customized forms and reports. (I, III, V, IX)
5. Demonstrate sharing, replicating, synchronizing, and administrating databases. (I, III, V, IX)
6. Integrate Access with other software applications. (I, III, V, IX)
7. Demonstrate proficiency using realistic database applications and strength ability to proofread, explore associated database concepts, and use decision-making skills. (I, VIII, IX, X, XI)

III.    Instructional Processes. (General Education Outcome underlined)

1. Use technology to promote the objectives of this course; specifically, the Internet, email, and database management. Technological Literacy Outcome
2. Use WebCT email to communicate problems, questions, and issues to instructor. Communications Outcome
3. Using a personal computer, browser software, and the Internet, read and respond to tutorials on how to use the application packages presented in this course to gain user proficiency.Technological Literacy Outcome and Problem Solving and Decision Making Outcome
4. Use the skills and applications taught in the SmartForce tutorials in actual work required in exercises that simulate real-world applications. Transitional Strategy
5. Download applications from the Web and install the applications on the student's personal computer to complete research activities required in exercises. Active Learning Strategy

IV.    Expectations of Student Performance. (Course Objective in parentheses)
         Upon successful completion of this course, the student should be able to:

1. Use Internet resources. (A)
2. Use correspondence tool: WebCT email. (A)
3. Copy and download files and programs. (A)
4. Instal1 wizards. (A,C)
5. Custominzing the toolbar. (A)
6. Create a join query. (A,B,G)
7. Customize queries. (A,B,G)
8. Total and summary queries. (A,B,G)
9. Create parameter queries. (A,B,G)
10. Create a macro. (A,B,C,G)
11. Run macros. (A,B,C,G)
12. Modify a macro group. (A,B,C,G)
13. Use the Access wizards. (A,B,C,G)
14. Define an input mask. (A,B,C,G)
15. Create lookup fields. (A,B,C,G)
16. Create and use a switchboard. (A,B,C,G)
17. Create advanced forms and reports using combo boxes and buttons. (A,B,D,G)
18. Create and use PivotTables and PivotCharts. (A,B,D,G)
19. Use shared databases. (A,B,E,G)
20. Replicate databases. (A,B,E,G)
21. Synchronize databases. (A,B,E,G)
22. Administer database systems. (A,B,E,G)
23. Set and remove a database password. (A,B,E,G)
24. Restrict data entry. (A,B,E,G)
25. Import from Access databases. (A,B,F,G)
26. Import from non-Access sources. (A,B,F,G)
27. Link a spreadsheet. (A,B,F,G)
28. Export data. (A,B,F,G)
29. Group data access pages. (A,B,F,G)

V.    Evaluation

1. 90% Tests:
   Two types of tests will be given in this course for grade determination:
   (1) short-answer tests administered through the SmartForce tutorial software (taken over the Web) and
   (2) SAM application tests over the textbook material (taken in the Testing Center).

   The grades on these tests will be averaged to determine 90 percent of the course grade.

   Number of tests:
   

   1. One SmartForce tutorial test delivered over Web
      • Advance Database Design in Access 2002
   2. Two SAM application tests over textbook material taken in the Testing Center
      • Projects 5, 6, and Integration
      • Projects 7, 8, 9, and Integration

2. Laboratory expectations--not applicable
3. Field work--not applicable
4. 10% Other Evaluation Methods
           5%--Active involvement in WebCT email communication with instructor and successful download of necessary files and programs for coursework
           5%--Successful completion and grade on WebCT Site Quiz

        Grading Scale:

The final grade will be determined by averaging the scores on the SmartForce and textbook tests (90 percent) and on the above mentioned other evaluation methods (10 percent) according to these standards:

A       93-100
B+     90-92
B       85-89
C+     80-84
C       75-79
D       70-74
F       69 and below

VI.    Policies:

1. Students must have a valid PSTCC ID to be presented on demand to gain access to PSTCC facilities.
2. 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 Pellissippi State procedures as a result of academic misconduct, the instructor has the authority to assign an F or a zero for the exercise or examination or to assign an F in the course. (Reference, PSTCC Catalog)

Where do I begin?

1. Once you have your supplies and hardware/software setup, you should go to http://www.pstcc.edu/ets/dist_learn/online.html
2. Click on the Log into MyWebCT button and login to "MyWebCT".
3. Enter your username and password to login.
4. Click on OST 1008WW1 Access II CBT and click on the Course Information icon on the course home page.
5. Scroll down and choose the icon labeled Class Map and Due Dates, choose Map for Access II and print out the class map. This document will guide you through the course. It contains a list of the SmartForce tutorials you will use, the textbook pages for exercises and review, and a listing of what tests you need to take and when to take them.