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

Microsoft Access

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
53474 003 ---R--- 08:00-03:59 PM 09/04/14-09/04/14 RC 232 Grandgenett C 9 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.