Display Density
Note! Payment is due at time of registration.

Microsoft Access

XCOA 1000 - Access 2010 Fundamentals

Cover the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, students will design and create databases. They will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then create basic queries, forms, and reports. This class can also be taken as part of the Access Specialist Certificate. For details visit our web page.Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Comfortable using Windows, keyboard, and mouse.

CEU Hours: .7

Contact Hours: 7

Access Fundamentals outline:

Unit 1:	Getting started
	Topic A:	Database concepts
	Topic B:	Exploring the Access environment
	Topic C:	Getting help

Unit 2:	Databases and tables
	Topic A:	Planning and designing databases
	Topic B:	Exploring tables
	Topic C:	Creating tables

Unit 3:	Fields and records
	Topic A:	Changing the design of a table
	Topic B:	Finding and editing records
	Topic C:	Organizing records

Unit 4:	Data entry rules
	Topic A:	Setting field properties
	Topic B:	Working with input masks
	Topic C:	Setting validation rules

Unit 5:	Basic queries
	Topic A:	Creating and using queries
	Topic B:	Modifying query results and queries
	Topic C:	Performing operations in queries

Unit 6:	Using forms
	Topic A:	Creating forms
	Topic B:	Using Design view
	Topic C:	Sorting and filtering records

Unit 7:	Working with reports
	Topic A:	Creating reports
	Topic B:	Modifying and printing reports
 
CRN Days Time Date Location Instructor Seats Open
53443 020 --W---- 08:00-03:59 PM 09/03/14-09/03/14 RC 254 Tuck L 5 of 14
Clinic Courses (CLI) provide practical application and are offered on or off campus. Instructors supervise/direct student in a simulated or on-site setting.
Face-to-Face Courses (F2F) take place in a classroom. Based on JCCC's Statement of General Education. Students in all classes, including face-to-face classes, are expected to use technology appropriate to the course content and as needed to access web-based course materials. Face-to-face classes typically require access to computer equipment (either at home or in college labs provided for student use) and computing skills utilizing standard office, business and web browsing applications.
Hybrid Courses (HYB) combine face-to-face classroom instruction and the convenience of online web-based learning, resulting in a reduction of the amount of time spent in the face-to-face classroom and a significant increase of time spent studying online materials. Students registered in hybrid courses must attend class meetings as listed in the JCCC Schedule of Classes.
Internships (INT) provide experience to students for on-the-job training with cooperating businesses, agencies, and organizations. The number of hours for each internship varies.
Lab Courses (LAB) are face-to-face classes where students perform tasks as directed by faculty. Faculty members monitor the activity and provide individual and/or group instruction/assistance
Media Courses (MED) deliver all or a portion of instruction through either cable broadcast or pre-recorded video lessons. The videos are available in DVD format from the Billington Library.
Online Courses (ONLNE) use the Internet and a Learning Management System (D2L) to deliver course materials and to facilitate student-instructor, student-content, and student to student interaction. To participate in online courses, the student should have a good understanding of computer hardware and software applications and the Internet.
Continuing Education Online Courses (CEONL) and materials are delivered via the Internet. To participate in online courses, the student should have a good understanding of computer applications and Internet navigation. For more information about this course and other online learning options visit CE Online.
Private (PLV) lessons for credit are available from beginning to advanced in voice, piano, guitar, brass, woodwind and percussion. Lessons are scheduled by arrangement with private music instructors.
Self-Paced Courses (SEL) and Self-Paced Online (SPO) are offered on a schedule of study that allows students more flexible scheduling options. Course interaction is based upon a contract between student - instructor and in some cases can take up to one calendar year to complete. Some courses may use online delivery to facilitate the learning experience.
Self-Paced Courses (SEL) and Self-Paced Online (SPO) are offered on a schedule of study that allows students more flexible scheduling options. Course interaction is based upon a contract between student - instructor and in some cases can take up to one calendar year to complete. Some courses may use online delivery to facilitate the learning experience.
Travel Courses (TRV) may require in-class activities as well as traveling to a destination. Students will be responsible for the cost of the travel as well as the course costs.
Seats Open is an approximation of the number of seats available and may not represent the actual number of seats open at the time of registration.