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
21883 005 -T----- 08:00-03:59 PM 05/24/16-05/24/16 RC 252 Tuck L 5 of 10
21884 006 MT----- 06:00-09:29 PM 06/27/16-06/28/16 Off Campus OHEC 141 Snyder B 14 of 14
21885 007 MT----- 06:00-09:29 PM 07/25/16-07/26/16 RC 253 Snyder B 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
21891 005 -TW---- 06:00-09:29 PM 05/31/16-06/01/16 RC 255 Grandgenett C 12 of 14
21892 006 -T----- 08:00-03:59 PM 06/21/16-06/21/16 RC 255 Tuck L 5 of 14
21893 007 --WR--- 06:00-09:29 PM 07/13/16-07/14/16 RC 255 Hultgren S 14 of 14
21894 008 -T----- 08:00-03:59 PM 08/02/16-08/02/16 RC 255 Tuck L 12 of 14
23376 009 ----F-- 08:00-03:59 PM 09/23/16-09/23/16 Off Campus LPC B Faculty 14 of 14
23377 010 ----F-- 08:00-03:59 PM 10/14/16-10/14/16 Off Campus OHEC 141 Faculty 14 of 14
23378 011 --WR--- 06:00-09:29 PM 11/02/16-11/03/16 RC 254 Faculty 14 of 14
23380 012 -T----- 08:00-03:59 PM 12/06/16-12/06/16 RC 253 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
21895 003 MT----- 06:00-09:29 PM 06/13/16-06/14/16 RC 255 Grandgenett C 12 of 14
21896 004 --W---- 08:00-03:59 PM 07/06/16-07/06/16 RC 255 Tuck L 7 of 14
21897 005 --WR--- 06:00-09:29 PM 07/20/16-07/21/16 RC 255 Grandgenett C 14 of 14
21898 006 -T----- 08:00-03:59 PM 08/09/16-08/09/16 RC 255 Tuck L 13 of 14
23381 007 MT----- 06:00-09:29 PM 10/24/16-10/25/16 RC 255 Faculty 14 of 14
23382 008 ---R--- 08:00-03:59 PM 12/08/16-12/08/16 RC 253 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
21899 003 --WR--- 06:00-09:29 PM 06/22/16-06/23/16 RC 255 Grandgenett C 12 of 14
21900 004 --WR--- 06:00-09:29 PM 07/27/16-07/28/16 RC 255 Grandgenett C 14 of 14
21901 005 ---R--- 08:00-03:59 PM 08/18/16-08/18/16 RC 255 Grandgenett C 12 of 14
23383 006 MT----- 06:00-09:29 PM 10/31/16-11/01/16 RC 254 Faculty 14 of 14
23384 007 -T----- 08:00-03:59 PM 12/13/16-12/13/16 RC 234 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
21902 003 --WR--- 06:00-09:29 PM 06/29/16-07/07/16 RC 234 Faculty 10 of 10
21903 004 MT----- 08:00-03:59 PM 08/01/16-08/02/16 RC 254 Faculty 13 of 14
23385 005 --WR--- 08:00-03:59 PM 12/14/16-12/15/16 RC 254 Faculty 14 of 14

XCOA 1011 - Access 2016 Fundamentals

Cover the basic functions and features of Access 2016. Learn the skills necessary to create a new database, construct data tables, design forms and reports, and create queries. 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

Lesson 1: Getting Started with Access 
Topic A: Orientation to Microsoft Access 
Topic B: Create a Simple Access Database 
Topic C: Get Help and Configure Options in Microsoft Access 
Lesson 2: Working with Table Data 
Topic A: Modify Table Data 
Topic B: Sort and Filter Records 
Lesson 3: Querying a Database 
Topic A: Create Basic Queries 
Topic B: Sort and Filter Data in a Query 
Topic C: Perform Calculations in a Query 
Lesson 4: Using Forms 
Topic A: Create Basic Access Forms 
Topic B: Work with Data on Access Forms 
Lesson 5: Generating Reports 
Topic A: Create a Report 
Topic B: Add Controls to a Report 
Topic C: Enhance the Appearance of a Report 
Topic D: Prepare a Report for Print 
Topic E: Organize Report Information 
Topic F: Format Reports 
 
CRN Days Time Date Location Instructor Seats Open
23387 001 MT----- 06:00-09:29 PM 10/03/16-10/04/16 RC 232 Faculty 14 of 14
23388 002 M------ 08:00-03:59 PM 11/14/16-11/14/16 RC 253 Faculty 14 of 14

XCOA 1012 - Access 2016 Intermediate

Expand your knowledge of relational database design, write advanced queries, and structure existing data. Students will also learn how to validate data entered into a database and customize reports. 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 2016 Fundamentals or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Lesson 1: Designing a Relational Database 
Topic A: Relational Database Design 
Topic B: Create a Table 
Topic C: Create Table Relationships 
Lesson 2: Joining Tables 
Topic A: Create Query Joins 
Topic B: Relate Data Within a Table 
Topic C: Work with Subdatasheets 
Lesson 3: Using Data Validation 
Topic A: Use Field Validation 
Topic B: Use Form and Record Validation 
Lesson 4: Creating Advanced Queries 
Topic A: Create Parameter Queries 
Topic B: Summarize Data 
Topic C: Create Subqueries 
Topic D: Create Action Queries 
Topic E: Create Unmatched and Duplicate Queries 
Lesson 5: Organizing a Database for Efficiency 
Topic A: Data Normalization 
Topic B: Create a Junction Table 
Topic C: Improve Table Structure 
Lesson 6: Using Advanced Reporting Techniques 
Topic A: Include Control Formatting in a Report 
Topic B: Add a Calculated Field to a Report 
Topic C: Add a Subreport to an Existing Report
 
CRN Days Time Date Location Instructor Seats Open
23389 001 M------ 08:00-03:59 PM 11/21/16-11/21/16 RC 253 Faculty 14 of 14

XCOA 1013 - Access 2016 Advanced

Explore advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, and preparing a database for multi-user access. Discover how to share data across applications and use macros to improve user interface design. 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 2016 Intermediate or comparable knowledge.

CEU Hours: .7

Contact Hours: 7

Lesson 1: Implementing Advanced Form Design
Topic A: Add Controls to Forms
Topic B: Enhance Navigation and Organization of Forms
Topic C: Apply Conditional Formatting
Lesson 2: Sharing Data Across Applications
Topic A: Import Data into Access
Topic B: Export Access Data
Topic C: Link Tables to External Data Sources
Topic D: Create a Mail Merge
Lesson 3: Using Macros to Improve User Interface Design
Topic A: Create a Macro
Topic B: Restrict Records Using a Condition
Topic C: Validate Data Using a Macro
Topic D: Automate Data Entry Using a Macro
Lesson 4: Using VBA
Topic A: Getting Started with VBA
Topic B: Enhance Access Using VBA
Lesson 5: Using Advanced Database Management
Topic A: Manage a Database
Topic B: Determine Object Dependency
Topic C: Document a Database
Lesson 6: Distributing and Securing a Database
Topic A: Splitting a Database for Multiple User Access
Topic B: Implement Security
Topic C: Convert an Access Database to an ACCDE File
Topic D: Package a Database with a Digital Signature
Lesson 7: Managing Switchboards
Topic A: Create a Database Switchboard
Topic B: Modify a Database Switchboard
Topic C: Set Startup Options
 
CRN Days Time Date Location Instructor Seats Open
23390 001 ---R--- 08:00-03:59 PM 12/01/16-12/01/16 RC 253 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.