PELLISSIPPI STATE TECHNICAL COMMUNITY COLLEGE
MASTER SYLLABUS

ACCESS I CBT
OST 1007

Class Hours: 0.0

 

Credit Hours: 1.0

 

Laboratory Hours: 3.0

 

Revised: Fall  08

 

 NOTE: This course is not designed for transfer credit.

 

Catalog Course Description:

 

 

 

Introduction to basic database features of Microsoft Access. Skills to create databases and tables, enter and update data display, print records, create forms, restructure data bases, use forms and sub-forms, use charts, create reports and sub-reports are developed. The course is created specifically to meet the Microsoft Certified Application Specialist program guidelines. It is delivered through Computer Based Training materials; some basic computer-use knowledge is required.

Entry Level Standards:

 

 

 

Basic knowledge of a personal computer and its operation

Prerequisite:

 

 

 

OST 1100 or equivalent

Textbook(s) and Other Course Materials:

 

 

License for SAM 2003 Assessment and Training, Version 3.0, Course Technology, 2005. You will purchase the SAM license ONCE and will use it for Word CBT, Excel CBT, PowerPoint CBT, Access CBT and Outlook CBT. These are the MOUS courses that require SAM 2003 Assessment and Training. 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-619-172347.
IMPORTANT NOTE: This license will include your login ID number. You will use this number the first time you login to the SAM software. Once the login number has been used, it is associated with your account and cannot be used by another student. If you lose the number, you will have to purchase another license.

 
Microsoft Access 2003--Comprehensive Concepts and Techniques by Shelly, Cashman, Pratt, published Course Technology, 2006, ISBN 1-4188-4363-6. This book will also be used in OST 1008-- Access II CBT.    

I. Week/Unit/Topic Basis:

 

 

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

 

Week 

Topic

 

1

Introduction to Access 2003--Install SAM 2003 Training tutorials
Install the SAM 2003 training software to your home computer. Download and install files necessary to complete textbook projects. Complete the WebCT site quiz. 

 

2

Complete Project 1 (in textbook) and complete the SAM 2003 Training tutorials for Project 1
Introducing databases; starting Access 2003; using databases; creating databases; Help; creating tables; entering and changing data; using a form to view data; creating a simple report. 

 

3

Complete Project 2 (in textbook) and complete the SAM 2003 Training tutorials for Project 2
Querying a database using the select query window; creating a new query; entering criteria and using compound criteria; sorting data in a query; joining a table; using calculated fields in a query. 

 

4

Introduction to Access 2003--Testing 
Take the SAM Assessment theory/application test in the Testing Center over Projects 1 and 2.

 

5

Complete Project 3 (in textbook) and complete the SAM 2003 Training tutorials for Project 3
Adding, changing, and deleting records in a table; changing a structure of a database; creating validation rules; specifying referential integrity; using subdatasheets; ordering records on multiple fields; creating and using indexes. 

 

6

Complete Integration Feature (in textbook). Complete Project 4 (in textbook) and complete the SAM 2003 Training tutorials for Project 4
Convert data from other applications to Access; Copy data from Access to other applications; Export and import XML data.
Reports, forms, and combo boxes; report creation; grouping in a report; considerations and review of report design; designing, creating, and using custom forms.

 

7

Intermediate Access 2003--Testing
Take the SAM 2003 Assessment theory/application test in the Testing Center over Projects 3, 4 and Integration Feature.

II. Course Objectives*:

 

 

 

A.

Demonstrate basic fundamentals of Microsoft Windows, Microsoft Access, and personal computer concepts. (I, III, VI, XI)

 

B.

Understand the basic terminology and concepts of database management. (III, IV, XI)

 

C.

Create and maintain a database and using queries, sort, indexes, forms, subforms, reports, and Integration features on the database. (I, III, V, IX)

 

D.

Demonstrate proficiency using realistic database applications and strengthen ability to proofread, explore associated database concepts, and use decision-making skills. (I, VIII, IX, X, XI)

*Roman numerals after course objectives reference goals of the OST program.

III. Instructional Processes*: 

 

 

Students will:

 

 

 

 

1.

Use technology to promote the objectives of this course; specifically, the Windows operating system, 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 

 

4.

Use the skills and applications taught in the SAM 2003 Training tutorials in actual work required in exercises that simulate real-world applications. Transitional Strategies

 

5.

Download applications from the Web and install the files on the student's personal computer to complete research activities required in exercises. Install SAM 2003 Training software on home personal computer.  Active Learning Strategies

*Strategies and outcomes listed after instructional processes reference TBR’s goals for strengthening general education knowledge and skills, connecting coursework to experiences beyond the classroom, and encouraging students to take active and responsible roles in the educational process.

IV. Expectations for Student Performance*: 

 

 

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.

Understand keyboard shortcut notations. (A)

 

5.

Start an application program in Windows 2000 or XP. (A,C)

 

6.

Identify the components of the Access screen. (A)

 

7.

Format a disk. (A)

 

8.

Backup files, disks, and databases. (A)

 

9.

Identify and utilize the Windows Explorer. (A)

 

10.

Copy, delete, and move files. (A)

 

11.

Understand database structure. (A,B)

 

12.

Start Access 2003. (A,B)

 

13.

Use databases. (A,B)

 

14.

Create databases. (A,B)

 

15.

Use the Help feature of the software. (A,B)

 

16.

Create tables. (A,B)

 

17.

Define relationships. (A,B)

 

18.

Enter and change data. (A,B)

 

19.

Insert a new field. (B,C,D)

 

20.

Sort and search for records. (B,C,D)

 

21.

Work with indexes. (B,C,D)

 

22.

Filter records. (B,C,D)

 

23.

Create queries using design view. (B,C,D)

 

24.

Enter selection criteria. (B,C,D)

 

25.

Join tables and build relationships between tables. (B,C,D)

 

26.

Work with forms. (B,C,D)

 

27.

Create forms. (B,C,D)

 

28.

Create a form using AutoForm. (B,C,D)

 

29.

Create a subform. (B,C,D)

 

30.

Build a custom form. (B,C,D)

 

31.

Get more control from forms. (B,C,D)

 

32.

Format forms. (B,C,D)

 

33.

Use reports. (B,C,D)

 

34.

Grouping in reports. (B,C,D)

 

35.

Create an autoformat. (B,C,D)

 

36.

Create sub-reports. (B,C,D)

 

37.

Print a report. (B,C,D)

 

38.

Convert data from other applications to Access. (B,C,D)

 

39.

Copy data from Access to other applications. (B,C,D)

 

40.

Export and import XML data.(B,C,D)

*Letters after performance expectations reference the course objectives listed above.

V. Evaluation:

 

 

 

A.  Testing Procedures:  90 Percent  Tests/Tutorials:                                                                       

 

Two types of tests will be given in this course for grade determination

(1) practical training tests administered through the SAM 2003 Training tutorial software (taken over the Web) and


(2) SAM 2003 Assessment application and theory 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. Two SAM 2003 Training tutorials and practical application tests delivered over Web 
    • Projects 1-2 (15%) 
    • Projects 3, 4, and Integration feature (15%) 
  2. Two SAM 2003 Assessment application/theory tests over textbook material taken in the Testing Center 
    • Projects 1 and 2 (30%) 
    • Projects 3, 4, and Integration Feature (30%) 

 

B. Laboratory Expectations:

 

N/A

 

C. Field Work:

 

N/A

 

D. Other Evaluation Methods: 10% of grade

 

5%--Active involvement in WebCT email communication with instructor and successful download of necessary files and installation of software for coursework, and submission of completed “Are You Ready for Online Learning?” survey by designated due dates
5%--Successful completion and grade on WebCT Site Quiz by designated due date

 

E. Grading Scale:

 

The final grade will be determined by averaging the scores on the SAM 2003 Assessment and Training theory/application 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:

 

 

 

A. Attendance Policy:

 

Pellissippi State expects students to attend all scheduled instructional activities. As a minimum, students in all courses (excluding distance learning courses) must be present for at least 75 percent of their scheduled class and laboratory meetings in order to receive credit for the course. Individual departments/programs/disciplines, with the approval of the vice president of Learning, may have requirements that are more stringent. In very specific circumstances, an appeal of the policy may be addressed to the head of the department in which the course was taken. If further action is warranted, the appeal may be addressed to the vice president of Learning.

 

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 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.