Access, Intermediate

CRNCEUSessionsDateDaysTimeLocationFee
Presently, this class does not have a scheduled time. Please email corporatecollege@corporatecollege.com for information on the next available offering or to request a course.
Description:
This course is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. You will consider how to maintain data consistency and integrity, customize database components, improve queries, forms, and reports, and integrate Access with other applications
Prerequisites:
ZMSA-1114: Access, Basic or basic database user skills including creating working with tables, relationships, queries, forms and reports in Access.
Comments:
Flash drive recommended. Textbook provided.
Topics Covered:
  • Controlling Data Entry.
  • Joining Tables.
  • Creating Flexible Queries.
  • Improving Forms.
  • Customizing Reports.
  • Sharing Data Across Applications.
Learning Outcomes:
Upon successful completion of this course, students will be able to:
  • Streamline data entry and maintain data integrity.
  • Join tables to retrieve data from unrelated tables.
  • Create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
  • Improve forms.
  • Customize reports to organize the displayed information and produce specific print layouts.
  • Share data between Access and other applications.
Subject Code:
ZMSA
Course Number:
1113
Corporate College West
25425 Center Ridge Road
Westlake, OH 44145
Phone: 216-987-2800

CCW Map & DirectionsMap & Directions
Corporate College East
4400 Richmond Road
Warrensville Hts., OH 44128
Phone: 216-987-2800

CCE Map & DirectionsMap & Directions
Face Book Twitter You Tube Linked In
Email
© 2011 Corporate College, a division of Cuyahoga Community College. All rights reserved.