Order By 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
53446 23 M------ 08:00-03:59 PM 10/13/14-10/13/14 RC 221 Tuck L 10 of 14
53447 24 ----F-- 08:00-03:59 PM 10/24/14-10/24/14 Off Campus OHEC 131 Snyder B 10 of 14
53448 25 M------ 08:00-03:59 PM 11/03/14-11/03/14 RC 221 Tuck L 12 of 14
53449 026 --WR--- 06:00-09:29 PM 12/03/14-12/04/14 RC 255 Coon C 13 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
53452 016 ---R--- 08:00-03:59 PM 10/09/14-10/09/14 RC 221 Grandgenett C 10 of 14
53458 018 --W---- 08:00-03:59 PM 11/12/14-11/12/14 Off Campus OHEC 131 Friedrichsen L 7 of 14
53459 019 ---R--- 08:00-03:59 PM 11/13/14-11/13/14 RC 221 Tuck L 11 of 14
53460 020 --WR--- 06:00-09:29 PM 12/10/14-12/11/14 RC 255 Snyder B 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 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
53463 016 ---R--- 08:00-03:59 PM 10/23/14-10/23/14 RC 221 Tuck L 8 of 14
53465 018 ---R--- 08:00-03:59 PM 11/20/14-11/20/14 RC 221 Tuck L 8 of 14
53466 019 M------ 08:00-03:59 PM 12/01/14-12/01/14 Off Campus OHEC 131 Snyder B 10 of 14
53467 020 --WR--- 06:00-09:29 PM 12/17/14-12/18/14 RC 255 Faculty 13 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
53469 005 --WR--- 06:00-09:29 PM 11/05/14-11/06/14 RC 253 Grandgenett C 13 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
53470 004 ---R--- 08:00-03:59 PM 10/16/14-10/16/14 RC 254 Tuck L 11 of 14
53471 005 --WR--- 06:00-09:29 PM 11/12/14-11/13/14 RC 232 Snyder B 11 of 14

XCOA 5003 - Web-based: Introduction to Microsoft Access 2010

Take control over your data! Whether you're a novice or an experienced database user, this course will show you how to harness the full power of Microsoft Access 2010. In these practical and project-oriented lessons, you'll learn how to use this award-winning MS Office software to create and customize tables. You'll build relationships between your tables to eliminate redundancies and slash data entry time. And you'll discover how to achieve huge reductions in data entry errors by setting default values, creating validation rules, and building input masks. For more information about this online class and/or additional start dates, visit: http://www.jccc.edu/enroll/ce/ways-to-register/ed2go.html

CEU Hours: 2.4

Contact Hours: 24

 
CRN Days Time Date Location Instructor Seats Open
54431 510 CEONL ------- - 10/15/14-12/05/14 Online Faculty 99 of 100
54424 511 CEONL ------- - 11/12/14-01/02/15 Online Faculty 100 of 100

XCOA 5007 - WB: Introduction to Microsoft Access 2013

Take control of your data! In this course, you'll learn how to harness the power of Microsoft Access 2013 to organize, store, edit, manage, and report on hundreds of thousands of records. You'll start with the basics of database concepts and structure, and learn to build and customize tables to store data. With that foundation in place, you'll then learn about relational databases, and see how you can use them to build forms, generate reports, and search for data with queries across thousands of records in hundreds of tables-often with just a few clicks of your mouse! You'll also discover how to use macros to automate repetitive tasks and increase your efficiency. Through easy-to-follow, step-by-step instructions, this course will help you master Access and put it to creative, confident use. You'll develop not only strong Access skills, but a solid understanding of good database design concepts. By the time you've finished the course, you'll know how to organize and assemble an effective database for any kind of information you need to store, document, and manage. To enroll or for more information about this online class and/or additional start dates, visit http://www.jccc.edu/enroll/ce/ways-to-register/ed2go.html

CEU Hours: 2.4

Contact Hours: 24

 
CRN Days Time Date Location Instructor Seats Open
54412 510 CEONL ------- - 10/15/14-12/05/14 Online Faculty 99 of 100

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
90378 001 ---R--- 08:00-03:59 PM 01/15/15-01/15/15 Off Campus OHEC 131 Faculty 14 of 14
90379 002 ----F-- 08:00-03:59 PM 01/30/15-01/30/15 RC 252 Faculty 10 of 10
90380 003 ----F-- 08:00-03:59 PM 02/06/15-02/06/15 RC 252 Faculty 10 of 10
90381 004 --WR--- 06:00-09:29 PM 02/18/15-02/19/15 RC 254 Faculty 14 of 14
90382 005 --WR--- 06:00-09:29 PM 03/04/15-03/05/15 RC 254 Faculty 14 of 14
90383 006 --W---- 08:00-03:59 PM 03/18/15-03/18/15 RC 254 Faculty 14 of 14
90384 007 M------ 08:00-03:59 PM 03/23/15-03/23/15 RC 254 Faculty 14 of 14
90385 008 --WR--- 06:00-09:29 PM 04/01/15-04/02/15 Off Campus OHEC 131 Faculty 14 of 14
90386 009 --W---- 08:00-03:59 PM 04/15/15-04/15/15 RC 254 Faculty 14 of 14
90387 010 MT----- 06:00-09:29 PM 05/04/15-05/05/15 RC 252 Faculty 10 of 10
90388 011 --W---- 08:00-03:59 PM 05/13/15-05/13/15 RC 252 Faculty 10 of 10

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
90440 001 ----F-- 08:00-03:59 PM 01/23/15-01/23/15 Off Campus OHEC 131 Faculty 14 of 14
90441 002 -T----- 08:00-03:59 PM 02/10/15-02/10/15 RC 254 Faculty 14 of 14
90442 003 --WR--- 06:00-09:29 PM 02/25/15-02/26/15 RC 238 Faculty 14 of 14
90443 004 --WR--- 06:00-09:29 PM 03/11/15-03/12/15 RC 234 Faculty 14 of 14
90444 005 M------ 08:00-03:59 PM 03/30/15-03/30/15 RC 254 Faculty 14 of 14
90445 006 MT----- 06:00-09:29 PM 04/13/15-04/14/15 Off Campus OHEC 131 Faculty 14 of 14
90446 007 ---R--- 08:00-03:59 PM 04/23/15-04/23/15 RC 254 Faculty 14 of 14
90447 008 MT----- 06:00-09:29 PM 05/11/15-05/12/15 RC 255 Faculty 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
90448 001 M------ 08:00-03:59 PM 01/26/15-01/26/15 Off Campus OHEC 131 Faculty 14 of 14
90449 002 ----F-- 08:00-03:59 PM 02/13/15-02/13/15 RC 254 Faculty 14 of 14
90450 003 MT----- 06:00-09:29 PM 03/02/15-03/03/15 RC 252 Faculty 10 of 10
90451 004 MT----- 06:00-09:29 PM 03/16/15-03/17/15 RC 254 Faculty 14 of 14
90452 005 -T----- 08:00-03:59 PM 04/07/15-04/07/15 RC 254 Faculty 14 of 14
90453 006 MT----- 06:00-09:29 PM 04/20/15-04/21/15 Off Campus OHEC 131 Faculty 14 of 14
90454 007 --W---- 08:00-03:59 PM 04/29/15-04/29/15 RC 252 Faculty 10 of 10

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
90455 001 ----F-- 08:00-03:59 PM 02/20/15-02/20/15 RC 252 Faculty 10 of 10
90456 002 --WR--- 06:00-09:29 PM 03/25/15-03/26/15 RC 254 Faculty 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
90457 001 ---R--- 08:00-03:59 PM 03/05/15-03/05/15 RC 254 Faculty 14 of 14
90458 002 MT----- 06:00-09:29 PM 03/30/15-03/31/15 RC 252 Faculty 10 of 10

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
90459 001 --WR--- 06:00-09:29 PM 01/07/15-01/08/15 RC 234 Faculty 14 of 14
90460 002 M------ 08:00-03:59 PM 04/06/15-04/06/15 RC 234 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 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
90461 001 MT----- 06:00-09:29 PM 01/26/15-01/27/15 RC 234 Faculty 14 of 14
90462 002 M------ 08:00-03:59 PM 04/27/15-04/27/15 RC 234 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 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
90463 001 --WR--- 06:00-09:29 PM 02/04/15-02/05/15 RC 234 Faculty 14 of 14
90464 002 M------ 08:00-03:59 PM 05/04/15-05/04/15 RC 234 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.