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
51017 008 MT----- 06:00-09:29 PM 04/21/14-04/22/14 RC 250 Grandgenett C 9 of 14
51348 009 --W---- 08:00-03:59 PM 05/07/14-05/07/14 RC 250 Tuck L 10 of 14
51349 010 MT----- 06:00-09:29 PM 05/19/14-05/20/14 RC 250 Hultgren S 14 of 14
52969 017 -TW---- 06:00-09:29 PM 05/27/14-05/28/14 Off Campus OHEC 131 Hultgren S 13 of 14
51350 011 -T----- 08:00-03:59 PM 06/03/14-06/03/14 RC 250 Grandgenett C 14 of 14
52970 018 ----F-- 08:00-03:59 PM 06/06/14-06/06/14 Off Campus OHEC 131 TBA 14 of 14
51351 012 --WR--- 06:00-09:29 PM 06/18/14-06/19/14 RC 253 Stublen N 14 of 14
51352 013 M------ 08:00-03:59 PM 07/07/14-07/07/14 RC 253 Tuck L 13 of 14
51353 014 --W---- 08:00-03:59 PM 07/30/14-07/30/14 RC 250 Tuck L 14 of 14
53442 019 MT----- 06:00-09:29 PM 08/18/14-08/19/14 Off Campus OHEC 131 TBA 14 of 14
53443 020 --W---- 08:00-03:59 PM 09/03/14-09/03/14 RC 254 TBA 14 of 14
53444 021 --WR--- 06:00-09:29 PM 09/24/14-09/25/14 RC 253 TBA 14 of 14
53445 022 ---R--- 08:00-03:59 PM 10/02/14-10/02/14 RC 221 TBA 14 of 14
53446 23 M------ 08:00-03:59 PM 10/13/14-10/13/14 RC 221 TBA 14 of 14
53447 24 ----F-- 08:00-03:59 PM 10/24/14-10/24/14 Off Campus OHEC 131 TBA 14 of 14
53448 25 M------ 08:00-03:59 PM 11/03/14-11/03/14 RC 221 TBA 14 of 14
53449 026 --WR--- 06:00-09:29 PM 12/03/14-12/04/14 RC 255 TBA 14 of 14

XCOA 1001 - Access 2010 Intermediate

Learn how to normalize data, manage table relationships, and enforce referential integrity; work with lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts. 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: Access Fundamentals or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Access Intermediate outline:

Unit 1:	Relational databases
	Topic A:	Database normalization
	Topic B:	Table relationships
	Topic C:	Referential integrity

Unit 2:	Related tables
	Topic A:	Creating lookup fields
	Topic B:	Modifying lookup fields
	Topic C:	Subdatasheets

Unit 3:	Complex queries
	Topic A:	Joining tables in queries
	Topic B:	Using calculated fields
	Topic C:	Summarizing and grouping values

Unit 4:	Advanced form design
	Topic A:	Adding unbound controls
	Topic B:	Adding graphics
	Topic C:	Adding calculated values
	Topic D:	Adding combo boxes
	Topic E:	Advanced form types

Unit 5:	Reports and printing
	Topic A:	Customized headers and footers
	Topic B:	Calculated values
	Topic C:	Printing
	Topic D:	Labels

Unit 6:	Charts
	Topic A:	Charts in forms
	Topic B:	Charts in reports

Unit 7:	PivotTables and PivotCharts
	Topic A:	PivotTables
	Topic B:	Modifying PivotTables
	Topic C:	PivotCharts
	Topic D:	PivotTable forms
 
CRN Days Time Date Location Instructor Seats Open
50621 004 --W---- 08:00-03:59 PM 04/09/14-04/09/14 RC 250 Tuck L 10 of 14
51354 006 --W---- 08:00-03:59 PM 05/14/14-05/14/14 RC 250 Friedrichsen L 8 of 14
51355 007 -T----- 08:00-03:59 PM 06/10/14-06/10/14 RC 254 Snyder B 13 of 14
52971 012 ----F-- 08:00-03:59 PM 06/20/14-06/20/14 Off Campus OHEC 131 Snyder B 14 of 14
52972 013 --WR--- 06:00-09:29 PM 06/25/14-06/26/14 Off Campus OHEC 131 Grandgenett C 14 of 14
51356 008 MT----- 06:00-09:29 PM 07/14/14-07/15/14 RC 250 Hultgren S 13 of 14
51357 009 -T----- 08:00-03:59 PM 08/05/14-08/05/14 RC 250 Tuck L 14 of 14
53450 014 MT----- 06:00-09:29 PM 09/08/14-09/09/14 Off Campus OHEC 131 TBA 14 of 14
53451 015 ---R--- 08:00-03:59 PM 09/11/14-09/11/14 RC 252 TBA 10 of 10
53452 016 ---R--- 08:00-03:59 PM 10/09/14-10/09/14 RC 221 TBA 14 of 14
53454 017 --WR--- 06:00-09:29 PM 10/15/14-10/16/14 RC 253 TBA 14 of 14
53458 018 --W---- 08:00-03:59 PM 11/12/14-11/12/14 Off Campus OHEC 131 TBA 14 of 14
53459 019 ---R--- 08:00-03:59 PM 11/13/14-11/13/14 RC 221 TBA 14 of 14
53460 020 --WR--- 06:00-09:29 PM 12/10/14-12/11/14 RC 255 TBA 14 of 14

XCOA 1002 - Access 2010 Advanced

Learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook to update data. 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: Access Intermediate or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Access Advanced outline:

                         Unit 1:  Querying with SQL
                               Topic A:  SQL and Access
                               Topic B:  Writing SQL statements
                               Topic C:  Attaching SQL queries to controls

                         Unit 2:  Advanced queries
                               Topic A:  Creating crosstab queries
                               Topic B:  Creating parameter queries
                               Topic C:  Using action queries

                         Unit 3:  Macros
                               Topic A:  Creating, running, and modifying macros
                               Topic B:  Attaching macros to the events of database objects

                         Unit 4:  Advanced macros
                               Topic A:  Creating macros to provide user input
                               Topic B:  Creating macros that require user input
                               Topic C:  Creating the AutoKeys and AutoExec macros
                               Topic D:  Creating macros for data transfer

                         Unit 5:  Importing, exporting, and linking objects
                               Topic A:  Importing objects
                               Topic B:  Exporting objects
                               Topic C:  Working with the XML documents
                               Topic D:  Linking Access objects
                               Topic E:  Using hyperlink fields

                         Unit 6:  Database management
                               Topic A:  Optimizing resources
                               Topic B:  Protecting databases
                               Topic C:  Setting options and properties

 
CRN Days Time Date Location Instructor Seats Open
50609 006 --W---- 08:00-03:59 PM 04/16/14-04/16/14 RC 253 Tuck L 10 of 14
51343 007 --W---- 08:00-03:59 PM 05/21/14-05/21/14 RC 250 Tuck L 8 of 14
51344 008 -T----- 08:00-03:59 PM 06/24/14-06/24/14 RC 250 Tuck L 13 of 14
52967 012 M------ 08:00-03:59 PM 06/30/14-06/30/14 Off Campus OHEC 131 Snyder B 14 of 14
52968 013 MT----- 06:00-09:29 PM 07/14/14-07/15/14 Off Campus OHEC 131 Snyder B 14 of 14
51345 010 MT----- 06:00-09:29 PM 07/28/14-07/29/14 RC 255 Grandgenett C 13 of 14
51346 011 --W---- 08:00-03:59 PM 08/13/14-08/13/14 RC 250 Friedrichsen L 14 of 14
53461 014 M------ 08:00-03:59 PM 09/15/14-09/15/14 RC 221 TBA 14 of 14
53462 015 MT----- 06:00-09:29 PM 09/29/14-09/30/14 Off Campus OHEC 131 TBA 14 of 14
53463 016 ---R--- 08:00-03:59 PM 10/23/14-10/23/14 RC 221 TBA 14 of 14
53464 017 --WR--- 06:00-09:29 PM 10/29/14-10/30/14 RC 253 TBA 14 of 14
53465 018 ---R--- 08:00-03:59 PM 11/20/14-11/20/14 RC 221 TBA 14 of 14
53466 019 M------ 08:00-03:59 PM 12/01/14-12/01/14 Off Campus OHEC 131 TBA 14 of 14
53467 020 --WR--- 06:00-09:29 PM 12/17/14-12/18/14 RC 255 TBA 14 of 14

XCOA 1003 - Access Application Development

Go beyond using the built-in features offered by Access and develop your own applications. The course starts with how to plan an application from the ground up, and how to make use of advanced form design, macros, and dialog boxes. The course also covers creating switchboards, splash screens, custom menu forms, and navigation groups. This class can also be taken as part of the Access Developer Certificate. For details visit our web page.Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Access Advanced or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Access Applications Development outline: 

Unit 1: Application design
Topic A: Examining an application
Topic B: Planning an application
Topic C: Creating a binary executable

Unit 2: Advanced form design
Topic A: Using grouped controls
Topic B: Using the Tab control
Topic C: Creating subforms

Unit 3: Dialog boxes and macros
Topic A: Working with dialog boxes
Topic B: Working with macro groups
Topic C: Automating navigation across forms

Unit 4: Application navigation
Topic A: Working with switchboards
Topic B: Working with splash screens

Unit 5: Custom menus and navigation groups
Topic A: Custom menu forms
Topic B: Custom groups in the Navigation Pane
 
CRN Days Time Date Location Instructor Seats Open
50611 002 --WR--- 06:00-09:29 PM 04/23/14-04/24/14 RC 221 Snyder B 12 of 14
51347 003 M------ 08:00-03:59 PM 06/30/14-06/30/14 RC 250 Tuck L 11 of 14
53468 004 ---R--- 08:00-03:59 PM 10/02/14-10/02/14 RC 252 TBA 10 of 10
53469 005 --WR--- 06:00-09:29 PM 11/05/14-11/06/14 RC 253 TBA 14 of 14

XCOA 1004 - Access VBA Programming

Learn about ActiveX Data Objects, control structures, and the basics of VBA programming. This class can also be taken as part of the Access Developer Certificate. For details visit our web page.Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Access Application Development or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Access VBA Programming outline:

Unit 1: Visual Basic Editor
Topic A: Objects
Topic B: Object Browser
Topic C: Collections

Unit 2: Programming basics
Topic A: Working with data
Topic B: Scope

Unit 3: Control structures
Topic A: Decision structures
Topic B: Loop structures

Unit 4: ActiveX Data Objects
Topic A: Getting started with ActiveX Data Objects
Topic B: Working with ActiveX Data Objects

Unit 5: VBA debugging tools
Topic A: Errors in code
Topic B: Debugging techniques
Topic C: Handling runtime errors
 
CRN Days Time Date Location Instructor Seats Open
50624 002 --WR--- 06:00-09:29 PM 04/30/14-05/01/14 RC 221 Grandgenett C 12 of 14
51358 003 M------ 08:00-03:59 PM 07/14/14-07/14/14 RC 250 Tuck L 12 of 14
53470 004 ---R--- 08:00-03:59 PM 10/16/14-10/16/14 RC 254 TBA 14 of 14
53471 005 --WR--- 06:00-09:29 PM 11/12/14-11/13/14 RC 232 TBA 14 of 14

XCOA 1007 - Access 2013 Fundamentals

Cover the basic skills and concepts to use Microsoft Access 2013. Learn how to plan databases and create tables. Organize fields, work with data entry rules, create basic queries and work with 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

Unit 1:  Getting started
            Topic A:  Database Concepts
            Topic B:  Exploring the Access environment
Unit 2:  Databases and tables
            Topic A:  Planning and designing databases
            Topic B:  Exploring tab les
            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
51857 001 ---R--- 08:00-03:59 PM 05/22/14-05/22/14 RC 255 Tuck L 14 of 14
51858 002 --WR--- 06:00-09:29 PM 07/09/14-07/10/14 RC 234 Coon C 14 of 14
53472 003 ---R--- 08:00-03:59 PM 08/21/14-08/21/14 RC 234 TBA 14 of 14
53473 004 MT----- 06:00-09:29 PM 09/22/14-09/23/14 RC 234 TBA 14 of 14

XCOA 1008 - Access 2013 Intermediate

Learn to normalize data, join tables while observing referential integrity, and query multiple tables in Access 2013. Create specialized objects such as lookup fields, subforms and subreports, navigation forms, and calculated fields. 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: Access 2013 Fundamentals or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Unit 1:  Relational databases
            Topic A:  Database normalization
            Topic B:  Table relationships
            Topic C:  Referential integrity
Unit 2:  Related tables
            Topic A:  Creating lookup fields
            Topic B:  Modifying lookup fields
            Topic C:  Subdatasheets
Unit 3:  Complex queries
            Topic A:  Joining tables in queries
            Topic B:  Using calculated fields
            Topic C:  Summarizing and grouping values
Unit 4:  Advanced form design
            Topic A:  Adding unbound controls
            Topic B:  Graphics
            Topic C:  Adding calculated values
            Topic D:  Adding combo boxes
            Topic E:  Advanced form types
Unit 5:  Reports and printing
            Topic A:  Report formatting
            Topic B:  Calculated values and subreports
            Topic C:  Printing
            Topic D:  Label printing
Unit 6:  Charts
            Topic A:  Charts in forms
            Topic B:  Charts in reports
 
CRN Days Time Date Location Instructor Seats Open
51863 001 ---R--- 08:00-03:59 PM 06/05/14-06/05/14 RC 255 TBA 14 of 14
51864 002 --WR--- 06:00-09:29 PM 07/23/14-07/24/14 RC 234 Grandgenett C 14 of 14
53474 003 ---R--- 08:00-03:59 PM 09/04/14-09/04/14 RC 232 TBA 14 of 14
53475 004 MT----- 06:00-09:29 PM 10/06/14-10/07/14 RC 250 TBA 14 of 14

XCOA 1009 - Access 2013 Advanced

Discover the advanced features of Access 2013. Learn how to query with SQL; create crosstab, parameter, and action queries; create macros; work with XML documents; and create hyperlink fields. 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: Access 2013 Intermediate or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Unit 1:  Querying with SQL
            Topic A:  SQL and Access
            Topic B:  Writing SQL statements
            Topic C:  Attaching SQL queries to controls
Unit 2:  Advanced queries
            Topic A:  Creating crosstab queries
            Topic B:  Creating parameter queries
            Topic C:  Using action queries
Unit 3:  Macros
            Topic A:  Creating, running, and modifying macros
            Topic B:  Attaching macros to the events of database objects
Unit 4:  Advanced macros
            Topic A:  Creating macros to provide user interaction
            Topic B:  Creating macros that require user input
            Topic C:  Creating AutoKeys and AutoExec macros
            Topic D:  Creating macros for data transfer
Unit 5:  Importing, exporting, and linking objects
            Topic A:  Importing objects
            Topic B:  Exporting objects
            Topic C:  Working with XML documents
            Topic D:  Linking Access objects
            Topic E:  Using hyperlink fields
Unit 6:  Database management
            Topic A:  Optimizing resources
            Topic B:  Protecting databases
            Topic C:  Setting options and properties
 
CRN Days Time Date Location Instructor Seats Open
51865 001 ---R--- 08:00-03:59 PM 06/19/14-06/19/14 RC 255 Grandgenett C 14 of 14
51866 002 --WR--- 06:00-09:29 PM 08/06/14-08/07/14 RC 234 TBA 14 of 14
53476 003 ---R--- 08:00-03:59 PM 09/18/14-09/18/14 RC 234 TBA 14 of 14
53477 004 MT----- 06:00-09:29 PM 10/27/14-10/28/14 RC 253 TBA 14 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 (ANGEL) 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.