Order By Display Density

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 be taken as part of the Microsoft Office Essentials Certificate and the Access Specialist Certificate. 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
20094 002 MT----- 06:00-09:29 PM 02/08/16-02/09/16 Off Campus OHEC 141 Snyder B 12 of 14
20095 003 --W---- 08:00-03:59 PM 03/16/16-03/16/16 RC 254 Tuck L 13 of 14
20096 004 --WR--- 06:00-09:29 PM 04/20/16-04/21/16 RC 253 Snyder B 14 of 14
21883 005 -T----- 08:00-03:59 PM 05/24/16-05/24/16 RC 252 Faculty 10 of 10
21884 006 MT----- 06:00-09:29 PM 06/27/16-06/28/16 Off Campus OHEC 141 Faculty 14 of 14
21885 007 MT----- 06:00-09:29 PM 07/25/16-07/26/16 RC 253 Faculty 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 be taken as part of the Access Specialist Certificate. 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
20097 001 MT----- 06:00-09:29 PM 02/22/16-02/23/16 Off Campus OHEC 141 Snyder B 12 of 14
20098 002 -T----- 08:00-03:59 PM 04/26/16-04/26/16 RC 253 Tuck L 13 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 be taken as part of the

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
20099 001 MT----- 06:00-09:29 PM 03/14/16-03/15/16 Off Campus OHEC 141 Snyder B 13 of 14
20100 002 --W---- 08:00-03:59 PM 05/04/16-05/04/16 RC 253 Tuck L 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 be taken as part of the Microsoft Office Essentials Certificate and the Access Specialist Certificate. 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
20102 002 ----F-- 08:00-03:59 PM 02/05/16-02/05/16 RC 255 Grandgenett C 12 of 14
20103 003 --WR--- 06:00-09:29 PM 03/02/16-03/03/16 RC 255 Grandgenett C 14 of 14
20104 004 M------ 08:00-03:59 PM 04/04/16-04/04/16 RC 255 Tuck L 11 of 14
21891 005 -TW---- 06:00-09:29 PM 05/31/16-06/01/16 RC 255 Faculty 14 of 14
21892 006 -T----- 08:00-03:59 PM 06/21/16-06/21/16 RC 255 Faculty 14 of 14
21893 007 --WR--- 06:00-09:29 PM 07/13/16-07/14/16 RC 255 Faculty 14 of 14
21894 008 -T----- 08:00-03:59 PM 08/02/16-08/02/16 RC 255 Faculty 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 be taken as part of the Access Specialist Certificate. 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
20105 001 MT----- 06:00-09:29 PM 02/15/16-02/16/16 RC 255 Snyder B 11 of 14
20106 002 --W---- 08:00-03:59 PM 04/27/16-04/27/16 RC 255 Tuck L 12 of 14
21895 003 MT----- 06:00-09:29 PM 06/13/16-06/14/16 RC 255 Faculty 14 of 14
21896 004 --W---- 08:00-03:59 PM 07/06/16-07/06/16 RC 255 Faculty 14 of 14
21897 005 --WR--- 06:00-09:29 PM 07/20/16-07/21/16 RC 255 Faculty 14 of 14
21898 006 -T----- 08:00-03:59 PM 08/09/16-08/09/16 RC 255 Faculty 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 be taken as part of the Access Specialist Certificate. 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
20107 001 MT----- 06:00-09:29 PM 02/29/16-03/01/16 RC 255 Faculty 12 of 14
20108 002 -T----- 08:00-03:59 PM 05/03/16-05/03/16 RC 255 Tuck L 12 of 14
21899 003 --WR--- 06:00-09:29 PM 06/22/16-06/23/16 RC 255 Faculty 14 of 14
21900 004 --WR--- 06:00-09:29 PM 07/27/16-07/28/16 RC 255 Faculty 14 of 14
21901 005 ---R--- 08:00-03:59 PM 08/18/16-08/18/16 RC 255 Faculty 14 of 14

XCOA 1010 - Access VBA Programming and Application Design

This course will provide a foundation of how to program with VBA. Learn how to debug, write, and modify code with the VBA environment. Dig deeper into programming with the objects that make up Access. Develop core Access VBA Developer techniques of working with forms, controls, and reports that are key interface components in applications. Lastly, learn ideas to help you design and build applications. This class can be taken as part of the Access Developer Certificate. Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Access Advanced or comparable knowledge.

CEU Hours: 1.4

Contact Hours: 14

Part 1 VBA Environment and Language
          Topic 1 Using the VBA Editor and Debugging Code
          Topic 2 Understanding the VBA Language Structure
          Topic 3 Understanding the VBA Language Features

Part 2 Access Object Model and Data Access Objects (DAO)
          Topic 1 Applying the Access Object Model
          Topic 2 Understanding the Data Access Object Model

Part 3 Working with Forms and Reports
          Topic 1 Using Forms and Events
          Topic 2 Using Form Controls and Events
          Topic 3 Creating Reports and Events 

Part 4 Application Design
          Topic 1 Building Applications
          Topic 2 Using ADO and ADOX
 
CRN Days Time Date Location Instructor Seats Open
21172 001 MT----- 06:00-09:29 PM 03/21/16-03/29/16 RC 232 Snyder B 13 of 14
21173 002 -TW---- 08:00-03:59 PM 05/10/16-05/11/16 RC 253 Tuck L 13 of 14
21902 003 --WR--- 06:00-09:29 PM 06/29/16-07/07/16 RC 252 Faculty 10 of 10
21903 004 MT----- 08:00-03:59 PM 08/01/16-08/02/16 RC 254 Faculty 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 (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.
This course is approved by the Kansas Board of Regents for guaranteed transfer among all Kansas public postsecondary institutions. Additional courses may also be eligible for transfer. Please visit the JCCC Registrar to learn more.